Jump to content
Changes to the Jaspersoft community edition download ×

Passing in query as parameter


teresni

Recommended Posts

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

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...