Tuesday, November 16, 2010

How to create a page total CRYSTAL REPORT

http://www.tek-tips.com/faqs.cfm?fid=1295


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 ‘total’.


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 “format” and then pick the common tab. Pick “suppress”.

Place the formula field accum in the details section. Right-click on it, pick “format” and then pick the common tab. Pick “suppress”.

Place the formula field display in the page footer. Position and format it as required.

That is it!  

No comments:

Post a Comment