Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Parameters

Author  Topic 

rwlopez
Yak Posting Veteran

80 Posts

Posted - 2006-10-10 : 17:10:11
A have a report in Reporting services that uses parameters. I would like to pass a parameter from the report to the query that contain more that one value, but I do not know how to accomplish this. Here is an example. I would like to run a Sales report for California where the user selects the state and all three sales region codes are passed to the query. Does anyone know a simple way to accomplish this?


Sales Region Codes for California
11720
21721
31722

Sales Region Codes for Nevada
11754
11755
11759


SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-10 : 17:20:46
Cross posting http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73323


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

rwlopez
Yak Posting Veteran

80 Posts

Posted - 2006-10-10 : 17:26:54
I know that this question belongs in the Reporting Services forum, but is seems that no one is responding to the posts. Is there anyone in this forum that can answer this question?
Go to Top of Page
   

- Advertisement -