Hello Community,
We created a report in jasperstudio where its datasource is the Service Desk Manager Database . We're extracting information from the cr table (Ticket number, group, category, etc).
We' re trying to use a parameter that we created called Categories to use it in an input control of Multi Value Query of sdm categories.
In the query we already set the WHERE CLAUSE with $X(IN, category_symbol, Categories).
We created the Input control in Jasper Server with the same name of the parameter (Categories).
When we run the report, it shows us all categories right, but when we select one or more to filter data it shows the following error:
*******************************************
The server has encountered an error. Please excuse the inconvenience.
Error Message
Error filling report
Error Message
net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query: SELECT ref_num, affected_end_user_combo_name, open_date, close_date, category_symbol, group_name, assignee_combo_name, priority_description, type_symbol, predicted_sla_violation FROM cr WHERE category_symbol IN (?, ?) ORDER BY open_date DESC
*******************************************
QUERY:
SELECT ref_num,
affected_end_user_combo_name,
open_date,
close_date,
category_symbol,
group_name,
assignee_combo_name,
priority_description,
type_symbol,
predicted_sla_violation
FROM cr
WHERE $X{IN, category_symbol, Categorias}
ORDER BY open_date DESC
Please help!
Regards,