Setting the default date value in SSRS to be filled in or blank based on another parameter

user_5495819 0
Viewed 21

I've got parameters ScheduleMode, FromDate and ToDate. ScheduleMode can be Monthly, Weekly, or Manual. If it's Monthly or Weekly the FromDate and ToDate are set accordingly and that part I've got. If it's Manual I don't want a default value for FromDate and ToDate, I want them to be blank.

Any ideas? Thanks!

reporting-services
1 Answers

I would use a SWITCH statement for your Date parameters. A SWITCH is like a CASE statement in other languages but using a comma for the THEN and ELSE keywords.

=SWITCH(Parameters!ScheduleMode.Value = "Weekly", TODAY.AddDays(1 - TODAY.DayOfWeek), 
        Parameters!ScheduleMode.Value = "Monthly", TODAY.AddDays(1 - TODAY.Day), 
        True, NOTHING)

The last line acts like an ELSE statement - if it doesn;t meet the first 2 criteria, it will always get the third.

NOTHING is equivalent to NULL in SSRS.

user_44596170
Related