Keep first record value in summary

[knitwit]

Hi,
I am using Crystal XI and Oracle 9i. I am reporting information from the footer of my document (gf4).This is the only area that will print. But the information I need to display should show in one field the data of the first record within the #3 group. I have the data sorted so that it would show up first. But what formula do I write to retain the first iteration of gf4 and then reset for a new #3 group? I feel like I'm not being clear, so here's an example

I show seam name and total acres...

L5B 100.00
N5B 200.00
CBG 50.00

These are all within the same #3 group and they display in gf4.
I would like to have a field within gf4 that would display L5B on every row within the #3 group...
L5B 100.00 L5B
N5B 200.00 L5B
CBG 50.00 L5B
Hope somebody can help.

 

[raja2008]

can you show the layout of your report,what is in group #3 and #4

 

[Charliy]

You can use a shared variable to do that.

in your detail have a formula (print suppressed) like this:

shared stringvar FirstInGroup;
if {table.fieldyougroupedon} <>
previous({table.fieldyougroupedon})
then FirstInGroup := {table.otherfield}
else
FirstInGroup := FirstInGroup

Then where you want to display it you just have a formula:
shared stringvar FirstInGroup