This report has a parameter with the following characteristics
- Multivalue = True
- Allow Blank Value = True
- Drop down list values come from a query UNION'd with a hard coded record. i.e. SELECT '' AS Blank, 'Blank Valuz' as DESCRIPTION UNION SELECT MyValues, MyDescriptions FROM MyTable
- The underlying dataset is a stored procedure which calls a function that parses multiple parameters.
- I run the report select 'Blank Valuz' and a second value (say '666') from MyTable as my filter.
Results Run report filter = '', '666'. RESULT = Just the sum for '666' (I WOULD HAVE EXPECTED SUM OF BOTH VALUES HERE)
Run report filter = '' RESULT = Just the sum for ''
Run report filter = '666' RESULT = Just the sum for '666'
What am I missing here.. How do I get SSRS to filter based on blank AND a string value.