Allow blank date parameter value in a report using a Datetime picker?

[rogerzebra]

Hello All,

I have an issue with my store procedure that has several date parameters in a report that allow blank values. When I try to execute the report my datetime picker force me to pick a date, how to get around this?

I tried using expressions in the front-end with something like this:

=IIF(Fields!Date.Value Is Nothing,"// ",Fields!Date.Value)

Also, I red a post somewhere that I could set the parameter values in VS such as

exec dbo.dateTest
@StartDt,'StartDate',''
,@StartDt,'EndDate',''

But, I can't get any of these to work. Any ideas? All help would be greately appreciated. Thx

 

[RiverGuy]

You could create a boolean parameter with the prompt "Return All Dates," and your query could look something like:

SELECT * FROM SomeTable WHERE (@ReturnAllDates = 1) OR (TheDate BETWEEN @StartDate AND @EndDate)