0 Replies Latest reply on Jun 20, 2014 5:59 AM by gl3nn13

    Change Font colour in report writer?

    gl3nn13


      Is it possible to change the font of a specific value in report writer?

       

       

      I have this, which all works:

       

      SELECT
      N.NODEID, 
      N.STATUSLED AS 'NODE STATUS2',
      N.CAPTION AS 'DEVICE',
      N.IP_ADDRESS AS 'IP ADDRESS', 
      N.LOCATION AS 'LOCATION', 
      CPS.STATUS AS 'CURRENT_STATUS',
      N.STATUS AS 'NODE STATUS',
      CPS.DATETIME AS 'LAST POLLED',
      N.CUSTOMERNAME AS 'CUSTOMER'

      FROM NODES N 

      JOIN CUSTOMPOLLERASSIGNMENT CPA ON N.NODEID = CPA.NODEID 

      JOIN CUSTOMPOLLERSTATUS CPS ON CPA.CUSTOMPOLLERASSIGNMENTID = CPS.CUSTOMPOLLERASSIGNMENTID 

      WHERE CPA.CUSTOMPOLLERID IN (SELECT CUSTOMPOLLERID FROM CUSTOMPOLLERS WHERE UNIQUENAME = 'UPSADVBATTERYREPLACEINDICATOR')  AND N.CAPTION LIKE 'RRD-UPS-%'

      ORDER BY CPS.STATUS, N.LOCATION, N.CAPTION

       

      But I want to be able to change the colour of result I get in the CPS.STATUS when it equals batteryNeedsReplacing, I would like 'batteryNeedsReplacing' to be shown in red.

       

      Can This be done?

       

      Many Thanks

      Glenn