title: SSRS parameter default value from stored procedure does not refresh
body: <p>I have a stored procedure that retrieves a date:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[GetFirstContractFirstDate]
      @Classifierid uniqueidentifier = 'C53387E0-AD2B-E511-9421-005056BAB261' 
  AS 
  BEGIN
      SET NOCOUNT ON;
  
      SELECT 
          CONVERT(DATE, MIN(o.tisa_RegistrationDate), 103) AS startDate
      FROM 
          Opportunity AS o 
      INNER JOIN
          SystemUserBase AS u ON u.SystemUserId = 'DB159B57-4A3D-E311-93EC-00155D46BF05' 
      LEFT OUTER JOIN
          UserSettingsBase AS us ON us.SystemUserId = u.SystemUserId 
      INNER JOIN
          tisa_Article AS art ON art.tisa_ArticleId = o.tisa_ArticleId 
      INNER JOIN
          tisa_Address AS addr ON addr.tisa_AddressId = art.tisa_AddressId
      WHERE 
          (addr.tisa_ClassifierId = @Classifierid)
  </code></pre>
  
  <p>In my SSRS report I have two parameters <code>@Classifierid</code> and <code>@startDate</code>.</p>
  
  <p>When I run the report for the first time and when I choose the value for classifierid, I get the date needed, but when I change the value of classifierid, the startDate default value does not get refreshed. The report shows the default date that was retrieved the first time. How can I automatically refresh my parameter <code>@StartDate</code>?</p>
  
  <p>First time reports run</p>
  
  <p><a href="https://i.stack.imgur.com/8IseG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8IseG.png" alt="First time the report runs"></a></p>
  
  <p>StartDate has been not refreshed</p>
  
  <p><a href="https://i.stack.imgur.com/KQ82E.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KQ82E.png" alt="enter image description here"></a></p>