May 31, 2017 at 5:37 pm
I'm very new to SSRS and need a little help figuring out this issue.
I have 2 parameters in the report, one from the stored procedure and one from a dataset reference. Both have the setting of 'Visible' turned on. The show in the design view, but do not show when I try to run/preview the report. The parameters do not show at all.
@Report Type ( WTD, MTD,...)
@Location
The @Report Type has a list of allowable values defined, and the only way I could get the report to run is to set a default value of WTD. Otherwise it was throwing an error to set the parameter...but would not display the parameter field for me to select from the allowable values.
The @ Location is using a Dataset that pulls in the available locations from one of the database tables. Then I have the parameter pointing to that dataset to pull in allowable values. The primary report dataset is set to filter on the @Location. It is set to accept multiple values. This parameter is not displaying either.
Both parameters show on the design screen, but are grayed out.
Any help is greatly appreciated. I'm stumped on what I'm doing wrong. How do I fix this issue, so I can select the parameters at run time?
Thank you!!!!
Cervello
May 31, 2017 at 5:56 pm
Remove the defaults. You need at least one that doesn't have a default value for SSRS to prompt you for values. Otherwise, the report will just run with the defaults. The parameter doesn't even have to do anything.
May 31, 2017 at 7:07 pm
Thank you for getting back to me so quickly. I will give that a try.
Best Regards,
Cervello
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply