SSRS Issue

Question

SSRS Issue

shahm10

SSCrazy

Points: 2217
More actions
August 25, 2009 at 7:05 pm

#214302

I have created a report which uses two parameters named SELECT and EDATE.
If i choose value of SELECT parameter as Yes then EDATE is set to yesterday's date and if i choose value
of SELECT parameter as No then EDATE is set to today's date.
when running report for the first time, it runs without any issues.
For eg: when i choose value of SELECT parameter as Yes then yesterday's date is displayed but after that
if i choose value of SELECT parameter as No then also it shows yesterday's date and not today's date.
It is not refreshing EDATE parameter's value.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Can you post the code you use to set the EDATE parameter?

If you are using an expression it does not seem to work. You can tie the EDATE parameter to a query that returns the date you want, something like this:

=IIF(Parameters!Select.Value = "Yes", "Select Getdate()", "Select GetDate()-1")

Then you set the EDATE parameter to get its value from the dataset. Make sure to set the default as well.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

shahm10 SSCrazy Points: 2217 More actions · Answer 2

Thank you for the information.

SELECT parameter setting:

Available Values:

YES

NO

Default Values:

Null

EDATE parameter setting

Default Values:

=SWITCH(Parameters!SELECT.Value="Yes",DATEADD("d",-1,now),

Parameters!SELECT.Value="No",

now)

shahm10 SSCrazy Points: 2217 More actions · Answer 3

Thanks Jack for your information.

I provided available values for EDATE parameter and it worked.

Thanks

shahm10 SSCrazy Points: 2217 More actions · Answer 4

Jack

If I set available values for EDATE parameter then I am not getting Calender functionality

but instead of that I m getting drop down list.

Any suggestions?