Refreshing parameter values

  • Hello Everyone,
         I currently have a pull down parameter that lists several types of "speed dates" (This week, last week, etc.).  when you select one, I have 2 date parameters (StartDate and EndDate) that automatically calculate dates and populates themselves.  In other words, selecting "This Week", the StartDate will populate with the beginning of the week, and the EndDate will populate with the end of the week.

    Now, my question is this...Is there a way to change the values of the StartDate and EndDate automatically when the value of the SpeedDate changes?  If somone selects "This Week" then changes it to "Last week", can the parameters change their values automatically?  if so, how can this be done?

    Thanks!

  • how do you have the StartDate and EndDate parameters setup?  I've seen something similar, where the StartDate and EndDate parameters have properties of:
    Default Values: Specify Value, using a Switch function
    Advanced: Automatically determine when to refresh

  • Chris Harshman - Tuesday, July 18, 2017 11:04 AM

    how do you have the StartDate and EndDate parameters setup?  I've seen something similar, where the StartDate and EndDate parameters have properties of:
    Default Values: Specify Value, using a Switch function
    Advanced: Automatically determine when to refresh

    Well, I am using a big Iif statement instead of a switch, but I have it set up to refresh automatically.

  • OK, that shouldn't matter, looking at it further, on my report it looks like it only updates the dependent parameters the first time, it may be related to this bug reported in Connect:
    https://connect.microsoft.com/SQLServer/feedback/details/268032/default-does-not-get-refreshed-for-cascading-parameters
    marked closed as by design :ermm:
    It looks like it is possible to get past this limitation though, by setting the Available Values to "Specify values"
    , and then using the same expression that's in the Default Values.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply