Hi,
I need some help getting multi-value parameters to work in SQL Reporting Services. Using VS 2005 to develop the report, backend is SQL 2005.
I have been reading around and I "think" I understand the concept of Split, Join, that the multivalue param is an array, cannot be used as such, difficult to use with procs etc. But I seem to be missing something basic.
My report runs off a proc. I am seeking to filter using the filter tab on the report's table's properties. I am trying to give the user the option to choose which companies' data he can view. Data returns companies, A, B, C, D... In the filter I tried:
- Fields!Company in Join(Parameter!MVparam.Value,",")
- Fields!Company = Join(Parameter!MVparam.Value,",")
- Fields!Company in Join(Parameter!MVparam.Value(0),",")
- True = Switch(Fields!Company <> Parameter!MVparam.Value(0), True, Fields!Company <> Parameter!MVparam.Value(1), True ,....
I also placed these expressions in an empty field on the report and it all returns true. So, I am wondering what it is that I am missing.
What I am really trying to do to provide the user with the option to exclude certain companies.. but i don't the see the 'Not In' option in the operator list in the screen where we set filters.
Thank you for your time.
Vidya.
I need some help getting multi-value parameters to work in SQL Reporting Services. Using VS 2005 to develop the report, backend is SQL 2005.
I have been reading around and I "think" I understand the concept of Split, Join, that the multivalue param is an array, cannot be used as such, difficult to use with procs etc. But I seem to be missing something basic.
My report runs off a proc. I am seeking to filter using the filter tab on the report's table's properties. I am trying to give the user the option to choose which companies' data he can view. Data returns companies, A, B, C, D... In the filter I tried:
- Fields!Company in Join(Parameter!MVparam.Value,",")
- Fields!Company = Join(Parameter!MVparam.Value,",")
- Fields!Company in Join(Parameter!MVparam.Value(0),",")
- True = Switch(Fields!Company <> Parameter!MVparam.Value(0), True, Fields!Company <> Parameter!MVparam.Value(1), True ,....
I also placed these expressions in an empty field on the report and it all returns true. So, I am wondering what it is that I am missing.
What I am really trying to do to provide the user with the option to exclude certain companies.. but i don't the see the 'Not In' option in the operator list in the screen where we set filters.
Thank you for your time.
Vidya.