In new ssrs 2008 R2 report, I would like to have a dropdown list for each parameter that a user can select on to execute a report. To accomplish this task, the only way I can determine how to accomplish this goal is to use a new dataset for each parameter that the user can select on. Would this work? Are there other ways to accomplish this task?

Hi Wendy It depends on your parameter values which means if they are static values then you can specify by going to available values and choose specify values if they are dynamic then you have to choose a dataset because if in future it might increase or decrease I hope this will help Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.