?
Solved

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

Posted on 2011-03-15
6
Medium Priority
?
409 Views
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?

0
Comment
Question by:DSIGRIS
  • 3
  • 3
6 Comments
 
LVL 101

Expert Comment

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

mlmcc
0
 

Author Comment

by:DSIGRIS
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.
0
 
LVL 101

Expert Comment

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

mlmcc
0
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 

Author Comment

by:DSIGRIS
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.
0
 
LVL 101

Accepted Solution

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

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

mlmcc
0
 

Author Closing Comment

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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Integration Management Part 2
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 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