Re: Dynamic Reports in Reports Version3?

A quick and dirty trick is to build a procedure that fills a temporary table in exactly your report layout, including the headings and breaks. Then print the contents of this temporary table using reports and after that delete the temporary table.

The fill-procedure can be called from the before report trigger and the delete procedure from the after report trigger. (if these are still there in Reports 3.0)

Your table would look like this:

report_temp
( line# number
, text varchar2(<whatever your linesize is>) )
If multiple sessions use this report simultaniously, you can add an identifier column to the table to identify each session.

In your report just select text from report_temp order by line#.

If you find another way to do this, please let me know.

Pieter.

Kurt Manecke wrote:

> I have been given a task of developing somewhat of a dynamic report. There
> is one table involved. The users will see a screen which lets them pick
> which columns to include in the report, parameters for each column (i.e.
> search criteria), which columns to sort on, as well as which field(s) to
> perform a summary on (breaks). Is something like this possible with Reports
> Version 3? Can I change the SQL query/Order by at runtime? Can I add breaks
> at runtime? This sounds to me like I should recommend they purchase an
> end-user reporting tool, but my boss wants it done in Reports. I know I
> could give them Reports, and tell them to use the Report Wizard, but that is
> not an option. Any pointers on how to approach this would be greatly
> appreciated.
>
> Kurt Manecke
> kmanecke_at_ee.net
Received on Wed Dec 23 1998 - 00:52:30 CET