I am using Jasperserver 5.5 and JasperSudio 5.5. I have created a report using the Blank Table Based Template in JasperStudio. The report has a heading with a table in the summary band containing all of the information.
The report runs great but I would like to add some input controls to the report. The report contains sales data for multiple stores, for multiple days. Right now I have the sales data limited to all stores for one day. Ideally I would like to have multiple controls, but to start off I would just like to get an input control working so that i can pick only a certain store.
I have tried multiple combinations of adding parameters and putting them in my query but I cant get anything to work properly. I am wondering if the input control does not apply for the tableset query (the main report does not have a query). There also does not appear to be a good way of adding an input control from the JasperStudio interface.
Any tips or advice would be appreciated. I will be more than happy to upload an examples or screenshots if needed.
I finally figured out the issue.
Since I was using a table in my report, I had to create a paramater in the main report that matched my input control on the JasperServer website. I then had to create another paramater in the subquery and include that parameter in my query. Then, under my table element I selected the Paramater tab and linked the two parameters together.
Since i was using a multiple Selection Checkbox on my site, I had to set the Paramaters up with the ArrayList class and the Nested Type Class as Integer (since im using numeric values in my input control).
It took me forever to figure out all of the little nuiances so if anyone needs help feel free to message me and i will share my information.