Conditional Summary on Report
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.
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
now place this running total in your report.