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 |
|
abhit_kumar
Posting Yak Master
147 Posts |
 Posted - 2010-03-19 : 07:25:13
|
| Hello Experts,I have one problem for the selection paramter for the report.The selection parameter is "Series"In this i have multivalue like:-FSR9IPL9CIL9TOL9Now suppose if i select FSR9 from selection paramter then it take as FSR as string and compare in sql query.Currently in sql query i have written as:-where series in (@SeriesName)At database series are stored as FSR8, FSR9,FSR7,IPL3,IPL9So at selection parameter i does nt want to show both FSR8 and FSR9.So im displaying only one value for the series "FSR9".So if i selected value from selction as "FSR9", so mine query also check for FSR8 also and bring the data.Please let me know how to do it?Regards,abhi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-19 : 12:59:31
|
| do you mean you store csv in table and want show only passed param value if present?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Problem in comparing value for selection paramter