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.
| Author |
Topic |
|
mike26
Starting Member
5 Posts |
 Posted - 2010-08-03 : 19:30:45
|
| I have a SSRS report with several multi value parameters which are used in a dataset that uses a stored procedure. the stored procedure has a where clause using @city which is one of the multi value parameters:WHERE ........ and CITY IN(@CITY).if I only select one value for the @city the report works fine, however, when more than one value is selected for the city, the stored procedure does not return any data. Any suggestions would greatly be appreciated. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-04 : 01:49:48
|
| Are you using SSRS 2000? SSRS 2003? or 2008? |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-08-04 : 07:13:46
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148235MadhivananFailing to plan is Planning to fail |
|
|
|
mike26
Starting Member
5 Posts |
Posted - 2010-08-04 : 17:01:45
|
| SSRS 2005 |
|
|
|
|
|
|
SSRS MULTI VALUE parameter