Hi,

Im a newbie who are using CR 2008.

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

You would need to create a formula for use in the line chart instead of Event_Status. In the formula, you would assign '1' or '0' depending on the value of Event_Status.