Crystal 10: Sorting TopN with Multiple Groups?

[erac78]

Hello,

I am working on a report in Crystal 10 in which I have 3 groups. The groups are "Category", "Sub Category" and "Product Type" for a ticketing system. I have a count on the third group, Product Type which shows a count of all tickets which have each Product Type over a specified time frame. My issue is that I need to sort this count to only show the top 10 counts and, TopN does not work for me due to this being the third group in order. I know that getting rid of the top 2 groups would solve the problem however, we have to have the groups set up in this order for the count to be accurate due to the nature of the database that we're working with. If anyone can offer suggestions as to how I can limit the count on this bottom group to only show the top 10, it would be greatly appreciated!!

 

[lbass]

When you go to topN/group sort, if you have multiple groups, there will be separate tabs for each. Choose the tab for Product Type and choose the topN sort only on that group.

-LB

 

[erac78]

Thanks for your response however, this does not solve my issue.

The problem I'm having is that any group other than the top group will not actually sort and elminate the other results when I apply TopN sorting. If I apply TopN to a count on the top group, it works fine or, if I make Product Type the top group, it works fine. When I apply TopN to a count on the second or third group, it basically does nothing, all of the results remain and they are not even sorted highest to lowest. And, the only way to have an accurate count of Product Type is to have the 3 level grouping with it as the third group.

Please give me some ideas on how to only show the Top 10 counts on a field without using TopN! Thanks!!

 

[lbass]

I believe you are using topN incorrectly. Please try again.

If I am mistaken, then I think you need to convey in more detail what is going on. Nested group sorts ordinarily work fine. For further help, I think you should show sample results and also a sample of how you expect your results to look.

-LB

 

[gruf1968]

Hope you can help a newbie? I have just started to use Crystal Reports 10 and have hit a problem. I have a number field that represents an average talk time so I need to view it as hh:mm:ss but I am buggered if I can find a way of doing it. Any ideas??

Gareth

 

[lbass]

Please start a new thread, as your quesiton does not relate to this thread topic.

-LB