In Paginated report, 'To date' should be before 'From date' in date Parameters

69 views Asked by At

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 :

  1. User should not be able to select 'To date' before 'From date' in the report.
  2. 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.

0

There are 0 answers