Link to home
Start Free TrialLog in
Avatar of HemlockPrinters
HemlockPrinters

asked on

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
Avatar of Mike McCracken
Mike McCracken
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
Avatar of HemlockPrinters
HemlockPrinters

ASKER

thanks, but it suppress all subtotals except the last record.
they want to show subtotals in details section instead of group footer.
Avatar of Mike McCracken
Mike McCracken
Can you post the formula you used?

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of HemlockPrinters
HemlockPrinters

ASKER

(Not OnLastRecord) OR ({xx_orders_secured;1.SALESPN} = Next({xx_orders_secured;1.SALESPN}))

the report is grouped by salespn
Avatar of HemlockPrinters
HemlockPrinters

ASKER

thanks. it's should be "And"