I want record number 1 in the group footer

[pleashelp]

I have a field called Starting amount in the details section. Now I want to show only the first record in the group footer, not a total of the details. Is this possible?

 

[dgillz]

Place your database field in the group HEADER, not footer, and you will get the first record of the group automatically.

If your first record of the group must be in the footer, you will have to use a variable to capture this. If you need help with the formula, let me know.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[Ngolem]

In the Group header place the following formula

@CaptureFirstValue (Suppressed)

NumberVar S_Amount;

if onFirstRecord then
S_Amount := {Table.StartingAmount};



In the footer place the following display formula

@DisplayFirstValue

NumberVar S_Amount;

"This is the Starting Amount: " + Totext(S_Amount,2)



Jim Broadbent

 

[pleashelp]

Ok. Thanks for the responses. I did as ngolem suggested. So.. the correct first record shows in the first group header, but in every other group, a 0.00 shows. And in the group footer I get a 0.00 in every group. Any further thoughts as to what I might be doing wrong?