How to add Formula Field in Crystal Report

1. Right Click on Formula Fields which is in Field Explorer
2. Click New
3. Then, you will get the Formula Name dialog box.
4. You should type Name for formula and Click Use Expert or Use Editor.
5. For this post, I will use Use Editor.
6. You will see the Formula Workshop.
7. Based on your requirements, You may double click on table fields or Report fields and Operators.
8. Then you many check the Check the Error using Alt+C or click Check button which is located on the top left side.
9.If you find No Error, you can click Save and Close button.
10. Finally, you can drag that formula field into your report.

How to add Running Total Field in Crystal Report?

In the Field Explorer, under Database Field,

1. Right Click on Running Total Fields and Click New
2. In the Create Running Total Field Dialog Box, under Report Fields, select the specific field which  you want to sum
3. Then, Click the ">" and Choose Sum for Type of summary.
4. You may change the name for Running Total Name.
5. Click OK button.
6. Then, you will see the running total field name under Running Total Fields.
7. After than, just drag to your report.

Grouping in Crystal Report

1. Right Click on Group Name Fields in Field Explorer
2. Click Group Expert
3. Choose a field which you want to group from Available Fields, Add to Group By box.