keep the last subtotal in detail section

crystal report shows subtotal in detail sections,
if the group have more than one records, subtotal should only shows on the last row.
Subtotal is calculated by running total.

thanks,
untitled.bmp
untitled1.bmp
HemlockPrintersAsked:
Who is Participating?
 
mlmccCommented:
Try

(Not OnLastRecord) AND ({GroupField} = Next({GroupField}))

mlmcc
0
 
mlmccCommented:
Can you show the subtotal in the group footer rather than the details section?

Try this
Use a formula to suppress the field

(Not OnLastRecord) OR ({GroupField} = Next({GroupField}))

mlmcc
0
 
HemlockPrintersAuthor Commented:
thanks, but it suppress all subtotals except the last record.
they want to show subtotals in details section instead of group footer.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mlmccCommented:
Can you post the formula you used?

mlmcc
0
 
HemlockPrintersAuthor Commented:
(Not OnLastRecord) OR ({xx_orders_secured;1.SALESPN} = Next({xx_orders_secured;1.SALESPN}))

the report is grouped by salespn
0
 
HemlockPrintersAuthor Commented:
thanks. it's should be "And"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.