July 18, 2017 at 7:56 am
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!
July 18, 2017 at 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
July 19, 2017 at 6:56 am
Chris Harshman - Tuesday, July 18, 2017 11:04 AMhow 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.
July 19, 2017 at 2:16 pm
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