0

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?

Iain
  • 387
  • 2
  • 12

2 Answers2

1

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

GandRalph
  • 590
  • 2
  • 10
  • I'm not sure this fixes it. I have set available values (a list, retrieved by a query), and a default value. However, the dropdown menu for picking an available parameter value is never shown. The report just autoruns with the default value. – Iain Apr 19 '17 at 15:24
  • 2
    Go to the general tab on above screen. You will see a section called "Select Parameter Visibility". Make sure this is set to Visible. – GandRalph Apr 19 '17 at 15:31
  • They are set to visible. If you remove the default parameter they become visible, it's just that adding a default parameter completely removes the option to select a parameter. Maybe this is intended behaviour (that default parameters and regular parameters can't be combined, but I don't think it should be...) – Iain Apr 20 '17 at 07:12
  • 1
    @Iain Can you provide a screenshot illustrating how the parameters look when the report is run? – BishNaboB Apr 20 '17 at 13:42
0

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.

Iain
  • 387
  • 2
  • 12