If-Then-Else Formula problem 1

[mjm19]

Having a problem setting up what should be a pretty basic formula. Using Crystal 8.0.
Searching for a particular test that was ordered yesterday.
Have a group made up of Patient Unit Numbers. Then listing the occurances that this test was ordered on that patient for a given day (accession #).

For test XYZ

Unit Number : 1234567
Accession Number M1234

Unit Number : 9876543
Accession Number M5678
Accession Number M9876

I only want to see patient # 9876543 because there is >1 instance of this test being ordered. I only need to deal with these if the Accession number within a particular Unit Number exceeds 1.

Thanks

 

[bdreed35]

Try adding this in your Group Selection Formula (Report, Edit Selection Formula, Group):

Count({table.Accession_Number},{table.Unit_Number}) <> 1

Bear in mind that this only suppresses groups that have less than 1 Accession Numbers. The database still returns all records.

~Brian

 

[synapsevampire]

Create a group by TEST.

then use the report->Edit Selection Formula-Group and place something like:

count({table.Accession},{table.Test}) > 1

-k

 

[mjm19]

Thank you both ... problem solved.

 

[synapsevampire]

<chuckling>

So you gave yourself a star as the supplioer of an excellent question?

-k

 

[mjm19]

-K

I didn't do that ...and don't know who or why it was done.
I just want to thank you people for your continued support. Your answers are quick, bright, and right to the point. As we move on to Enterprise and 9.0, I hope you can continue helping us out. Someday, I hope to have a 1/2 the knowledge you people have. Thanks again.

-M