RE: [Rlib-users] odd rlib_add_query_as() behaviour

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

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