Skip to Content
Author's profile photo Alaa Kharma

Crystal Reports Cross-Tab Accumulative Summary


In the previous post about Crystal Reports Cross-Tab, I described how to divide a month into dynamic periods such 3 days or 5 days…

In this post,I will describe how to add accumulative summary into a cross-tab as shown in the screenshot


First, right click on the summary field prior to where you want to add the accumalative summary field. In the example, Net Qty. / Mon..

Next, choose Embedded Summary > Insert Embedded Summary as shown in the following Screenshot:


A new summary field will appear named Embedded Summary. Right click on it and choose Embedded Summary > Edit Calculation Formula.


Add the following formula:

Local NumberVar i;

Local numberVar v;

For i := 0 To CurrentColumnIndex Do


v:=v+GridValueAt(CurrentRowIndex, i, CurrentSummaryIndex-1)



Note that, the GridValueAt function in the formula GridValueAt(CurrentRowIndex, i, CurrentSummaryIndex-1) will get the data from the previous summary field. Otherwise, CurrentSummaryIndex-1 hast be changed.

Best regards,


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.