Select All Value in a parameter not a multivalue

1 Answer 19 Views
General Discussions
Coopbase
Top achievements
Rank 2
Iron
Iron
Coopbase asked on 06 Mar 2024, 04:10 AM
Hello, I would like to ask how to select All Value from the parameter, this parameter is not a multivalue

This is the model that should be converted into reporting



Those data that you can see there were pulled from the database except for the <All Receipts> where if you choose that, All the data there will be selected, take note this is not a multivalue because the model has only two types of selection

1. Single selection - where you select only one from each data inside the parameter (eg. you select either BIR Receipt or Deposit etc). You cannot select two data, only one.

2. Select All - this is the <All Receipts> selection where you select all data inside the parameter.

I already did the parameter getting the data from the datasource.

Now my problem is, how can I add this customize <All Receipt> value if I'm getting the data from a database?

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 08 Mar 2024, 12:48 PM

Hello,

Thank you for the provided information!

The available selection options for report parameters with available values are based on the data returned by their data source component.

The only way to have a 'Select All' option for a report parameter that accepts only a single selection, would be to modify the SQL query so that the selection that returns the list of selectable options has this value that we will use as the 'Select All' option. You may find examples of how to do this in the following StackOverflow threads:

Please note that you would also need to update accordingly the SqlDataSource component query in which the value of the report parameter is used since <All Receipts> is not a real value and there would be errors - Using Parameters with the SqlDataSource component explained - Telerik Reporting.

I hope that this will help. Please let me know if you have additional questions.

Regards,
Dimitar
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
General Discussions
Asked by
Coopbase
Top achievements
Rank 2
Iron
Iron
Answers by
Dimitar
Telerik team
Share this question
or