using database: SQL2000 and Crystal Report 11
The existing report is grouped by "COMPANY"
then by "LINE". The body (located in the LINE group footer) displays the group amount by LINE and then the summary is displayed under the Company group footer. Based on the sample data below, the Company summary is a running total that should sum amounts on each change of "ID" however it does not work, it adds all the lines of the amount field instead. Am I missing something.
thanks for your help.
"SAMPLE DATA"
ID LINE COMPANY AMOUNT
20856 19.2 Company1 45
20857 19.2 Company1 456
20857 21.1 Company1 456
20858 19.2 Company1 136
20859 19.2 Company1 214
20859 21.1 Company1 214
*****************************************
LINE Amount
19.2 851
21.1 670
-------
Total by Company1 1521 <--- False Ttl
*****************************************
LINE Amount
19.2 851
21.1 670
-------
Total by Company1 851 <--- Desired Ttl
The existing report is grouped by "COMPANY"
then by "LINE". The body (located in the LINE group footer) displays the group amount by LINE and then the summary is displayed under the Company group footer. Based on the sample data below, the Company summary is a running total that should sum amounts on each change of "ID" however it does not work, it adds all the lines of the amount field instead. Am I missing something.
thanks for your help.
"SAMPLE DATA"
ID LINE COMPANY AMOUNT
20856 19.2 Company1 45
20857 19.2 Company1 456
20857 21.1 Company1 456
20858 19.2 Company1 136
20859 19.2 Company1 214
20859 21.1 Company1 214
*****************************************
LINE Amount
19.2 851
21.1 670
-------
Total by Company1 1521 <--- False Ttl
*****************************************
LINE Amount
19.2 851
21.1 670
-------
Total by Company1 851 <--- Desired Ttl