Solved

Parm Value Based on Another Parm Issue

Posted on 2013-01-14
2
251 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 …
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

622 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