Post reply

Hiding a report parameter based on value in other report parameter

  • February 24, 2009 at 8:45 am

    #206920

    Hi,

    I have a report in which i need to hide a report parameter based upon value in other parameter.

    We have hide option while creating prameters but that is static,what i need is based on a value selected in a drop down of another parameter i want to hide the parameter.

    And also if hidden should not display message to user aksing him to enter that value.

    I tried it by custom code in report properties Code tab but no wys to access that parameters visibility property.Also tired with wirting my own custom code and bulidng it into assembly.But not found any way to access such a property.

    Please help with a clue.

    Thanks & Regards

    Nitin 🙂

  • February 26, 2009 at 11:58 am

    #950753

    I too have been trying to figure out a solution to this type of problem. The best I've got so far is to work out the second part, not having the user need to answer the prompt.

    The way I got around it was to have 2 parameters param1 accepts an integer value param 2 is a boolean. In the second parameter (the one I want to make optional) I used something like the following in the default =IIF(parameter1.value = 1, False,Nothing). That way I make it False, and the user doesn't have to select it if param1 is of a certain value.

    Sorry I Can't be of more help, but am interested if anyone has a better suggestion.

    -Luke.

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

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

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