SSRS Parameters, 1 Select multiple values

[dhulbert]

I'm trying ot get SSRS to populate a number of parameters from a single drop down select box

I currently have a single drop down list generated from a query that allows a user to select a specific report and it popultes the parameter @Report_ID.

I want this select to populate a number of parameters rather then just one.

ie,
@Report_ID
@Calender_ID
@Start_Date
@End_Date

All of the values are avaliable in the query that sits behind the parameter select.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[xlbo]

just set each parameter to pick up from a different field in your query results that provide the values...

Set the paraeter values to be supplied from a query, select the query and then the field and you should be away

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question