Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Dividing specified records within a group Post Reply Post New Topic
Author Message
Matt12391
Newbie
Newbie


Joined: 26 Nov 2012
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote Matt12391 Replybullet Topic: Dividing specified records within a group
     Posted: 26 Nov 2012 at 11:05pm
Ok so I have a report split into groups by employee grade. Each employee grade has a different midpoint. How do I specify in a formula that I want to divide the employee midpoint from one group by the employee midpoint of another group. Been annoying me for a few days.
 
Thanks
 


Edited by Matt12391 - 26 Nov 2012 at 11:05pm
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 27 Nov 2012 at 1:29am
Hi
 
Can you post your query with a  sample data so that it will be easy for us to answer.
 
--Post your data like ...How is your data ?  How you want to see  ?
Thanks,
Sastry
IP IP Logged
Matt12391
Newbie
Newbie


Joined: 26 Nov 2012
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote Matt12391 Replybullet Posted: 27 Nov 2012 at 1:34am

Group-Grade  

   11
           500  
   12
           600
 
The 11 and 12 are in the group "Grade" i would like to be able to divide 500/600 using a forumla.
Thanks
  
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 27 Nov 2012 at 2:26am
Hi
Create a formula to store previous mid point like :
 
Whileprintingrecords;
numbervar Pmid;
Pmid:={gorupMidValue}
 
Place the above formula in your group footer and divide with your next mid point.
 
Still you need some help send a sample report on sastrydsvs(at)gmail(dot)com
 
Thanks,
Sastry
IP IP Logged
Matt12391
Newbie
Newbie


Joined: 26 Nov 2012
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote Matt12391 Replybullet Posted: 27 Nov 2012 at 4:12am
Sorry i wasnt clear enough, realistically it is more like:

Group-Grade  

   11
           500  
   12
           600
   13
            700
   14
          300
 
And i would need to divide 600/500, 700/600 and 300/700.
So as there are more than two records im presuming the method you suggested wouldnt work? Sorry. Any other suggestions? Thanks


Edited by Matt12391 - 27 Nov 2012 at 4:14am
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.