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

[Al A. <aa...@ge...>]

Can I add a report part inside a <break> section?

I'd like to display data within the 'summary' section of a report.


-----Original Message-----
From: Bob Doan [mailto:bd...@si...]
Sent: Wednesday, April 20, 2005 7:43 AM
To: Al Arzaga
Cc: RLIB USERS
Subject: RE: [Rlib-users] odd rlib_add_query_as() behaviour


Al,

There are two ways

1) Call multiple rlib_add_report

2)  Use parts

<pr>
  <pd>
    <Report>.....</Report>
  </pd>
</pr>
<pr>
  <pd>
    <Report>.....</Report>
  </pd>
</pr>
<pr>
  <pd>
    <Report>.....</Report>
  </pd>
</pr>


- bob

On Tue, 2005-04-19 at 14:48 -0500, Al Arzaga wrote:
> If I were to concatenate reports, what should be done?
> 
> 
> -----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



-------------------------------------------------------
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