Re: Dynamic Reports in Reports Version3?

I can address the choice of columns and query, but not the breaks, I haven't done that part. For columns, we are allowing the users to click on a checkbox for each field that they want to include/exclude. Then we test for yes/no and return true/false accordingly in the report field level triggers for both the label and the field. Also, I anchor them together to move them over if a field has been excluded. This works fairly well. For the dynamic search capability, use a lexical variable for your where clause and build it from your front end. I chose to use Oracle Forms instead of the parameter form from reports. It's worked out fairly well except for one problem, which I will post when I'm finished here. Good Luck. In article <75mjb2$f9c_at_news1.ee.net>, "Kurt Manecke" <kmanecke_at_ee.net> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 23 1998 - 17:33:12 CET