Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

Parm Value Based on Another Parm Issue

I want to provide a parameter allowing users to select a time period (1 Day, 7 Day, 1 Month, etc). When the period is selected, I need it to add a date to a Start Date & End Date Parameters. I also need to allow the Start & End Dates to be manually adjusted.

I can get this to work by calculating the Default Value, but the problem is that once the Start & End Date Parameters have a date in them, selecting a new Period does not override the Start & End Parameter dates. It's a one time thing. If I add the same date calculation routine to the Available values, it changes the dates every time a new period is selected BUT it doesn't allow my users to manually adjust the dates since it makes this date the only available date they can choose.

Is there some way to make this work allowing users to change the Period multiple times & still allow them to alter the Start & End Date Parameters manually?
0
Lensolo
Asked:
Lensolo
1 Solution
 
ValentinoVBI ConsultantCommented:
"but the problem is that once the Start & End Date Parameters have a date in them, selecting a new Period does not override the Start & End Parameter dates. It's a one time thing."

Yes, unfortunately that's how cascading parameters work.  The default gets loaded only once.  Someone even opened up a bug on Microsoft Connect about 5 years ago.  Unfortunately MS closed is as "by design". For more details, see Default does not get refreshed for cascading parameters

There are a couple of workarounds but I have to say that they're not very straightforward.  Nevertheless, if you really need this to work, have a look at the workarounds mentioned in the bug report above and also here: SSRS Cascading Parameters Refresh: Solved
0
 
LensoloAuthor Commented:
That looks like it's the case based on soma additional post Googling. Thanks for your thorogh reply.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now