Geek Answers Handbook

How to get the sum of groups in crystal report 10?

I have a report for some invoices, and each invoice has lines like this:

invoice1 2000 line1 300 line2 700 line3 500 line4 500 invoice2 1000 line1 300 line2 400 line3 300

Now when I use the resume for group # 1, I have to get 3000 as the sum of the group. but he shows me 11000 (4X2000) + (3X1000) because he sums up the invoices!
what should I do?

+6
crystal-reports
source share
1 answer

You must have the total that fits into your "Group 1 Footer"

If you right-click and select "Edit Running Total", you should have the following:

  • The field you want to sum must be your value that you want to sum. I think it is right!
  • Type of report - there must be a sum
  • Calculate - "For each entry" should be selected.
  • Reset - “About changing a group”, select and select group No. 1.

Update In this case, if the total data is displayed in the initial data, and the total amount for all reports changes the current total amount only for each invoice (group No. 1) and not Reset.

Note. Assuming Group # 1 is in Account Number , and the required CV for the entire report

So, now the following steps will be performed:

  • The field you want to sum must be your value that you want to sum. I think it is right!
  • Type of report - there must be a sum
  • Compute - ' In group chnge group .
  • Reset - “Never” should be selected and select group No. 1.
+11
source share

More articles:


All Articles