Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Unanswered: assign string to number

    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
    Last edited by lalamaisee; 11-08-09 at 03:13.

  2. #2
    Join Date
    Oct 2010
    Posts
    46
    Quote Originally Posted by lalamaisee View Post
    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?
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •