• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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

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?

0
DSIGRIS
Asked:
DSIGRIS
  • 3
  • 3
1 Solution
 
mlmccCommented:
Is this the group footer you are trying to suppress?
You might be able to conditionally suppress with OnLastRecord

mlmcc
0
 
DSIGRISAuthor Commented:
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.
0
 
mlmccCommented:
You also might be anle to conditionally suppress based on the groupfield = 'Others'

mlmcc
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
DSIGRISAuthor Commented:
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.
0
 
mlmccCommented:
I sort of expected that.

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

mlmcc
0
 
DSIGRISAuthor Commented:
There does not seem to be a standard method when using Top N group reports that contain Others.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now