Selecting Last Record 1

[tjbennett]

I have a report that lists "Item No", "Description", "Qty" etc. I have grouped them by "Item No". How can I put the LAST "Qty" that shows up in the detail section on the grouped by line. If I put the "Qty" field there it only shows the first "Qty". I need it to run the detail section and then display the LAST "Qty" on the grouped section.

 

[lbass]

What makes the "Qty" the last "Qty"? Do you have a date field? If so, you could sort by date descending and then drag the date field into the group header.

-LB

 

[kchaudhry]

What happens when you copy and paste the "Qty" field in the group footer?

Kchaudhry

 

[CR85user]

If possible could you reply stating which version of Crystal you are using - an example of what the data output looks like and what groups are involved.

i.e.

GH1 datahere
DET invono qty
GF1 totalqty

J

 

[tjbennett]

Thank you, pasteing the "Qty" field in the group footer worked.