Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Need to calc percent in GF using Grand Totals Post Reply Post New Topic
<< Prev Page  of 2
Author Message
luk1128
Newbie
Newbie
Avatar

Joined: 20 Jun 2007
Location: United States
Online Status: Offline
Posts: 6
Quote luk1128 Replybullet Posted: 22 Jun 2007 at 12:04pm
WhilePrintingRecords worked!  Thank you!!Clap
 
However, after all of that, I noticed a fundamental flaw in this whole thing.  The DCNs are not in order because it is grouped bt Error Type, so if one DCN has 2 different error types, they are not going to be listed together anyway, so comparing the DCN to the previous isn't going to work...
 
It's so frustrating because I can see what the distinct count of the total is, but I cant use it! 
 
Thanks for all your help.
 
I think I'm going to have to tell the business team that I cannot provide the percentage of DCNs. Dead
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 22 Jun 2007 at 12:58pm
Well, I'm glad it worked, but I'm not glad that it still doesn't work (as if that makes any sense). Here is how I would do it, but you're going to have to write some code. I would create two global arrays. As you read each DCN in, I would loop through the array to see if it already exists or not. If it does, then increment the counter in the second array using the same index number. If it doesn't exist, then add it to the end of the first array and then start the counter in the second array with a '1' as the initial value. I don't know if you know enough about CR programming to pull this off or not (or how much time you can allocate to the report), but this is the way I would approach it if you really need this report to work.

HTH.
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
<< Prev Page  of 2
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.016 seconds.