Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

2 fields on one line in Detail

Status
Not open for further replies.

skijop

Programmer
May 4, 2007
18
US
(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 formula:(I have the @when formula created, just cant get them on one line)

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


 
Hi,
How are id3 and id14 related?

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





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
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




 
Does anyone know how to do this? All I really want to do is to have this on one line instead of 2.
 
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.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top