Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: SSRS Parameters and stored procedure

    I have an SSRS report

    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.
    Last edited by access_dude; 07-21-09 at 21:19.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •