I am pulling from a template database with three fields Name, Enrolled, Unenrolled.

 

I have a select expert saying to only pull Names of those who are Enrolled but to exclude those who are Unenrolled. When a name is enrolled on the template Enrolled = 1. When a name is unenrolled Enrolled = "" and Unenrolled = 1.

 

My select expert looks like this:

{Enrolled} = 1 and
{Unenrolled} <> 1

 

On Monday Jane Doe is enrolled so Enroll = 1. On Tursday Jane Doe is unenrolled so Enroll = "" and Unenrolled = 1.

 

When I run the report on Friday Crystal pulls the old value of Enroll = 1 from the template database and ignores the fact that Unenrolled = 1.

 

Curiously, if I add in select expert:

not ({Name} in ["Jane Doe"]

then Jane Doe will get filtered out.

 

Is there a way so that Crystal will only recognize the latest value (Thursday's: Unenrolled = 1) and not search the database for old values (Monday's: Enroll = 1) when displaying Name?

 

So far I've had to manually add the not ({Name} in ["Jane Doe"] for the names unenrolled just to keep my report up to date.

 

Thanks in advance!

Also, do you have "Save Data With Report" turned on?  If so, turn it off!  It could be that you're actually looking at old data when you first open the report - Crystal doesn't automatically refresh the data when you open it.

 

-Dell