Post reply

Optional parameter

  • November 17, 2010 at 2:47 am

    #226765

    I have to two parameter 1 and 2

    if I select parameter 1 then parameter 2 should be disable

    and if I select parameter 2 then parameter 1 should be disable

  • November 18, 2010 at 8:30 am

    #1252560

    Sorry. I just noticed this is the RS forum. I'm an idiot.

  • November 19, 2010 at 1:55 pm

    #1253299

    Are the two parameters of the same type, I.E. Datetime, string, whatnot?

    If so you could change you parameters so that the first parameter chooses the type of parameter, ten if you are letting the users select from a list you can use the value of the first parameter to give you the appropriate list to be selected from. You just need to be careful to setup your datasets correctly so that you pass the appropriate parameter to your query. a stored procedure may help here, but could perhaps open you up to parameter sniffing depending on how it's implemented. test, test, test...

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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