Print Page | Close Window

Cross tab (running percentage) Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Tips and Tricks Forum Discription: Have you learned some great tricks to share with the group? Post them here! URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13475 Printed Date: 23 Apr 2024 at 2:41am Topic: Cross tab (running percentage) Posted By: jayson Subject: Cross tab (running percentage) Date Posted: 12 Jun 2011 at 8:42pm Dear All, I have an issue in crosstab by providing a running percentage, im using CR 2008. in my row name i have the vendor name while in my column i have the month sales. Per vendor their are several invoices which has the the net and gross price and 1 vendor can consist of more than several invoices. how to get the the percentage for each vendor the total net/gross price of invoices? e.g            Month 1     Month2    Month 3     Total Vendor A Vendor B Vendor C Total       Hope that you could help me... i tried the gridvalueat function and it works but my concern is the alignment since its not necessary to show the net and gross price of the total invoice per vendor. is their anyway i can just sum(net) % sum(gross)?!?!

Print Page | Close Window