SSRS 2005 requeries parameters when one parameter is changed and when Viewing Report

• aber

  Hall of Fame

  Points: 3629

  More actions

  March 19, 2012 at 2:58 pm

  #270387

  I have a report that contains 6 parameters:

  Start Date - DateTime|No available values|Default =DATEADD("D",-30, Today())

  End Date - DateTime|No available values|Default =Today()

  Store - String|Stored Procedure for available values|Default = NULL

  SOS - String|Stored Procedure for available values|Default = NULL

  Code - String|Stored Procedure for available values|Multi-value|Default = NULL

  Part# - String|No available values|Default = NULL

  Whenever a user changes the Start Date, for example, I'm able to see through SQL Profiler that the stored procedures for Store, SOS, and Code are no executed and the screen will flash when the data is brought back. Also, when the user finally has all of the parameters filled in and clicks on the View Report button I see, again through SQL Profiler, that the stored procedures for Store, SOS, and Code are actually executed 2 times before the stored procedure for the main report is run.

  Can anyone explain why this is happening? I've been reading a bit about cascading parameters and not sure if this is something from that or not as I'm not too familiar with it. Or something else altogether?