Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you display the top 10 values 1

Status
Not open for further replies.

Charley71

Technical User
Aug 17, 2007
31
US
I have a report that will show a variety of information. This is coming from a spreadsheet. I have 15 rows of data with a count for each field. Column A=Inspection and Column B=count.

I want to create a chart with only the top 10 inspections. Is there a way to display only the top 10?
(this is only one section of the report)

I am using crystal reports XI develper.

Thanks
 
Build a top ten report based on the group you want Inspections (Where others are discrded)and then base your chart on this group within the report.

Ian
 
When you create the chart, use advanced layout. After adding both the on change of field and the show value field, highlight the on change of field->topN button and limit the values there.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top