Solved

How to group based on a calcualted range / running total

Posted on 2011-02-28
7
322 Views
Last Modified: 2012-05-11
I have to calculate a donor's frequency for the year. The frequency is not stored in the db so I have to create a running total which populatedthe freq # once the report is generated. Now where I'm having problem is trying to calculate how many donors fall under a certain range of frequency

A-2
B-1
C-3
D-1
E-1

basically it be
Freq 1 = 3 donor
Fre 2 =1 donor
Fre 3 = 1 Donor
0
Comment
Question by:analliah
  • 3
  • 2
7 Comments
 
LVL 17

Expert Comment

by:pssandhu
Comment Utility
Lets assume the name of the formula that is calculating the frequency is called FRQ. Now follow these steps to create a group:

1. Create a new formula called Donors type this code:
    Whileprintingrecords;
   
     Split({@FRQ},"-")[2]

2. Place the formula right beside the FRQ formula.
3. Right click on the new formula, Donors, choose Format Field and go under the Common Tab.
4. Check the Suppress selection to hide the formula.
5. Click okay.
6. Then click on the "Insert" menu on the top and select Group.
7. Select the Donors formula as the group by field
8. Done

Hope this helps.

P.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
You can't group on running totals or print time formulas

You can try this idea

Group by donor
Add a summary which is a count showing how many records for that donor
You can then sort the donor groups on that formula

mlmcc
0
 
LVL 5

Author Comment

by:analliah
Comment Utility
the formula is not an options to group by. my FRQ formula is actually a running total and it's placed under GF1.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 5

Author Comment

by:analliah
Comment Utility
@mlmcc

I kinda figured that was the problem. My work around is to export the data to access and create another report to read the export data again which allows me to do the grouping ( not user friendly) . And If the rpt is small I use nested select statement  to give me the summary

Any suggestion what else I could do.

 
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Did you try my idea on grouping by donor then sorting by the summary field?

You could use formulas and track how many of each number then print at the end.

If all you want is the summary then you can do it with formulas and don't put any fields on the report.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now