Post reply

change ALLOW NULL property of Parameter

  • February 24, 2010 at 11:32 am

    #217107

    Hi all

    Is there any way to control the parameter propeties while running a SSRS report.

    I have a paramater for DATE (FROM and TO)

    now the TO prompt should allow null values when FROM is not selected, but as soon as the FROM parameter is selected , the TO should not allow any NULLS in the prompt.

    Is there anyway to control these properties based on selection of other paramaeters

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • February 25, 2010 at 5:31 am

    #1124881

    Hi,

    in the u r parameter properties select "Allow Null value"

    Hope it will work...

    Thanks

    veeren

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • February 25, 2010 at 11:13 am

    #1125125

    Hi,

    I think you didnt get my question, actually already I am allowing NULLS for both the dates (from and TO) but the problem is in controlling this property based on the FROM DATE SELECTION:

    If (FROM DATE IS NOT NULL)

    DONT ALLOW NULL in TO DATE PARAMETER.

    Hope you got it.

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

Viewing 3 posts - 1 through 2 (of 2 total)

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