CODEWITHSUNDEEP
reporting-services
Tim Vavra
Tim Vavra

Reputation: 537

Date Validation in SSRS 2008 R2

I have a series of reports that are dependent on a to and from date. I have set up parameters @Date1 and @Date2. Prior to executing the query, I need to determine that Date1 is less than Date2. This is important because the query is ...Where Date is between @Date1 and @Date2. If @Date2 is less than @Date1 the query does not fail, it just returns no results.

I found code postings that say to add a function by going to Report Properties under the Report menu and place the code in the Code Tab. I have looked at all over and cannot find this.

I am actually building the report in MS Visual Studio 2008. Can anyone point me in the right direction?

Upvotes: 0

Views: 543

Answers (1)

Ian Preston
Ian Preston

Reputation: 39586

In VS 2008 click Report -> Report Properties.

enter image description here

Click Code and add required code to Custom Code section.

enter image description here

Upvotes: 0

Related Questions