CODEWITHSUNDEEP
reporting-servicesreportingservices-2005
mfredy
mfredy

Reputation: 641

Setting Default Parameter In SSRS 2005

I have to set up a report where the user can choose a name from a drop down list. Is it possible to set a default name from the drop down list? So when the report's delivered to the user's email address, the results should be displayed of the default name's results. Is this possible?

I have tried a method to setup a default value but I am not sure if I am doing it correctly. What I did was, Open up Report Parameters and under default values, I selected Non-Queried and entered the Name which I wanted to display, but that did not work

If I am unclear, ask me and I will try my best to explain.

Thank You

Upvotes: 0

Views: 107

Answers (1)

busytools
busytools

Reputation: 371

you are talking about a report being delivered to the user's email, so i suppose you have a subscription set up. if so, you can set the parameter value in the subscription. you will need one subscription per user, and set the parameter in each subscription.

if you want to automate this (have the parameter set depending on the recipient), one option is to use data driven subscriptions (sql enterprise edition).

Upvotes: 1

Related Questions