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

SSRS/BIDS Indicators Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 8:49 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

I want to expose indicators based on a specific text, like "True" for example.
If the value in the textbox is "True", then show green indicator, else show red indicator.
How do I fill the Indicators Properties.

It is possible to use indicators this way?

Thanks
Regards
Post #1356794
Posted Wednesday, September 12, 2012 2:07 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 83, Visits: 719
You can use an expression for the indicator value to return a value in the right range for your indicator.

E.g. =Iif(Fields!fld.Value = "True",75,20)

would give you green for true or red for other values if you were using traffic lights with the default indicator states.
Post #1357830
Posted Monday, October 8, 2012 9:08 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

Thanks

It is possible to base a Traffic Light indicator comparing values from textboxes?
For example:

I have to compare these 2 columns:
%Realized (the data to this cell is based in an expression - Textbox1)
%Planned (the data to this cell is based in an expression - Textbox2)

If Textbox1 > Textbox2 - Green
If Textbox1 < Textbox2 - Red
If textBox1 = Textbox2 - Yellow

Any solution?
Thanks
Best Regards
Post #1369876
Posted Monday, October 8, 2012 9:38 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 6:36 AM
Points: 83, Visits: 719
I don't think you can use ReportItems (e.g. your textboxes) in an indicator expression.

You should be able to use your expressions directly depending on their scope. If they are for each row I'd create calculated fields for them and use these.

If they are summaries for groups then you can use the summary expressions directly in the indicator expression.

As before indicators work on percentage/numeric values so you logic needs to return a value of this type.


Post #1369901
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse