Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Cross tab sum 4 times Post Reply Post New Topic
Author Message
hiuyil
Newbie
Newbie


Joined: 29 May 2011
Location: Hong Kong
Online Status: Offline
Posts: 6
Quote hiuyil Replybullet Topic: Cross tab sum 4 times
    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!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.