I have a Paginated report with few filters and a 'From date' and 'To date' filter. The report works fine with all the filter combinations.
Requirement :
- User should not be able to select 'To date' before 'From date' in the report.
- User should not be able to select 'From date' after 'To date' in the report.
Any help would be appreciated.
What I tried : I tried adding the function "=DateAdd(DateInterval.Day, 1, Parameters!FromDate.Value)" in the Default value> specify value> add of the 'End Date' paramter,
In the main report query "AND submittedon BETWEEN @StartDate and @EndDate" is added in the where condition.