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  Development Tools  Reporting Services Development  Parameter Array Questions

Author  Topic  kathyc Starting Member 9 Posts Posted - 2009-03-22 : 10:33:50 Hi I have created a report that has a parameter "Region" and selected multi-value for this parameter. It can have values of... Central Ontario 1 Eastern Ontario 2 North Western Ontario 3 Northern Ontario 4 South Central Ontario 5 South Western Ontario 6 I also have to have a way of checking for null values so I added to the list.. Not Completed 0 In my expression for the Region column is: =Parameters!Region.Value(0) I have 2 questions... 1) How do I loop through the Region array if more than one region is selected? 2) How do I check for a null value? Thanks