Click here to Skip to main content
14,363,089 members
Rate this:
Please Sign up or sign in to vote.
See more:
In my crystal report i want to display sum of amount in each page as well as total sum in last page
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Apart from having running totals for columns in a table, there is something called Formula Fields in Crystal Reports. Read about them.

You can group your report by a field (lets say period) and then put the sum field in the group footer.

Google for exact scenario what you are looking for. There are number of tutorials, articles and tips of how to show data.
   
Comments
rajin kp 4-Oct-12 2:10am
   
iam tried this
in allsumFormula:
WhilePrintingRecords ;

shared numberVar totalsetPsum;
shared numberVar totalPiecesPSum;
shared numberVar totalAmountPSum;


totalsetPsum:=totalsetPsum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg};
totalPiecesPSum:=totalPiecesPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.totalpcsreg};
totalAmountPSum:=totalAmountPSum+{sp_report_select_view_madeup_shipping_instruction_details;1.value};

inn sumheadder:
WhilePrintingRecords ;
shared numberVar totalsetPsum;
if PageNumber <>1 then
totalsetPsum-{sp_report_select_view_madeup_shipping_instruction_details;1.totalsetreg};
but in odd and even pages they give different value

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100