How to manage the print line for Crystal Top N Others line

Posted on 2011-03-15
Last Modified: 2012-05-11
I have developed a report that lists the annual volume of business with our Suppliers (annual PO Value). To focus on the Top 20 suppliers, I used a Top N report showing the group totals.

Since the Supplier Number is the key to the record, I put the Supplier Name in the Group Footer alongside each Supplier Number. There are also totals, other than PO Value, in the Group Footer section.

If I include Others in the Top N, I get the next Supplier Name, as well as a bunch of numbers in the other columns that I do not understand.

How can I blank out the Supplier Name when Others is the last line in the Top N report? How can I blank out the other numbers in the columns other than the column used for the Top N calculation?

Question by:DSIGRIS
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
  • 3
  • 3
LVL 100

Expert Comment

ID: 35143337
Is this the group footer you are trying to suppress?
You might be able to conditionally suppress with OnLastRecord


Author Comment

ID: 35149121
Since the Top N process is a sorted group, and the print line is the group totals, I am not sure the OnLastRecord would work for group totals.  

I had thought of using a Running Total, where the field suppress logic might work.  For a Top N report of 20 groups, maybe suppress on 21 would work.
LVL 100

Expert Comment

ID: 35150267
You also might be anle to conditionally suppress based on the groupfield = 'Others'

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button


Author Comment

ID: 35152374
The field "Others" is not a valid group field,  Apparently, it is a system field and you cannot test for it, as far as I can tell.

I guess not many folks have actually put in much time on a group Top N report.  I find this concept very useful, but it needs some more technical support.  When you add graphicas like bar charts and pie charts to the report, it become something much like an executive dashboard.
LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 35152507
I sort of expected that.

I don't use it much and the times i didn't use the others.


Author Closing Comment

ID: 35152708
There does not seem to be a standard method when using Top N group reports that contain Others.

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

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…
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 …
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…

730 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