Assistance with Setting Default Parameter to "All" in Paginated Reports

Question

I am currently working with multiple text parameters (such as Country, Customer, and Category) in a paginated report and would like to set "All" as the default selection for these parameters. Could you please confirm if it's possible to configure this in the report? Additionally, any guidance or steps you could provide would be greatly appreciated.

Thank you for your support. I look forward to your response.

anonymous · Answer

Hi&nbsp;Pavan_123456789&nbsp;
&nbsp;
The following testing is for your reference.
&nbsp;
My data source is SQL Server and then I configured two parameters.

&nbsp;

&nbsp;
1. Configure each of them as shown below.

&nbsp;

&nbsp;
The Customer parameter is configured the same way.

&nbsp;

&nbsp;
Output:

&nbsp;
Best Regards,Yulia Xu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

pavan_123456789 · Answer

Hi Anonymous&nbsp;,Thank you for your previous response. I followed the steps you outlined, and they were very helpful. However, I encountered one issue:When no customer is selected, it defaults to "ALL" as expected. But when I select a particular customer, the data still reflects all customers rather than the selected one. It seems that the filter for specific customer data is not being applied.Could you please assist me in resolving this issue?&nbsp;

anonymous · Answer

Hi&nbsp;Pavan_123456789&nbsp;
&nbsp;
The following test is for your reference:
&nbsp;
Extract the corresponding fields of the parameters as separate datasets.

&nbsp;

&nbsp;
Create corresponding parameters, allowing multiple selections for the parameters, and their available values ​​(Available Values) and default values ​​(Default Values) come from the corresponding dataset.

&nbsp;

&nbsp;
Create a filter for the Dataset containing all fields.

&nbsp;

&nbsp;
It should be noted here that in my test, when I select the value of parameter, it will display "=Parameters!Country.Value(0)" by default. The 0 in the brackets represents the first data in the table. If it is in this format, then the report will only display the first data even if all parameters are selected, so we need to remove the brackets so that all the data can be displayed.

&nbsp;
Output:

&nbsp;

&nbsp;
Best Regards,Yulia Xu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

pavan_123456789 · Answer

Hi&nbsp;Anonymous&nbsp;,Thank you for your response.Could you please clarify how you used the following SQL query?SELECT test_Default_Paginated.CustomerFROM test_Default_PaginatedIs this taken from SQL Query?If yes what steps i need to&nbsp; follow?

anonymous · Answer

Hi&nbsp;Pavan_123456789&nbsp;
&nbsp;
The SQL statement I used is just to make the value of the column as parameter come from a separate dataset. The column is extracted from the data source table to make it a separate dataset.

&nbsp;
In my test, the data source I used is SQL Server. The following is the data table I used.

&nbsp;
You just need to make the value of the column used as a parameter come from a separate dataset instead of the same dataset as the one that needs to be filtered.
&nbsp;
If the value of the parameter is not a separate dataset, the following error will be reported when running this report.

&nbsp;
Best Regards,Yulia Xu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.