Parameter: Listbox with Dynamic value from DataSet is empty on the production server.

I create a parameter with data set for using with Listbox. In my birt designer with jetty, it's showed correct data from database in Listbox. I, however, deploy rptdesign file to production server (Tomcat 8, Birt 4.8, OpenJDK 8) then showed empty data in Listbox. How can I fix this issue?

Find more posts tagged with

Comments

Thun

Parameter Data Type: String

Shweta Parihar

It may be that when you deploy the report, data is not available for the report. You can confirm this by running this report without any parameter from your server, if your report still fails most likely this is the issue.

Thun

I have already fixed this issue. I found a solution at https://stackoverflow.com/questions/34984308/birt-dynamic-list-parameter-remains-empty. Ethan wrote a trick to show error in Tomcat. By the way, I put "reportContext().getMessage()" command in "beforeOpen" event of DataSet that used by Parameter then look in Tomcat log. It will show some error messages about SQL Query.