Conditional Summary on Report

[Former Member]

Hi there

Can I ask for guidance on using Crystal Reports 2008 please?

I am extracting data from a SAP Business one SQL 2005 database. What I would like to do is place a summary field upon the report based upon different selections of data that has been extracted from the database.

Data extract example:

Account - Quantity - Date

A1 10 1/10/08

A1 20 2/10/08

B1 5 1/10/08

C3 100 5/10/08

B1 10 4/10/08

The Summary field I would like on the report would show the combined summary of A1 only. The other data would still be used in the report in other area's.

Thank you in advance for any assstance.

Cheers

Dave Ainsworth

[Former Member · Accepted solution]

Hi David,

You can create a running total to get this :

In the field explorer, under running total create a new and give the name.

Select the field "Quantity"

Under evaluate, select the formula and write the following :

if Account = A1 tHEN TRUE

Reset Never

now place this running total in your report.

Thanks,

Sastry

[Former Member · Accepted solution]

That has worked perfectly.

Thank you for your help.

Dave A.