Post reply

How do I disable and Report Parameter based on the value of another Report Parameter?

  • August 14, 2008 at 3:36 pm

    #195902

    I want to disable a Report Parameter and enable another one based on the value of another Report Parameter. Can any one help?

  • August 15, 2008 at 6:15 am

    #858627

    Hi

    If i understood your question right, so you can follow the following way to solve your problem.

    Create two Report Variables, First and Second.

    Add few numbers in Value and Label Field for First Variable.

    Add the following code for Second Variable's Label and Value field.

    =Parameters!First.value

    When you render the report so the second variable will receive value from First variable.

    hopefully it will work.

    🙂

    Nice weekend

  • August 15, 2008 at 9:18 am

    #858819

    Thank you for your response but that is not quite what I am trying to do.

    I created a report parameter that is boolean "Query Filter?" if the user select PayrollCycle, I want another Report Parameter displaying all the payroll cycle in a drop down box and Payroll company in another parameter "PayrollCompany" while disabling report parameter "EmployeeId" but if the user select EmployeeId in the "Query Filter?" parameter I want the EmployeeId parameter enabled or visible while disabling PayrollCycle and PayrollCompany report parameters.

    I hope you guys can help.

  • August 16, 2008 at 4:46 am

    #859096

    Yes, i was expecting such a problem. You wanna try the same result which you can only perform on web application. It would be convenient if you try to create .asp side and do show hide there rather in report. Bcz SSRS 2005 are not good enough for these functions. 🙂

    Good luck

  • August 16, 2008 at 10:42 am

    #859112

    Thank you, I figured that would not be easy...I will explore the asp solution.

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

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