Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 25 Sep 2007 at 10:48am
You need to create a formula which returns a group number based on the parameters. Then create a group using that formula field. Here is a close proximity to what you would need (you'll have to test and tweak it to make it perfect):
NumberVar Group; NumberVar Counter; Counter := FromRate; Group := 0; While Counter<ToRate Do { //Incrementing to move to the next group
Counter := Counter + Margin;
Group := Group + 1;
//If we found the group, then exit the loop by maximizing the counter If {table.field}<Counter Then Counter := 99999; } //Return the group number Group;
Edited by BrianBischof - 25 Sep 2007 at 10:49am
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>
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