Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conditional Summary on Report

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
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question