Multiple values parameter - Jasperserver Pro

[chiricoluca87]

Hi, we are trying to create a multi-value parameter that allows us to filter a report based on a list provided by the user. It could by uploading a file or simply a copy and paste the values in a text box

The problem we have is that the field on which we have to build the filter has a very high number of distinct values, so creating it by the ad hoc editor in not efficient since the user that should filter 50/100 values has to pick them from a giant list of values that is also risks to make the system too slow.

To summarize we need a method to filter a primary key(more than 1mln values) of our table using a list of values provided by the user in real time.

 

Thanks

 

 

[hozawa]

Had a similar situation. I just wrote a web program to accept values from a web page and used JasperReports library to generate a report.