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

Unable to create a working indicator Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 9:43 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
I am trying to create an (Shape) indicator for a SSRS report whereby the indicator will turn red if there is a call
from a manager and then stay Green if there is no call.


I have created a query to be used on the report:


SELECT COUNT(*) AS Calls
FROM CALL INNER JOIN
Z_UserAlert ON CALL.CALL_USERNAME = Z_UserAlert.UserName
WHERE (CALL.CALL_STATUS = 'Open')


I have dragged an indicator on to the report. On the Indicator states I have set the color red to Start at 1 and End at 100.

The indicator Green starts at 0 and ends at 0.


On the value i have created an expression as follows:


= IIF(Sum(Fields!Calls.Value) >= 1, "Red", IIF(Sum(Fields!Calls.Value) < 1, "Green", "Green"))


I have ran my report but what is happnening is that the indicator is not turning to any color. The box is just clear.

Does anyone know where I am going wrong?


Post #1436565
Posted Thursday, March 28, 2013 11:41 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 24, 2014 11:10 AM
Points: 1,269, Visits: 3,631
dbman (3/28/2013)
I am trying to create an (Shape) indicator for a SSRS report whereby the indicator will turn red if there is a call
from a manager and then stay Green if there is no call.


I have created a query to be used on the report:


SELECT COUNT(*) AS Calls
FROM CALL INNER JOIN
Z_UserAlert ON CALL.CALL_USERNAME = Z_UserAlert.UserName
WHERE (CALL.CALL_STATUS = 'Open')


I have dragged an indicator on to the report. On the Indicator states I have set the color red to Start at 1 and End at 100.

The indicator Green starts at 0 and ends at 0.


On the value i have created an expression as follows:


= IIF(Sum(Fields!Calls.Value) >= 1, "Red", IIF(Sum(Fields!Calls.Value) < 1, "Green", "Green"))


I have ran my report but what is happnening is that the indicator is not turning to any color. The box is just clear.

Does anyone know where I am going wrong?


Indicators are tricky for me too. Looking at your code I can't tell you exactly what is happening but i'll throw out some ideas for you.
This issue might be with the SUM() function. Perhaps there's a NULL in there which screws up the indicator (NULL != 0).
= IIF(Sum(Fields!Calls.Value) >= 1,"Red","Green")

or
=Switch(
Sum(Fields!Calls.Value) >= 1,"Red",
Sum(Fields!Calls.Value) <1 "Green")



______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Post #1436637
Posted Thursday, March 28, 2013 11:51 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Hi
Thanks for your reply. I have tried both expressions, but the box is still staying empty when I attempt to view the indicator.
I have ran my query in SSMS and its returning the value 4. So the color should be turning Red.

Post #1436640
Posted Thursday, March 28, 2013 11:57 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Hi
Thanks for your reply. I have tried both expressions, but the box is still staying empty when I attempt to view the indicator.
I have ran my query in SSMS and its returning the value 4. So the color should be turning Red.

Post #1436642
Posted Thursday, March 28, 2013 2:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 1:07 AM
Points: 7, Visits: 64
check this link will help you

http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD#13
Post #1436723
Posted Friday, March 29, 2013 4:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
Change the Measurement unit to "Numeric" in value and state and see the result.
Post #1436861
Posted Friday, March 29, 2013 5:28 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Hi The measurement was on Numeric in the first place. Still not working.
Post #1436879
Posted Friday, March 29, 2013 6:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
I think u r following some wrong process..

Below is an example
FIRSTNAME BIRTHPLACE VALUE
ERIK LONDON 0
ERIK LONDON 3
HARRY EDINBURGH 2
HARRY EDINBURGH 5

1. Add a indicator in the table and go to indicator properties.
2. Simply Add the column name like Sum(Fields!Calls.Value).
3. Select Numeric as Measurement Unit.
4. Then in the indicator states just give the start and end value in the respective
Post #1436890
Posted Friday, March 29, 2013 6:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
you can chck the attachment

  Post Attachments 
solution.JPG (21 views, 44.99 KB)
Post #1436898
Posted Thursday, April 4, 2013 3:04 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Thanks for your help. Problem is solved.
Post #1438691
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse