locked
Disable a paremeter in ssrs report SQL Server 2008 r2 RRS feed

  • Question

  • User303397390 posted

    Hi
    I'm really new in ssrs report creation.
     
    I'm Creating a report in that there is parameter i want to disable it but it should be visible.
    there is no condition it should just be disabled
     
    thank you

    Saturday, September 28, 2013 4:32 AM

All replies

  • User-830595639 posted

    Hi,

    I don't think its possible to disable a parameter in SSRS. Please explain in detail what you want to achieve, may be there is some other wayCool

    Monday, September 30, 2013 1:38 AM
  • User1143442848 posted

    Hi,

    According to your description, you want to disable the parameter of Report in runtime.

    In reporting services, disabling the report parameter at runtime is not a built-in function. But there are some workarounds.

    One is using Report Viewer control in ASP.Net web page which can be controlled programmatically as hedge said. 

    One is using cascading parameters. If you select the first parameter, the second parameter has no available data to select. Also, if you select the second parameter, the first parameter has no available data to select. Here is a document about cascading parameters:

    # How to: Add Cascading Parameters to a Report (Reporting Services)

    http://msdn.microsoft.com/en-us/library/aa337169.aspx

    # Lesson 2: Adding Cascading Parameters to a Report

    http://msdn.microsoft.com/en-us/library/aa337426(SQL.90).aspx

    For more information, please try to refer to the link below:

    # parameter disable

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ac858494-3a11-4eae-b201-168a1fd06139/parameter-disable

     

    Best Regards,

    Lisa Zhang

    Monday, September 30, 2013 2:10 AM
  • User303397390 posted

    hi

    can i pass a Fixed value at runtime to the parimeter

    Monday, September 30, 2013 3:42 AM