From: Bob D. <bd...@si...> - 2005-03-08 18:28:24
|
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 |