Solved

Parm Value Based on Another Parm Issue

Posted on 2013-01-14
2
239 Views
Last Modified: 2013-01-15
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
Comment
Question by:Lensolo
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 38777339
"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
 

Author Closing Comment

by:Lensolo
ID: 38778068
That looks like it's the case based on soma additional post Googling. Thanks for your thorogh reply.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question