Pulling Data from a Sting - CR/BO XI

[bb2001]

I'm trying to write a formula in Crystal Reports 11 to do the following:

I have a field {Event} that has 7 values i.e. Event1, Event2, Event3, .... All 7 events must be completed, but can happen in any order or sequence and can happen multiple times - you can have Event7 on 5/20, Event1 on 5/21, Event7 again on 5/22, etc.

What I am trying to display are the events that haven't been completed. So Event1, Event2, Event5, and Event7 are completed and I want to display Event3, Event4, and Event6 as not completed.

The {Event} is actually the printing of letters and the system automatically fills the field with the letter name each time it is printed if that helps.

 

[Turkbear]

Hi,
What way is there in the data to tell if an event has completed?
What other fields are there? If there is a Completed_date field in each record then selecting only NULL or Blank dates should get only uncompleted events, correct?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bb2001]

There is another field for the event date, so every time a letter is printed the date is filled. I think I understand what you're saying to look for the event name with a null or blank event date. I'll see if that works. Thanks.

 

[Turkbear]

Hi,
Yes, that's what I mean..A selection formula like:

IsNull(EventDate) Or EventDate = Date(0,0,0)

Not sure ablut the second method, but I think thats how to check for blank but not NULL ( depeneds on your database - some see blanks as NULLs others - like Oracle- distinguish between them)





To Paraphrase:"The Help you get is proportional to the Help you give.."