Menu
I've been wrestling with this one report for a long time, and finally figured out what to do but it was serendipitous .
Well I changed a parameter that depends on a previous one to be "Internal" - then everythig worked like I wanted! thanks
How does "Internal" differ from "Hidden" in SSRS?
932
Internal Parameters in SSRS are parameters that are not configurable by the end-user at run-time. This varies from a Hidden Parameter, which the user is not prompted to provide, but can still be configured through the URL to the report server.
Understanding Parameter Data Types Report parameters must be one of five data types: Boolean, DateTime, Integer, Float, or Text (also known as String). When a dataset query includes query parameters, report parameters are automatically created and linked to the query parameters.
Setting default values for multi-value parameters If we want to set Select All option as a default parameter we need to follow the steps below: Choose Get values from a query under the Default Values tab. Set HRReportParameterDataset into the Dataset Combobox. Set JobTitle field into the Value field.
To set available values for the second parameter In the Report Data pane, in the Parameters folder, right-click the first parameter, and then click Parameter Properties. In Name, verify that the name of the parameter is correct. Click Available Values. Click Get values from a query.
Internal is not exposed and you cannot pass it to the report when calling with parameters from another one. Note it will not appear at the top where the user can change it.
Hidden means that it won't show at the top of the page to allow the user to manually adjust it, but it can be passed to the report via call from another report.
I prefer to use hidden and have sensible defaults on them. In that way I can always override if I need to them when navigating between reports.
I would also look at this similar answer : What are the rules for using "Internal" parameters in SSRS. It shows a good use case for Internal parameters, which I've used on occasion too.
161
PromptUser == false --> Parameter is "Internal"
PromptUser == true && Prompt is null or empty --> Parameter is "Hidden"
PromptUser == true && Prompt is NOT null or empty --> Parameter is visible
20
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
