Select All Value in a parameter not a multivalue

[Coopbase]

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?

[Dimitar]

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:

• db2 - Adding a static value to the results of an SQL query - Stack Overflow 
• How to add static values to SQL QUERY Result set in ORACLE - Stack Overflow

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