question

granth avatar image
granth asked

Managing SSRS Parameters after publish

Hi There,

I have a working SSRS report that has been published to the report server. I have an expression that pulls the available parameter values. I want to be able to publish the same report to multiple folders but I want to be able to change the default available parameter. I.e. I have available values of 1,2,3,4 but change the default parameter to 1 if in folder A etc.

However when I go to manage the report, it says expression based under default, it gives me the option to override but when I click that I cannot select any of the available values, has anyone run into this issue? how can I get around this?

Thanks

Grant

ssrsparameters
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jon Crawford avatar image
Jon Crawford answered

change the parameter value before deploying it to an expression that looks at the URL and sets the value based on the folder it lives in. set up a CASE or SWITCH to set the right value for folder A, etc.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

granth avatar image
granth answered

Hi Jon, Thanks for replying. But not quite what I was asking, I should probably explain what I am trying to do so you know what I'm after.

I have created the report and it is working fine, if I upload the report with the correct default parameters it works fine. I created the base report with ALL the possible parameter values, now I want to hand that report off to an end user. The end user doesn't know how to build reports but they can upload to a new folder and then hit manage and change the default parameter values from the list of ALL available.

The issue I am having is after deployment the default parameter currently says expression based so I choose to override, once I hit override I can see ALL the available values in a drop down list but it will not allow me to select any even though I can see the check box.

Have you ever seen that before?

Thanks

Grant

@Jon Crawford


capture.png (4.3 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.