Report calendar picker and null
I am using the calendar picker in ssrs, the only problem is that the user MUST select a date. When i click allow null value on the parameter's start date and end date.... the report does not run correctly, below is the section of code for
the sql date's
[Posting Date]
between COALESCE(@startDate,[Posting Date]) and COALESCE(@endDate,[Posting Date])
May 26th, 2011 3:01pm
Hi,
How can default value helps you for the report parameter?Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 3:16pm
Meeh?
May 26th, 2011 3:51pm
Meeh?
sorry, I intend to say that you can use default values for the report executionThanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2011 1:29pm
it will not let me pick a null for the default pram value
June 1st, 2011 10:40am