Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Looking for some help. New here. Post Reply Post New Topic
Author Message
mlrosier
Newbie
Newbie


Joined: 21 Jan 2011
Online Status: Offline
Posts: 5
Quote mlrosier Replybullet Topic: Looking for some help. New here.
    Posted: 21 Jan 2011 at 8:32am
I am working on a report here that needs to have the Top 3 most frequent inquiries, followed by a number count displaying the number of times that inquiry was made. I am pulling my eyes out trying to figure out how to do this.
 
This is what I'm needing to see:
 
The Top Three Inquiries were:
 
    1. Another Division (20)
    2. Control of the topic (11)
    3. Additional Information (6)
 
I need this information in either the page header or the report footer.
I am using an Nth Most Frequent Summary for each of the Top Spots, but I cannot get a count on each of those Summaries. I need to display 20 as the number of occurrences for the Number One  Inquiry, so on and so forth. I don't understand why you can't do what should be the simplest things in Crystal, and it's driving me nuts.

I would be super grateful for any help I can get on this.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 21 Jan 2011 at 8:56am

group on the field that has your types (another division,control of the topic, additional info)

Use an insert summary to get a count of that field at that group level (i am ghuessing here so you may need to change it to another summary type)
NOw your Grouop Sort Expert will be available for use (button with blue chart linewith Red up arrow on it).
click on it
select the group name Tab you want to work on(likely defaulted to it)
fro this group pick Top N
Where N is enter 3
based on select the summary here
Youc an incluse other is you want
 
 
IP IP Logged
mlrosier
Newbie
Newbie


Joined: 21 Jan 2011
Online Status: Offline
Posts: 5
Quote mlrosier Replybullet Posted: 21 Jan 2011 at 9:39am
Thank you SO much. That worked like a charm. Man,... I AM new. I basically did what you said in a SubReport, and then added that Sub Report to the Report Header of the Main Report. I am super grateful for the help. Thank you a TON.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.063 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.