Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

value in middle of indicator Expand / Collapse
Author
Message
Posted Monday, April 8, 2013 9:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 27, 2016 7:08 AM
Points: 124, Visits: 1,534
Is it possible to have a Value in middle of indicator color:

I have set up an indicator that changes color depending on a certain value. I would like this value to appear in the middle of the indicator. My expression is as follows:

=Sum(Fields!Alert.Value)

Thanks
Post #1439918
Posted Wednesday, April 10, 2013 8:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 27, 2016 7:08 AM
Points: 124, Visits: 1,534
Anyone come across this issue?
Post #1440841
Posted Wednesday, April 10, 2013 9:50 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, June 20, 2016 3:06 PM
Points: 554, Visits: 1,239
CAVEAT: I haven't tried this yet, but based on past experience I think it would work:

Try putting the indicator and a textbox displaying your formula in the same rectangle to group them before adding them to whatever tablix (I'm guessing) you have set, and then set the textbox in front of the indicator; obvs the textbox should have a transparent background.
Post #1440908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse