title: SSRS Parameter Passing Issue
body: <p>We're using SSRS within an application where users login and are authenticated based on their Store.  When they generate reports, we pass their store name to SSRS to generate report for their store. Everything works fine on the first report generation.  But when the user picks a different date range, they get report for all of the stores in the system.  We use MDX to feed the default and available parameter for store name in the .rdl as follows:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT
     NON EMPTY { [Measures].[MTDActiveMembers],
     [Measures].[YTDActiveMembers],
     [Measures].[MTDMembers],
     [Measures].[YTDMembers],
     [Measures].[Members],
     [Measures].[Members - Active] } 
     ON COLUMNS,
     NON EMPTY { ([Store].[Store].[Store].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION,
     MEMBER_UNIQUE_NAME 
     ON ROWS 
  FROM
     (
        SELECT
  ( STRTOSET(@StoreStore, CONSTRAINED) ) 
           ON COLUMNS 
        FROM
           (
              SELECT
  ( STRTOMEMBER(@FromCalendarDateHierarchy, CONSTRAINED) : STRTOMEMBER(@ToCalendarDateHierarchy, CONSTRAINED) ) 
                 ON COLUMNS 
              FROM
                 [Members]
           )
     )
     CELL PROPERTIES VALUE,
     BACK_COLOR,
     FORE_COLOR,
     FORMATTED_VALUE,
     FORMAT_STRING,
     FONT_NAME,
     FONT_SIZE,
     FONT_FLAGS
  </code></pre>
  <p>Stepping through the app revealed that when the user picks a different date range, all the parameters are intact, correct store name is preserved, but when the user hits &quot;View Report&quot; parameter for store name changes to ALL.  :w00t:  What could be wrong?  As far as app is concerned &quot;View Report&quot; is a black box, so don't know what to change with the rdl :(  Thanks in advance for your input.</p>
  <p><strong>Edited</strong><br />
  Sorry, the query I provided above is the actual report query.  Parameter query is this:</p>
  <pre class="lang-sql prettyprint-override"><code>WITH MEMBER [Measures].[ParameterCaption] AS [Store].[Store].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Store].[Store].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Store].[Store].CURRENTMEMBER.LEVEL.ORDINAL 
  SELECT
     {[Measures].[ParameterCaption],
     [Measures].[ParameterValue],
     [Measures].[ParameterLevel]} 
     ON COLUMNS,
     [Store].[Store].ALLMEMBERS 
     ON ROWS 
  FROM
     (
        SELECT
  ( STRTOMEMBER(@FromCalendarDateHierarchy, CONSTRAINED) : STRTOMEMBER(@ToCalendarDateHierarchy, CONSTRAINED) ) 
           ON COLUMNS 
        FROM
           [Members]
     )
  </code></pre>