From: Franco S. <fr...@ti...> - 2004-02-18 21:20:50
|
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 |
From: Bob D. <bd...@si...> - 2004-02-19 14:14:12
|
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 |
From: Franco S. <fr...@ti...> - 2004-02-19 19:11:28
|
Hello, Il gio, 2004-02-19 alle 15:08, Bob Doan ha scritto: > 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 > Ok, this is a good idea. And there is no comunication within different XML files or is possible, in a file, get variables of another query ? > 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.. > And getting a "parallel detail" ? Regards Franco Spinelli |
From: Bob D. <bd...@si...> - 2004-02-19 20:19:00
|
> Ok, this is a good idea. And there is no comunication within different > XML files or is possible, in a file, get variables of another query ? you can.. just do query_name.field > And getting a "parallel detail" ? I don't think I understand what "parallel detail" is.. can you explain? - bob |
From: Franco S. <fr...@ti...> - 2004-02-19 20:37:32
|
Il gio, 2004-02-19 alle 21:13, Bob Doan ha scritto: > I don't think I understand what "parallel detail" is.. can you explain? > > - bob > Record1 of query1, record1 of query2, record1 of query3 .... Record2 of query1, record2 of query2, record2 of query3 .... Record3 of query1, record3 of query2, record3 of query3 .... And so on.. Regards Franco Spinelli |
From: Bob D. <bd...@si...> - 2004-02-19 21:21:53
|
> > > Record1 of query1, record1 of query2, record1 of query3 .... > Record2 of query1, record2 of query2, record2 of query3 .... > Record3 of query1, record3 of query2, record3 of query3 .... This RLIB can do rlib_add_resultset_follower(r, "query1", "query2"); rlib_add_resultset_follower(r, "query1", "query3"); then in the xml <Line> <field value="query1.field1"> <field value="query2.field1"> <field value="query3.field1"> </Line> .. an so on - bob |