SAP Knowledge Base Article - Public

1727738 - How to sort on a running total field in Crystal Report?

Symptom

How to create a sort order on a running total field in Crystal Report?

Environment

Crystal Reports 2008

Crystal Reports 2011

Cause

Sorting is performed prior to calculating a running total field.

Resolution

You cannot assign any sort order to a running total field in Crystal Reports. As a workaround you can use a formula field with Sum() function and assign a sort order on the formula field. Sum() can add a result of a database, parameter or formula field.

Keywords

ascending descending group expert , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011, feature pack 03