i have a problem to assign value to a string. in my database, there is a column called 'Event_Status' where this column, consists two status which is 'active' and 'clear'.

these two status is indicating the status of another column called 'Event_Name' and this column consist the event called 'devdown' (device down) and 'unresponsive'. here the example of my data:


Event_Name                    Event_Status
devdown                               active
devdown                               clear
devdown                               active
devdown                               clear
unresponsive                         active
unresponsive                         clear
unresponsive                         active
unresponsive                         clear



is it possile for me to assign value '1' for active and '0' for clear so that im able to generate the line chart based on this data. how can i do that? is there any relevant CR syntax or SQL syntax that i can use? please advice.

Thank you in advance

Edited by lalakeyorai - 07 Nov 2009 at 11:25pm

I've never used it, but if you are joining straight to the tables you can use 'SQL Expressions' which hopefully will convert it.  For display you could write a formula, but I don't know if that will work with a chart (my company doesn't use charts, just lots of numbers).