No Upper/Lower Limit for Date Parameter?

[barb3246]

I am in the process of converting our existing Crystal Reports over to MS Reporting Services. One of the feature our users would like to see if the No Upper Limit and No Lower Limit functionality that is allowed on date parameters in Crystal Reports. I don't see anything similar in Reporting Services. Couls somebody tell me a way to implement this in Reporting Services? Thanks! Barb

 

[IanWaterman]

Allow Date parameter to be Null and then enter into select filter, do same for EndDate

and (@StartDate is null or Datefield >= @StartDate)

Ian

 

[barb3246]

Thanks for the reply Ian. I'm not sure I understand. In Crystal, if they select no lower limit, it will give them all dates prior to the END DATE. In your example, (@StartDate is null or Datefield >= @StartDate), if they didn't enter anything it will just look for dates that = NULL. The users want to see everything out there.

 

[IanWaterman]

The effective result of this

(@StartDate is null or Datefield >= @StartDate)

is a boolean true or false

if @StartDate is null is true no date filter is applied as the or part will not be applied.

Ian

 

[barb3246]

Thanks Ian - I understand now. Works great!