Skip to Content
0
Former Member
Apr 22, 2014 at 07:01 AM

How to calculate Sum of records that are not Suppressed

134 Views

Hi All Experts,

I have Created A layout for SAP B1 in crystal report.Because of Some Condition I have to Suppress Detail Section.

The Suppress Condition is As Follows

{ExcisePur.ItemCode}=Previous({ExcisePur.ItemCode}) And {ExcisePur.Batchnum}=Previous({ExcisePur.Batchnum})

And it is Working Fine,the Desired Detail Section is Suppressed.

Now I Have to take Sum of Records ,But that records are also Calculated which are Suppressed.

For these I have Read Several post where someone had same problem,

there they have Asked to Create A Running Total And use the Formula in evaluate section same as in Suppress Condition but opposite of it.

I did the same thing using these Formula

{ExcisePur.ItemCode}<>Previous({ExcisePur.ItemCode}) And {ExcisePur.Batchnum}<>Previous({ExcisePur.Batchnum})

But it is Calculating only the Suppressed Record But Not the Record which is to be Calculated.

Please help me to Accomplish this.

I am very Much blank where I am going wrong.

Regards,

Gayatri Shukla