Cascading Parameter issues

Hi all,
SSRS 2005
I have a Time Range parameter that has values
1 - This Week
2 - This Month
3 - This Quarter
4 - This Year
5 - Previous Week
6 - Previous Month
7 - Previous Quarter
8 - Previoous Year
I have 2 other parameters (Start and End Date) that are dependant upon what
they select in the Time Range.
TimeRange "1" is the default and is selected and StartDate shows "3/18/2007"
and EndDate shows "3/24/2007".
The problem is that I want the user to be able to override the dates that
are displayed in the Start and End Date parameters.
To do this, I have Set Start end End Data parameters with "Available Values"
set to Non-Queried and the "Default Values" set to "From Query".
When I first go to run the query, everything looks fine.
If I change the TimeRange to "2" ("This Month"), the Default Start and End
Dates do not update and stay at the dates initially loaded.
Thanks in advance for all your help.
Chris E.On Mar 23, 10:39 am, "Chris" <cex...@.enableconsulting.com> wrote:
> Hi all,
> SSRS 2005
> I have a Time Range parameter that has values
> 1 - This Week
> 2 - This Month
> 3 - This Quarter
> 4 - This Year
> 5 - Previous Week
> 6 - Previous Month
> 7 - Previous Quarter
> 8 - Previoous Year
> I have 2 other parameters (Start and End Date) that are dependant upon what
> they select in the Time Range.
> TimeRange "1" is the default and is selected and StartDate shows "3/18/2007"
> and EndDate shows "3/24/2007".
> The problem is that I want the user to be able to override the dates that
> are displayed in the Start and End Date parameters.
> To do this, I have Set Start end End Data parameters with "Available Values"
> set to Non-Queried and the "Default Values" set to "From Query".
> When I first go to run the query, everything looks fine.
> If I change the TimeRange to "2" ("This Month"), the Default Start and End
> Dates do not update and stay at the dates initially loaded.
> Thanks in advance for all your help.
> Chris E.
It seems like once you change the Time Range parameter value, you are
now using the Available Values/Non-Queried option for the Start and
End Date parameters. I would suggest having 2 additional parameter
options for the user to be allowed to enter in their own values for
Start Date and End Date, defaulting to empty strings; and control the
overriding at the database level (in the stored procedure or query
that is sourcing the report). Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Try instead of non queried, if possible, put the date range in a query so it
will refresh, whenever you select the time range.
Amarnath, MCTS
"Chris" wrote:
> Hi all,
> SSRS 2005
> I have a Time Range parameter that has values
> 1 - This Week
> 2 - This Month
> 3 - This Quarter
> 4 - This Year
> 5 - Previous Week
> 6 - Previous Month
> 7 - Previous Quarter
> 8 - Previoous Year
> I have 2 other parameters (Start and End Date) that are dependant upon what
> they select in the Time Range.
> TimeRange "1" is the default and is selected and StartDate shows "3/18/2007"
> and EndDate shows "3/24/2007".
> The problem is that I want the user to be able to override the dates that
> are displayed in the Start and End Date parameters.
> To do this, I have Set Start end End Data parameters with "Available Values"
> set to Non-Queried and the "Default Values" set to "From Query".
> When I first go to run the query, everything looks fine.
> If I change the TimeRange to "2" ("This Month"), the Default Start and End
> Dates do not update and stay at the dates initially loaded.
> Thanks in advance for all your help.
> Chris E.
>
>