Print Page | Close Window

Cross tab (running percentage)

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005-2015
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
Printed Date: 01 Jun 2020 at 1:31pm

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?

           Month 1     Month2    Month 3     Total
Vendor A
Vendor B
Vendor C

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