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 |
|
Muj9
Yak Posting Veteran
75 Posts |
 Posted - 2013-08-14 : 05:00:13
|
| Hi all,I have a report about a survey.In my report i have a question field then i have a matrix table which contains two rows and one column something like this:-When selecting just a single specialtyQ:- How did you find whateverMatrix:- Fair Poor Good VeryGood 25% 25% 25% 25%I have two parameters a sector and a multivalued parameter called specilty. so you select a sector then you have to select a choice of specialty. when i select any one specialty the results are fine but when i select more then one or all of the specilaty the results are not a total of 100% so for example:-When selecting multiple specialtyQ:- How did you find whateverMatrix:- Fair Poor Good VeryGood 35% 15% 35% 25%so when i select the multivalued then i get a total over 100% or below not a whole 100% of the answers based on the question where as when i select a single specialty its fine. So what do i need to do? in my SP i already have used and whatever IN (select Param from [dbo].[fn_MVParamChar](@specialty,',')) Please help. Thank you |
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-08-14 : 10:54:58
|
| Don't see anything wrong with your where clause, show us what your select statement looks like. |
 |
|
|
|
|
|
SSR 2005 Multivalue parameter