CODEWITHSUNDEEP
reporting-servicesssrs-2008powerbi-paginated-reportspaginateddatatable
Hozizon
Hozizon

Reputation: 1

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

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.

Upvotes: 0

Views: 282

Answers (0)

Related Questions