Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Disable a Calculated Parameter ssrs report using SQL Server 2008 r2 Expand / Collapse
Author
Message
Posted Tuesday, October 1, 2013 3:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 6:06 AM
Points: 5, Visits: 17
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
Post #1500309
Posted Tuesday, October 1, 2013 5:26 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 2:35 PM
Points: 975, Visits: 3,350
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
Post #1500347
Posted Tuesday, October 1, 2013 5:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 6:06 AM
Points: 5, Visits: 17
hi
thanks for the advice but i created it in business intelligence,
How to add a label in in business intelligence
thank you
Post #1500355
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse