Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Top N

Status
Not open for further replies.
diannelight

diannelight

Technical User
Feb 24, 2003
59
0
0
US
I have 4 different graphs on one report and I need to set up a Top N for each.
Is the Top N for the whole report only, or is there a way to have a number of different ones set up?
Example:
Graph one;
Created a summary for 'Calls Made' per Agent. Graph shows top 10 agents.
Graph two;
Created a summary for 'Calls Received' per Agent. Graph shows top 5 agents.
etc.
 
Sort by date Sort by votes
What I'm finding is that the report will only show the top 10 agents that are common in all graphs.
I need to treat each graph as a seperate query.
Above info didn't give me any ideas.
I am using Version 9 & Field Definition files.
I would be very grateful for some more pointers.
Thanks.
 
Upvote 0 Downvote
Top N is for each graph, providing that you're using just One on change of.

For "Created a summary for 'Calls Made' per Agent. Graph shows top 10 agents"

Select Agent as the on change of, and add in the Calls Made for the Show Values, then click the Agent and select TOP N and set it to For This Group Sort to TOP N based on calls made where N is 10.

Uncheck Others if you don't want them in there under the generic title Others.

-k
 
Upvote 0 Downvote
K,
Thank you - this is what I have done.
But as I say, when I run the report it only shows the common agents in each graph.
 
Upvote 0 Downvote
What does common agents mean?

Where are these graphs?

If the graph is at a agent group level, or a group level with only some agents, then that's all it should show.

Place the graphs at the report footer and see iof that produces the expected results.

-k
 
Upvote 0 Downvote
K, The graphs are in the report header.
What I mean by common agents is that if 'Agent A' has data in all graphs (ie. he has made and received calls and he is in the top 10) then he will show on the graphs.
If 'Agent A' has made calls but not received calls, graphs will all be blank.
I will place the graphs at the footer but I'm not sure that this will make a difference.
I hope this is a bit clearer.
 
Upvote 0 Downvote
Have tried placing the graphs in the footer but still get the same response.
Any other ideas?
Thanks.
 
Upvote 0 Downvote
Dianne,

I just recreated your problem. I created two graphs, with different topN agents showing up in each. Then I did a topN on the main report, and the graphs changed to only show those agents within the topN on the main report. So, I think you must have topN set up in the main report, and the solution is to remove it, and only use the topN feature within the individual graphs.

-LB
 
Upvote 0 Downvote
It sounds like you have a TopN set for the whole report. Turn that TopN off, and only do the TopN inside each Chart Expert.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
 
Upvote 0 Downvote
LB / Ken,
Thank you for your replies.
I checked my report and did not have a TopN set for the entire report.
Decided to re-create the report from scratch. It now does show the expected results for each graph.
However, I don't want to see the agent names that have zero values against them.
In the formula's, I have created 'Calls Made > 0' but it then puts all the values for agents as '1'?
 
Upvote 0 Downvote
Use a subtotal, not the field, in your crieteria. If you have the count of Calls on the report there will be a sigma that indicates this in the field list.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
 
Upvote 0 Downvote
Ken, I'm not sure that I understand what you mean.
When I create a count, it only counts the records not the calls made per agent (which I expect).
I have tried a running total but that just gives me the same figures as previously and still shows the agent names with zero values.
Please explain further. Thank you.

 
Upvote 0 Downvote
Maybe I misunderstood. Where are you seeing the agents with 0 calls? Is the 0 calls a subtotal in the report?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
 
Upvote 0 Downvote
Ken,
The zero values are showing on the graphs ie. Graph shows top 10 agent names even if they have not made any calls.
I would like to just see those that have data.
I have not included any summaries on these 'made calls', just 'Made Calls'/ Agent name - the data is correct.
Thanks again.
 
Upvote 0 Downvote
What is the "SHOW" value (subtotal) used in the chart(s)?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
 
Upvote 0 Downvote
The 'Show values' is 'Calls Made' with the 'Don't Summarize' box selected.
The Agent Name has a group sort of Top N based on 'sum of Calls Made' where N is 10 , and 'Include Ties' selected (although I have tried de-selecting this too).
 
Upvote 0 Downvote
It doesn't make sense that the TopN uses the Sum of Calls Made, while the Chart shows Calls Made with no Summary. What happens if you take out the "Dont Summarize" option and sum there also?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
 
Upvote 0 Downvote
Ken, I've taken out the 'Don't Summarize' option.
Unfortunately, I can't figure how it's calculated it but the figures are now way out - it still shows data for the agents that previously had data and the names of the agents in the group without data.
 
Upvote 0 Downvote
You have to figure out if this field needs to be summed or not. If it should NOT be summed then your TopN on a sum is not going to be accurate. What table is this field in? What other tables are in the report.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Mouse Clicks not Working in Sections Area
Replies
2
Views
117
socalvelo
socalvelo
Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
70
hilfy
hilfy
CodeWell
  • Locked
  • Question
Crystal Reports RPTR Format Not Available
Replies
2
Views
88
CodeWell
CodeWell
Bloke152
  • Locked
  • Question
Conditional number formatting in Excel export
Replies
3
Views
65
SkipVought
S
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
61
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top