Crystal Report MultiColumn Running Total

Question

How do I add the total total in multi-column crystal reports?

For example, I created a report with the layout “Multiple Columns” (hereinafter “down”). In addition to the first column, there is no column shown in the report, as I have to assume, to add current totals of those fields that are not displayed in the constructor.

View designer image

thanks

Answer 1

The solution is similar to your previous question.

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

In the page header, create and add a formula:

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

In the section in detail, create and add the 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 functions:

 whileprintingrecords; global numbervar col1; 

and

 whileprintingrecords; global numbervar col1; 

Answer 2

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

You will need to drag each running common field from the field explorer to the corresponding point in the report.