teresni Posted May 3, 2007 Share Posted May 3, 2007 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?? Link to comment Share on other sites More sharing options...
teresni Posted May 3, 2007 Author Share Posted May 3, 2007 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now