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 callfrom 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")