how to enter comma separated values as input parameter in jasperserver

[harismitacbe]

For member id input parameter, currently there is multi select input parameter 


Server :


I need to give the same memberid input parameter as comma separated values instead of multi select values. 

Please help. 

Also, is it possible to cascade the date range so that only the available member id values will be displayed if comma separated wont work. 

Stuck in both. Either need comma separated values as input parameter or cascade date range. Kindly help. 

Thanks, 

Harismita

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Badr Draifi]

Hi Harismitacbe, not sure what you are trying to achieve, do you want to have one memberId value that has multiple memberids with spearted comma ? could you please explain more what is the desired outcome? 

Anyway, you can do both separated commas and cascading in jaspersoft, see below for examples : 
 

• Separated comma :

https://community.jaspersoft.com/questions/537867/list-comma-separated-values

https://community.jaspersoft.com/questions/1141831/how-convert-values-certain-colum-comma-separated-list

• Cascading : 

https://community.jaspersoft.com/wiki/cascading-input-controls

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v60/cascading-input-controls#:~:text=A%20cascading%20input%20control%20is,another%20query%2Dbased%20input%20control.

https://community.jaspersoft.com/wiki/video-implementing-cascading-input-controlsfilters-ad-hoc-reports

[harismitacbe]

Hi Bdraifi,

In UCCD_TMCODE i have 1 lakh values. In the input I want to enter specific 10 or 15 UCCD_TMCODE values using comma. The desired outcome is data should get populated for all the mentioned comma separated UCCD_TMCODE

[harismitacbe]

Also if i create a variable as mentioned in  the answer, there is no option for group under Reset type 

[Badr Draifi]

To have a group option under Reset type, you'll have to create the group, see here https://community.jaspersoft.com/blog/playing-variables-group-level-summations-increment-type-and-reset-type-multi-level-group

For : 
In UCCD_TMCODE i have 1 lakh values. In the input, I want to enter specific 10 or 15 UCCD_TMCODE values using comma. The desired outcome is data should get populated for all the mentioned comma-separated UCCD_TMCODE. 

=> You can use a query in your input controls that returns the value of the field presented as multi-select like shown in your question, then create a variable that will take the values of your multi-select param and create one value with the selected fields separated by a comma using Java tools. Then use this variable in a non prompt param that you'll pass to your jrxml query.