Active TopicsMemberlistSearchHelpRegisterLogin

Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Show Percentage on Cross Tab Post Reply Post New Topic
Author Message
pellis
Newbie
Newbie


Joined: 09 Mar 2008
Online Status: Offline
Posts: 14
Quote pellis Replybullet Topic: Show Percentage on Cross Tab
    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
 
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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/
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>
IP IP Logged
pellis
Newbie
Newbie


Joined: 09 Mar 2008
Online Status: Offline
Posts: 14
Quote pellis Replybullet 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
IP IP Logged
Byvalyi
Newbie
Newbie


Joined: 03 Jun 2008
Location: Canada
Online Status: Offline
Posts: 1
Quote Byvalyi Replybullet 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 but that solution is a powerful monster and requires programming.
 
Cheers
Don't die from smoking, die for other causes
IP IP Logged
twinkle
Newbie
Newbie
Avatar

Joined: 16 Jun 2008
Location: United Kingdom
Online Status: Offline
Posts: 32
Quote twinkle Replybullet 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!
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.