SSRS - types system.string and system.datetime

0
votes

My requirement is to throw an error message if start date greater than end date.

I have 2 parameters startdate & enddate which are type 'Date/Time'

in Dataset properties ->

1st Filters-> 

 Exp =format(Fields!ORDDate.Value,"MM/dd/yyyy")
 Operator = =
 Value = =iif(Parameters!ValidateDateRange.Value,Parameters!pStartDate.Value,"")

2nd Filters-> 

  Exp =format(Fields!ORDDate.Value,"MM/dd/yyyy")
  Operator = =
  Value = =iif(Parameters!ValidateDateRange.Value,Parameters!pEndDate.Value,"")

I have used this URL to get this done but I'm getting below error... http://aspdotnetmyblog.blogspot.com/2015/07/sql-server-reporting-ssrs-parameter.html

An Eror occured during local report processing. An error has occured during report processing. The proecssing of filterexpression for the dataset 'select' cannot be performed. Cannot compare data of types system.string and system.datetime. Please check the data type returend by the filterexrpession.

Any help is appreciate

1
reporting-servicesssrs-2012ssrs-tablix

1 Answers

0
votes

You could try:

= IIF(DATEDIFF("d", Parameters!pEndDate.Value, Parameters!pStartDate.Value) > 0, 1,0)