Hello,
I am new to SSRS. In my report, I have the following parameters created:
@startDate
@endDate
@ReportType
Under @reportType, I have two items : New Enrollment and Total Enrollment.
If user selects "New Enrollment", I would like to do something like enrollment_date >= @startDate and enrollment <= @endDate; If user selects "Total Enrollment", I would like to do something like (enrollment_date <= @endDate and exit_dt >= @startDate) OR (enrollment_date <= @endDate and exit_date is NULL). I think I need to use expression to do that, but I am not sure how to do it. Any help is appreciated
Thanks
Frank