Datetime Param default NULL

  • Hi 
    Is there a way to set NULL as default value in parameter for datetime column
    I have three columns @id, @Sdate,@Edate .
    In design i have choose the data type i have chosen @id as integer, @Sdate as date/time,@Edate as date/time
    empty codes '' are not enabled for date/time data type.
    for my requirement i need to pass as empty codes as @Sdate,@Edate 

    1. Is there a way to set NULL as default for datetime column parameter? in report builder it is enabling but when published default null check box is not checked, it is unchecked. 
    2. pass empty value in parameter for datetime column

    PS: please dont ask for business logic behind this, i have more than columns as parameter, to ask i have said as 3 columns.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply