Menu
▾
▴
RE: [Rlib-users] odd rlib_add_query_as() behaviour
|
From: Bob D. <bd...@si...> - 2005-04-19 15:13:04
|
Then you probably want to use a follower rlib_add_resultset_follower(rlib, LEADER, FOLLOWER); The makes rlib move the follower query the same way as the leader Only use this if there are going to be the same number of rows in the LEADER and the FOLLOWER Keep in mind by default per report RLIB is only going to navigate one result set. - bob On Tue, 2005-04-19 at 10:10 -0500, Al Arzaga wrote: > side-by-side. > > > -----Original Message----- > From: Bob Doan [mailto:bd...@si...] > Sent: Tuesday, April 19, 2005 10:08 AM > To: Al Arzaga > Cc: RLIB USERS > Subject: RE: [Rlib-users] odd rlib_add_query_as() behaviour > > > Are you looking to do side by side or concatenation of reports? > > - bob > > On Tue, 2005-04-19 at 10:04 -0500, Al Arzaga wrote: > > When adding a query="'something_else'" to the report's xml > > it is from that query that the report part iterates through a data set. > > > > Is there a way to have a second query's data set be included in that > report > > part so that it, too iterates, through the report? They both will contain > > the same number of rows/records. > > > > > > > > > > -----Original Message----- > > From: Bob Doan [mailto:bd...@si...] > > Sent: Friday, April 01, 2005 12:07 PM > > To: Al Arzaga > > Cc: RLIB USERS > > Subject: Re: [Rlib-users] odd rlib_add_query_as() behaviour > > > > > > Hi, > > > > The first query added to RLIB is the "Main Loop" Query. That drives the > > number of ROWS. > > > > In the <Report> > > > > tag you can have a query="'something_else'" to override this > > > > On Fri, 2005-04-01 at 10:54 -0600, Al Arzaga wrote: > > > Hi, again > > > > > > I'm trying to implement something similar to that of RLIB's > > > flow_part.php/flow_part.xml example. > > > > > > What I'm seeing is a weird behavior where if I were to switch the order > > > of the rlib_add_query_as() calls, I get different results. The output > > > of the second result set ends up displaying only as many as the row > > > count of the first result set. > > > > > > In the context of the flow_part example, for instance, you have the > > > arrays data, with 5 rows in the result set, and moredata, with 59. My > > > resulting output would show 5 rows for both sets of data in the > > > resulting output. If I were to switch the order of the > > > rlib_add_query_as() calls, I'd get all sets of data to appear. > > > > > > Now, this isn't what I see with _the_ example code. I'm only > > > explaining my problem in terms of the example code just so that people > > > can get the general idea. > > > > > > What I'm wondering is if others have seen this problem. PHP code > > > snippet: > > > > > > $rlib = rlib_init(); > > > rlib_add_datasource_array($rlib, "local_array"); > > > rlib_add_query_as($rlib, "local_array", "main_array", "main_array"); > > > > > // switching this with > > > rlib_add_query_as($rlib, "local_array", "op_array", "op_array"); > > > > > // this gives different results. > > > rlib_add_report($rlib, "main.xml"); > > > rlib_set_output_format_from_text($rlib, $format); > > > rlib_execute($rlib); > > > > > > Size of main_array result set is 1. Size of op_array result set is 78. > > > Depending on which is called first, I get either a single listing for > > > op_array in the report, or all 78. > > > > > > > > > -Al > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > SF email is sponsored by - The IT Product Guide > > Read honest & candid reviews on hundreds of IT Products from real users. > > Discover which products truly live up to the hype. Start reading now. > > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > > _______________________________________________ > > Rlib-users mailing list > > Rli...@li... > > https://lists.sourceforge.net/lists/listinfo/rlib-users > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: New Crystal Reports XI. > > Version 11 adds new functionality designed to reduce time involved in > > creating, integrating, and deploying reporting solutions. Free runtime > info, > > new features, or free trial, at: http://www.businessobjects.com/devxi/728 > > _______________________________________________ > > Rlib-users mailing list > > Rli...@li... > > https://lists.sourceforge.net/lists/listinfo/rlib-users > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: New Crystal Reports XI. > Version 11 adds new functionality designed to reduce time involved in > creating, integrating, and deploying reporting solutions. Free runtime info, > new features, or free trial, at: http://www.businessobjects.com/devxi/728 > _______________________________________________ > Rlib-users mailing list > Rli...@li... > https://lists.sourceforge.net/lists/listinfo/rlib-users |
