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

[Pavan_123456789]

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.

[v-xuxinyi-msft]

Hi @Pavan_123456789 

The following testing is for your reference.

My data source is SQL Server and then I configured two parameters.

1. Configure each of them as shown below.

The Customer parameter is configured the same way.

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pavan_123456789]

Hi @v-xuxinyi-msft ,

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?

[v-xuxinyi-msft]

Hi @Pavan_123456789 

The following test is for your reference:

Extract the corresponding fields of the parameters as separate datasets.

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.

Create a filter for the Dataset containing all fields.

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.

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pavan_123456789]

Hi @v-xuxinyi-msft ,
Thank you for your response.
Could you please clarify how you used the following SQL query?

SELECT test_Default_Paginated.Customer
FROM test_Default_Paginated
Is this taken from SQL Query?If yes what steps i need to  follow?

[v-xuxinyi-msft]

Hi @Pavan_123456789 

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.

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

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.

If the value of the parameter is not a separate dataset, the following error will be reported when running this report.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pavan_123456789]

Hi @v-xuxinyi-msft 

Could please let me know where to create the sql Query?Is it created in Sql or have you created directly in Paginated Reports ?

[v-xuxinyi-msft]

Hi @Pavan_123456789 

I created it directly in the paginated report.

1. add dataset

2. Use the above SQL statement in Query

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.