Query crosstab with postgresql


Hello guys; I have crosstab query created in postgres; I want to use this query to generate my report, and it works perfectly in the database (postgres) and also works in jasper when I leave the static settings inside the query, when I add parameters the Jaspersoft Studio Query Dialog does not accept the query and informs this error:

"org.postgresql.util.PSQLException: The column index is out of range: 2, number of columns: 0.".

and also shows how the parameter was inside the query

How do I move the parameters from my query

henrique.santos1988's picture
Joined: Jan 9 2018 - 8:26am
Last seen: 1 year 3 months ago

0 Answers:

No answers yet