Iain
Iain

Reputation: 387

Build report with changeable default parameters

I am creating a SSRS report with default parameters. If all parameters have a valid default value, the report runs automatically when it is first viewed. However, after autorunning in this way, it is not possible to run the report with other values than the default parameter values. Parameter input is simply hidden.

I would like to create a report that always runs with one parameter (eg. "friday"), but after running gives you the option to change that parameter (eg. to "monday") Is this possible?

Upvotes: 0

Views: 99

Answers (2)

Iain
Iain

Reputation: 387

I have found the answer to this: it turns out that parameter input is not impossible after generating a report with default parameters, the UI element is simply shrunk to a thin line, that can be expanded by clicking on it. I'm afraid the solution is that simple, and I feel silly that I overlooked it (although it is kind of hard to notice).

I will accept GrandRalph's answer as it was the most usefull.

Upvotes: 0

GandRalph
GandRalph

Reputation: 645

You have to specify available values in the below window (right click your parameter and properties). The list can be hard coded or retrieved from a dataset.

enter image description here

Upvotes: 1

Related Questions