Post reply

Disable a Calculated Parameter ssrs report using SQL Server 2008 r2

  • October 1, 2013 at 3:34 am

    #283338

    Hi,

    I have a Report created in SQl Server 2008 r2,

    in which i'm passing 3 parameter to the query

    the third one is calculated on the basis of other two

    when the there is no data in first two fields there is no data then the third field is disable but when the value is inserted in the two fields then the third field is enabled

    i don't want the third field to be enabled(it should be read-only) even if the calculated data is comes inside the third field

    before value

    after value

    P.S. I'm new with ssrs report

    thank you

  • October 1, 2013 at 5:26 am

    #1654841

    Why have the third form field at all? Why not use a label, since it is not a form field value that you want to be changed. I don't use SSRS, but I do design a lot of .NET forms, and that is what I would do. Make the label visible only after the values in the first two form fields qualify and are calculated.

    Andrew SQLDBA

  • October 1, 2013 at 5:57 am

    #1654847

    hi

    thanks for the advice but i created it in business intelligence,

    How to add a label in in business intelligence

    thank you

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

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