Print Page | Close Window

Show Percentage on Cross Tab

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=2618
Printed Date: 05 May 2024 at 11:00pm


Topic: Show Percentage on Cross Tab
Posted By: pellis
Subject: Show Percentage on Cross Tab
Date Posted: 14 Mar 2008 at 1:05pm
Hello,
I have a problem in trying to show a percentage on a Crystal Reports XI cross tab reports.  The requirement is to show the percentage of growth from month to month for images posted on a website. 
 
Looks something like this"
 
Total     /   Jan 2007  /     Feb 2007  /  Mar 2007
______/_________/___________/__________
Blog    /      12        /       50           /      75
Photo /       0         /        24          /      40
Forum/       5         /         18         /       45
 
How do I calculate a percentage of the growth month to month for each type of posting?  I've tried several things, but nothing is working.  Any help would be greatly appreciated.
 
Thanks
 
pellis
 
 


Replies:
Posted By: BrianBischof
Date Posted: 14 Mar 2008 at 4:18pm
This is actually a bit complicated and I explained the details in other posts on the forum. Do a search to see if those posts help you out.

Also, I have sample code fully documented in my online ebooks in the premier section. You can check it out here if you wish.  http://members.crystalreportsbook.com/ - http://members.crystalreportsbook.com/


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: pellis
Date Posted: 17 Mar 2008 at 12:48pm
Thanks so much.  I will search your previous posts to see if I can find a solution.
 
Thanks again.
 
pellis

Posted By: Byvalyi
Date Posted: 03 Jun 2008 at 8:08am
Hi Pellis, I found a reference to a solutions for the whole class of similar tasks at http://www.relasoft.net/KB10001.html - http://www.relasoft.net/KB10001.html  but that solution is a powerful monster and requires programming.
 
Cheers


-------------
Don't die from smoking, die for other causes

Posted By: twinkle
Date Posted: 17 Jun 2008 at 2:54pm
have you thought about using a Sub report or grouping instead of Cross tab?  that way you could use running totals and then create the req formula!


Print Page | Close Window