Solved

Parm Value Based on Another Parm Issue

Posted on 2013-01-14
2
242 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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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