Carol,
The 1st query passed to RLIB is typically the "main loop" query. This
determines the # of rows RLIB will loop through in the detail section.
If you don't want the 1st report to be the main loop query in the
<Report> tag you can set "query='some_name'"
On Tue, 2005-03-08 at 10:53 -0700, Carol Fouse wrote:
> I have several queries in the report that I am working on. One is a
> Sum of stats across regions. Another is a Total of stats by region.
> I discovered that if, in the php file, I have the Sum query (which
> yields one record) added to rlib before the Total query (which yields
> 5 records), on the report, only the first record is displayed for the
> Total query. But if I add that query to rlib before the Sum query, I
> get all 5 records. Then, there is a problem with adding the values
> from the Total query. I have a flow part xml file that loads an xml
> file for each of these queries. If I add that report to rlib, the sum
> variables do not add in the first record from the Total query (the
> first attachment). But if I add only the report xml file for the
> Total query to rlib in the php file, the first record is added in.
>
> Do you have any insight on this?
>
> - Carol
|