ReportServer Forum

gokhankilic

Member

Registered: 2023-11-22

ReportServer 4.6.1 Dropdown Bug

Hello,

We are using Report Server RS4.6.1-6100 (2023-11-01-05-06-17) version and we have faced a bug while executing our jasper report.

Scenario:

When we create a jasper report with dropdown parameter that includes ${} paramter instance inside its query like below;
SELECT * FROM users WHERE company_id =$P{CompanyId}; 

Report is not being executed.Displays an error like below;

Error: An error occurred during report execution.
The report could not be executed: JRRuntimeException: Parameter "CompanyId" does not exist.
To get help please contact an administrator.
Details
Report could not be executed. {"error":"JRRuntimeException: Parameter \"CompanyId\" does not exist.","report_id":12347529,"report_name":"COURSE COMPLETION REPORT-with total time","base_report_id":12347529,"base_report_name":"COURSE COMPLETION REPORT-with total time","executing_user_id":6,"report_output_format":"PDF","report_uuid":"d1a58992-6192-4343-a7fd-ef70797df852"} net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: JRRuntimeException: Parameter "CompanyId" does not exist. at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:280) at......

But when we change the selection style to different type other than dropdown such as pop up, we are able to execute report.

Kind Regards.