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 Background colors (flashing colors every 2 seconds) Expand / Collapse
Author
Message
Posted Monday, January 07, 2013 7:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 17, 2014 9:48 AM
Points: 29, Visits: 109
Hi, i have a table in SSRS which currently displays customer information. I currently have it alternating colors on a table which works great: code here for those looking:

=iif(RunningValue(Fields!<FIELD_NAME>.Value,CountDistinct,Nothing) Mod 2, "AliceBlue", "White")

However i want to incorporate 1 thing, if the customer has all his bills paid i want that row to flash red and white along with keep its alternating color scheme.

Logically i believe the way to this about this is set background color to alternate (done) then check if all customer bills are paid, if so then flash red/white every 2 seconds for example (the part which i'm not sure on)

Has anyone encountered this question?

Post #1403582
Posted Monday, January 07, 2013 7:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 17, 2014 9:48 AM
Points: 29, Visits: 109
Sorry after a bit more thinking, i have the query below doing most of the what i'm looking for except the flashing portion.

This highlights a field red if a value = whatever and keeps the alternate colors, however i would like to flash red every 2 seconds.

=IIF(FIELDS!<field>.Value="<value>","RED",IIF(RunningValue(Fields!<field>.Value,CountDistinct,Nothing) Mod 2, "AliceBlue", "White"))

can you have an expression refresh only?
Post #1403587
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse