troubleshooting Question

How to create a total in Crystal Reports form

Avatar of mrizo
mrizo asked on
SoftwareCrystal ReportsMicrosoft Applications
2 Comments1 Solution348 ViewsLast Modified:
I am using Crystal Reports XI.  I am using a form that was created for the ACCPAC accounting system. (see attached)  In ACCPAC users can select on items and miscellaneous charges.  I want to create total for just two of the misc. charges.  The charges are called "AIR" and "OCEAN" respectively.  I want to be able to carry this two fields and total on the form.  However, they need to be subtracted from the sub-total.  See example,
At bottom of form
Subtotal=Total line items + any other misc. charges.(not to include AIR and OCEAN
AIR & OCEAN= Total of AIR and/or OCEAN misc. charges selected for this order ONLY
Total=Total of order to include both items shown above.

I seem to be able to figure out on my laptop, but then copy file on server and got different amounts when file was executed.  Be sure to change path of file from txt to rpt if you want to open in Crystal Reports.
Please advise

Marlon Rizo
OECOMINV.txt
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros