Re: How to pass a query to a report at runtime

I think what you are looking for is 'literals' in reports. Using 'literals' you can sub any part of the where and order clause easily. You will need to create a user parameter and then the &variablename that you defined. On your parameter form allow for either the entry of text adhoc or create radio buttons, etc to accept input.

Alternatively you do something similar but store the where clauses in tables and read them in at runtime. Oracle does something similar with their ROUTING tables in their Oracle Applications.

On Tue, 05 Aug 2003 06:12:02 +0000, Manikandan <member12054_at_dbforums.com> wrote:

>
>Hi,
>I need to pass a query as a parameter to the report.My report should
>contain the query output.
>The report columns are same.But the rows will be varying according to my
>input query.
>Can anybody please tell me how to acheive this?

MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com
bsc7080mqc_at_mylxhp.com
(replace mylxhp with mylxhq to reply/contact) Received on Tue Aug 05 2003 - 13:05:26 CEST