hi Rakan,
please be reminded that one question per thread. i will answer "Page Wise total"
Creating a Page Total in Crystal
It is strange that a powerful program like Crystal does not have a simple way to calculate a page total. Here is the best way we have found.
Step One: Create a formula field called reset with the following expression:
//reset
WhilePrintingRecords;
shared numbervar total := 0
You can use any name to substitute for the word u2018totalu2019.
Step Two: Create a formula field called accum with the following expression:
//accum
WhilePrintingRecords;
shared numbervar total := total + {table.numberfield};
Step Three: Create a formula field call display with the following expression:
//display
WhilePrintingRecords;
Shared numbervar total;
Total
Place the formula field reset in the page header. Right-click on it, pick u201Cformatu201D and then pick the common tab. Pick u201Csuppressu201D.
Place the formula field accum in the details section. Right-click on it, pick u201Cformatu201D and then pick the common tab. Pick u201Csuppressu201D.
Place the formula field display in the page footer. Position and format it as required.
That is it!
regards,
Fidel