Print Page | Close Window

Cross tab sum 4 times

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13461
Printed Date: 27 May 2024 at 1:16pm


Topic: Cross tab sum 4 times
Posted By: hiuyil
Subject: Cross tab sum 4 times
Date Posted: 09 Jun 2011 at 7:44pm
I prepared a cross tab which need to display the item no, description, pur/sales price and the inventory qty.
 
e.g.
Item    Description    PurPrice   SalesPrice   WarehouseA                
WXYZ  sample item    0.5           3                      20pcs
ABCD  example         1.5           6                      40pcs
 
For actual inventory qty, WXYZ is 5pcs and ABCD is 10pcs. However, It sums the actual qty 4 times.
 
Do you guys know how it could be fixed ?
 
Thank so much!


Print Page | Close Window