Apache OpenOffice Community Forum

(Oracle Report Builder) Using a macro in a form to set filter information for individual reports. Filters are updated fine, reports run fine. However, I don't know how to get at the filter in the report to display it on the report. Is there a parameter that can be accessed with a function within the report to display (print) the actual filter.
Thanks.

I think that this is not possible, but I guess there might be a way. Store the selected value of the filter in a single-row table and query that row from from your report and/or when it has to drive the selectivity of the data represented in the report, use it in the reports' driving query as well.

eremmel wrote:I think that this is not possible, but I guess there might be a way. Store the selected value of the filter in a single-row table and query that row from from your report and/or when it has to drive the selectivity of the data represented in the report, use it in the reports' driving query as well.

This is exactly how I use to do this. Search this forum for "power filtering". Power filtering filters a row set by criteria stored in a dedicated table. You can query the criteria and the row set based on that criteria.

Thanks to you both (eremmel & Villeroy).... That's kind of what I thought I'd have to do, but didn't want to re-invent the wheel if there were an easier approach