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