Crystal Report MultiColumn Running Total

Question

How to add running total in crystal reports having multiple columns?

e.g I have created a report with Multiple Columns layout(Down then across). Apart from the first column no column shown in the report so how should i suppose to add running totals of those fields that are not displayed in the designer.

Kindly view the designer image

Thanks

Answer 1

By right-clicking on Running Total Fields and selecting New... in the Field Explorer pane within the Crystal Reports designer, for each required running total.

You will need to drag and drop each running total field from the Field Explorer to the appropriate point in the report.

Answer 2

The solution is similar to your previous question.

You can download my sample http://tickett.net/downloads/crystal/column_totals.rpt

In page header create and add a formula:

whileprintingrecords;
global numbervar col1 := 0;
global numbervar col2 := 0;

In the detail section create and add a formula:

whileprintingrecords;
global numbervar col1;
global numbervar col2;
if recordnumber mod 2 = 1 then col1 := col1 + {value_field} else col2 := col2 + {value_field};

In the page footer create and add two fomulas:

whileprintingrecords;
global numbervar col1;

And:

whileprintingrecords;
global numbervar col1;