topic Re: How to default to Select All in a Report Builder Parameter in Report Server

How to default to Select All in a Report Builder Parameter

Anonymous — Sat, 26 Dec 2020 01:39:09 GMT

I have created a Paginated Report Parameter that displays a list of Legal Entities and the user can choose one and refresh the report. I want it however to default to selecting ALL of them - but this does not seem possible?

Also - seocndary question - If ALL are selected I'd like it to say the word 'All' (or similar) in the textbox on the users screen, instead of showing the first Legal Entity even when they are ALL selected

Re: How to default to Select All in a Report Builder Parameter

lbendlin — Sun, 27 Dec 2020 02:56:17 GMT

Have you considered adding a fake "All" legal entity row to your source data, and associate it with summarized data? Alternatively you could create a calculated column or measure for this.

Re: How to default to Select All in a Report Builder Parameter

DavisBI — Sun, 27 Dec 2020 07:16:30 GMT

Hi, Anonymous ,

If you are using a relational database as a data source then you can do the trick in your SQL statement.

For example:

SELECT * FROM PRODUCT_TABLE WHERE CASE WHEN PRODUCT_NAME="All" then "All" ELSE PRODUCT_NAME END IN @PRODUCT

Then, the default value of the parameter "@PRODUCT" can be set to "All" in the report builder, so that whenever the user running the report, the filter for PRODUCT will be ignored.

Mark this post as a solution if this helps, thanks!

Re: How to default to Select All in a Report Builder Parameter

yashvardhan143 — Tue, 11 Nov 2025 13:59:08 GMT

Any idea to implement this if we are creating a semantic model to create the paginated reports?