Solved

Need help getting a count

Posted on 2008-10-09
13
195 Views
Last Modified: 2010-04-21
I have a report were I have the top 3 categories of our Helpdesk system.  I need to get a count for how many times each of these categories were used.  Anybody have an Idea on how to do this?
0
Comment
Question by:Icontech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
  • 2
13 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22679787
I assume you have a group in the report for the category.

If not add one

Then use the count function
Count({SomeField},{CategoryField})

mlmcc
0
 
LVL 16

Accepted Solution

by:
wykabryan earned 500 total points
ID: 22679803
a running total.  
give the running total a name
field to summarize: pick a field that is most distinct
type of summary: count

evaluate:
use a formula: {category field} in ['your','fields','here']

reset
never - grand total
or
On change of group
0
 
LVL 1

Author Comment

by:Icontech
ID: 22679876
Its grouped by Queue and then I used Nth most freq to find each category.  I have an N = 1, an N = 2, and an N = 3.  I need a count for each on of these when the queue changes. How do I get it do count just the category that is displayed without hard coding the specific category.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 100

Expert Comment

by:mlmcc
ID: 22679908
Right click a field in the detail section
Click INSERT  --> SUMMARY
Choose COUNT as the summary function
Put it in the group footer

mlmcc
0
 
LVL 1

Author Comment

by:Icontech
ID: 22679935
This will give me the count for all categories in that group not just the top category in that group.
0
 
LVL 1

Author Comment

by:Icontech
ID: 22679953
I need the count for the number one must used category that was used by each queue.
0
 
LVL 16

Expert Comment

by:wykabryan
ID: 22679955
yeah.. mlmcc.. he only wants the count of the top 3.  and the top 3 change so he does not want to go into the formula and change it.

Well in theory.. you would want to read each one of your top 3 into a variable. Then cycle through and count where variable equals the column. But i am not sure how this is done.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22679988
What groups fo you have on the report?

Where do you want the count shown?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22680011
So do you have it like this

Group 1 - QUEUE
Group 2 - CATEGORY

Try this idea
In the QUEUE group header add a formula

WhilePrintingrecords;
Global numberVar QueueCount;
QueueCount := 0;
''

In the CATEGORY group footer
WhilePrintingrecords;
Global numberVar QueueCount;
QueueCount := QueueCount + Count({SomeField},{CategoryField})
''

In the QUEUE group footer
WhilePrintingrecords;
Global numberVar QueueCount;
QueueCount

mlmcc
0
 
LVL 1

Author Comment

by:Icontech
ID: 22680226
I only have it groped by queue.  When I added the group by category it then shows all categories not just the top 3 most used.  This will not work because of that.  I only need the count for the top 3 categories used by the each queue.
0
 
LVL 1

Author Closing Comment

by:Icontech
ID: 31504714
Once I figured out the evaluation port it worked.  Thanks for your help. The part it took me a little bit on was [your fields here].  My field was the Nth formula that I used to figure out the top 3 categories.  Thanks for your help.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22680590
In that case you will have to use formulas to count the records or a running total as wykabryan suggested.

mlmcc
0
 
LVL 1

Author Comment

by:Icontech
ID: 22680661
I did a running count with the evaluation of
{workitem_current_view.workitem_category_tree_value} = NthMostFrequent (1, {workitem_current_view.workitem_category_tree_value}, {workitem_current_view.owned_by_worker_name}).  I had to setup three of them.  What he said was exactly right I just had to figure out what the formula was.  And then also reset on group.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
"A string is required here" error in Formula 7 70
Crystal Reports 2013 25 78
Crystal Reports - Record selection filter - formula editor 3 53
Crystal Reports - Logos 2 33
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

739 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