Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • Last Modified:

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
0
HemlockPrinters
Asked:
HemlockPrinters
  • 3
  • 3
1 Solution
 
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
 
mlmccCommented:
Can you post the formula you used?

mlmcc
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
Try

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

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

Featured Post

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.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now