Solved

Parm Value Based on Another Parm Issue

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now