2 fields on one line in Detail

[skijop]

(CR ver 10)
I have 2 lines with 3 fields, but i have to compare id14 to id3 lines to get a comparevalue field (want to show whether admission date is >,< or = to completedate).

ID Desc datevalue
3 admissiondate 5/7/07
14 completeddate 6/1/07

I would like to show up on one line using some sort of formulaI have the @when formula created, just cant get them on one line)

admissiondate completeddate {@when}
5/7/07 6/1/07 before_admit

 

[Turkbear]

Hi,
How are id3 and id14 related?

How do you know the dates refer to the same thing/person?







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

 

[skijop]

The id3 and id14 are related bc they have the same form_id
The dates refer to the same person by client_id.
Here is a better rendition of how the data goes together.

client_id form_id type_ID Desc datevalue
5999 01 3 admissiondate 5/7/07
5999 01 14 completeddate 6/1/07

 

[skijop]

Does anyone know how to do this? All I really want to do is to have this on one line instead of 2.

 

[Madawc]

Group by form_id.

Create running totals using a formula to evaluate, and cleared for each new form_id group.

Create a formula field that shows the two, and place it in the group footer.

If you're not already familiar with Crystal totals, the basics are explained at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10