Make a Pareto Chart in Crystal Reports

I had recently needed to make a Pareto analysis chart in Crystal Reports and couldn’t figure out how to do it through the chart expert.

The trick is to Record Sort the data into the order you want and it will sort the bar chart the same way. I did an SQL view to which listed my unique descriptions and then a COUNT() operation.

Then when I pulled the view into Crystal Reports, I added a bar chart and then I set the “For Each Record” to the description and then in “Show Values” I put the grouped count.

Using Report >> Record Sort Expert I just sorted by the count descending and the bar chart switched to the pareto chart style sorting.

Leave a comment if you have any other questions,

Mike

Leave a Reply

Your email address will not be published. Required fields are marked *