Re: Oracle reports with queries

Both ways that you mention are possible.

You can create user parameters in Reports and run your report with the arguments that the user inputs.

You can also write a few lines of PL-SQL and pass the desired parameters from your Forms application to a certain report.

<green_leaf_2_at_my-deja.com> wrote in message news:8p5bfa$7gu$1_at_nnrp1.deja.com...
> I wanted to know what is the method for generating reports in Oracle,
> when you want to provide some values for certain fields, based on which
> the report is generated. For example, I may want the user to specify a
> range of dates, such as >7/12/00 and <12/12/00 or something, so as to
> generate a report giving the information for all records with dates
> lying in between those two dates...similarly, there could be some other
> fields for which also values could be specified as a range or a specific
> value.
>
> Can this be done by adding user parameter to the parameter form in
> Oracle reports? Otherwise, is there any way to connect an Oracle form
> to reports, which would allow the user to specify these criteria in the
> Oracle form, and then based on the criteria a report would be generated?
> If that is possible, I suppose, it would also be possible to provide a
> drop down list if necessary, from which the values for the
> fields/criteria could be selected. I don't suppose such a thing could
> be done by just adding user parameter to the parameter form...
>
> I would appreciate your response to this.
>
> Thanks.
>
> Suchitra
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 08 2000 - 22:19:58 CEST