Hello,

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

/wp-content/uploads/2014/11/screenshot071102_580937.png

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:

/wp-content/uploads/2014/11/screenshot071102_580937.png

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

/wp-content/uploads/2014/11/screenshot071103_581248.png

Add the following formula:

Local NumberVar i;

Local numberVar v;

For i := 0 To CurrentColumnIndex Do

(

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

);

v




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,

Alaa

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply