Hi Jason This Subhra.can we pass the blank value in calender picker as it is a date/time datatype.My requirements are 1-I have 3 parameters in ssrs report ie relative date(month,year,week),startdate and enddate 2-if i select relative date other 2 parameters will be blank as these 2 are calender field i can not able to do it .. 3-I Had do it by passing null value but my requirement is these two will be blank not null as text parameter.
If You had done it let me know please.
Submitted under: SSRS - SQL Server Reporting Services · Microsoft SQL Server · · ·
You cant pass blank value in datetime parameter, atleast as far as I know. However, you can use a function like isnull to get the NULL to be a blank in your query. Would that work for you?