Can anybody pls help me with this strange phenomenon.

 

I have a report  for delevery notes, within this report's details section there is a subreport that calculates the total weight of each line. At the bottom the total weight coloum I want to show the total weight of all the lines.

When I use the Grand Total or Subtotal option in my sub report it gives me the Grand Total or Subtotal for each line, and not for all the lines added up.

 

I would really appreciate it if someone can help.

 

BTW: I am using Crystal 8.5.