Re: [Rlib-devel] [RFE] A query should only run one if it's fields put into ReportHeader

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

Hym...

You can use query="'something'" in the XML 


Would that do???

On Sat, 2005-12-17 at 21:22 +0100, Zoltan Boszormenyi wrote:
> Hi,
> 
> I have a problem creating a report in RLIB in which I would like to
> put fields from a one-row query into either ReportHeader or PageHeader.
> If I define my queries in this order:
> 
>   rlib_add_query_as(r, "mainsource", query2, "headerquery");
>   rlib_add_query_as(r, "mainsource", query1, "list");
> 
> then only the first row of the list appears. If they are defined in 
> reverse order,
> everything appears correctly, but from the fact above, I guess the my 
> "headerquery"
> is actually run for every row of my "list" query.
> 
> Hence the request for enhancement: I would like RLIB to recognize this 
> condition
> automatically or some queries could be tagged for such application.
> It would obviously increase performance as these kinds of queries would 
> run through
> only once.
> 
> The same applies for PageHeader with a little twist. There may be 
> applications
> where a PageHeader would be the same on every page or they may differ.
> If a query has only one row, it's field values should be presented on 
> every page.
> If the query has more than one row, then it should be selectable whether
> the data from the first row would appear on every page or the rows are 
> iterated
> for the pages.



You could probably use a N to 1 follower here and align the datafield
with r.pageno

Cheers

- Bob