Re: [Rlib-users] Many queries on same report

[Bob D. <bd...@si...>]

Hi,

Ok.. the idea is to rlib_add_query_as all of your queries in
Then you can rlib_add_report(r, "xml file", "main loop query name from
rlib_add_query_as")

When you call rlib_execute it first tells the "data source" to execute
all of the queries, then it loads all the XML files.. then it runs the
XML files one at a time.. concatinating the reports 

the rlib_add_resultset_follower is for having more then one main loop
query.. ie.. if you had one resultset for the year 2000, and a sorta
idential one for the year 2001 (note.. the number of rows in each should
match).. you can tell rlib that when it's stepping through the 2000
result set.. it should do the same on the 2001..

so in your XML file... you might reference data data by: y2000.somefield
or y2001.somefield .. assuming you named the queries "y2000" and "y2001"

NOTE:  In the same report you can have data from different datasources..
so If you had 2 different mysql serevrs.. or even a mysql and a
postgresql.. or whatever :)

The only way to have different detail sections is to have different XML
files.. there are tricks you can play w/ Xpointer and Xinclude sutff..
but Chet knows more about that then I do.... actually using "iif" you
can give the illusion of different detail sections.. you can suppress a
line from a variable (maybe a "m." one you set from php)

- Bob

On Wed, 2004-02-18 at 16:13, Franco Spinelli wrote:
> There is any example of using different queries/xml definitions ?
> "Rlib_add_query_as" define different queries, identified by name in XML
> file.
> "Rlib_add_report" add different XML files ? How are used ?
> How work "rlib_add_resultset_follower" ? How can I use "more than one
> main loop" Can I have different <Detail> sections ?
> 
> Regards
> Franco Spinelli
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users