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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics