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

[Zoltan B. <zb...@du...>]

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=20
reverse order,
everything appears correctly, but from the fact above, I guess the my=20
"headerquery"
is actually run for every row of my "list" query.

Hence the request for enhancement: I would like RLIB to recognize this=20
condition
automatically or some queries could be tagged for such application.
It would obviously increase performance as these kinds of queries would=20
run through
only once.

The same applies for PageHeader with a little twist. There may be=20
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=20
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=20
iterated
for the pages.

Best regards,
Zolt=E1n B=F6sz=F6rm=E9nyi