Passing Query as parameter

[prashantckc]

Hi All

I need to pass the Entire SQL query as a parameter.

Kindly Suggest how can we acheive the same?

[haiku]

Create a report parameter that will hold the query - say, P_REPORT_QUERY.
Then set the report's query to be this parameter, using $P!{...} syntax instead of just $P{...}. Like this: $P!{P_REPORT_QUERY}.

 

Code:

<queryString>    <![CDATA[$P!{P_REPORT_QUERY}]]></queryString>