CODEWITHSUNDEEP
ssrs-2008reportingreporting-services
uh_big_mike_boi
uh_big_mike_boi

Reputation: 3470

I have a hidden parameter but I want to give it a value

I have a paramter in SSRS I am setting to hidden. I want to send it to a stor proc but I want to use it only if it is default, if not, then I dont want to use it. So, I have a parameter "DateBeginMod", which I will use for default if the user wants modified type. If user does not want modified type, then I will use the other date "DateBegin" which is already there. Im only now doing this because they want subscriptions. Im just creating the "DateBeginMod" parameter, but I will only use it if is a subscription. In the stor proc I will check for 'modification' or 'not modification' and use the DateBeginMod if it is. So I just want DateBeginMod ALWAYS to equal "DateBegin", unless in the case it is a subscription then it wil be different defaults. Makes sense I hope

Upvotes: 0

Views: 442

Answers (1)

Gil Peretz
Gil Peretz

Reputation: 2419

Assuming the user should pick one of the ways (from the actual report), You can use the user's choice (the selected value) to re-render your report with the relevant parameter (DateBeginMod or DateBegin) according to the user's choice.

In my personal opinion - assuming that your parameters are actual dates, I would use single paramter with IIF expression to check the user's choice and to set the date accordingly.

Upvotes: 2

Related Questions