Passing in query as parameter

[teresni]

I am trying to pass the actual query string as a parameter because the where clause varies depending on selections users make from front-end web app. The parameter is defined and passed fine because I display it at the top of the report page for testing purposes.

 

But when I try to use it in the following way:

<queryString>

<![CDATA[{$P{Report_Query}]]>

</queryString>

I get an error 'Error executing SQL statement for report'.

 

The exact same report works fine if I just hardcode the query string in instead of trying to use the parameter. How can I get the queryString to work with a parameter??

[teresni]

Figured it out...

 

I should have had

<![CDATA[$P!{Report_Query}]]>

 

I don't really know why I need that extra !,

but it works with it.