[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1120
  • Last Modified:

Is it possible to get cumulative percentage of a running total on a count in Crystal Reports?

Here is what I have so far:
Report Query:
Group  SELECT "Type", "H_OOS"."Lot_Number"
 FROM   "OfflineED"."dbo"."H_OOS" "H_OOS"
 WHERE  ("H_OOS"."Lot_Number">='08297' AND "H_OOS"."Lot_Number"<='09027')
 ORDER BY "H_OOS"."Type", "H_OOS"."Lot_Number"

The Lot_Number is a string, but used as a date - 090207 = Feb 7, 2009
I have a bar graph on the report with count of type  and asked to add line graph with the cumulative percentage :
Example:
Appearance
09007
09016
09021
09022
09023
Total 5
 RTotalC 5

Fill
09019
Total 1
RTotalC 6

Color
08297
09008
09008
09012
Total 4
RTotalC  10

 Create cumulative %  and graph
50%
60%
100%



0
trilian
Asked:
trilian
1 Solution
 
Dan WeingartAuthor / CRChartCommented:
Hi,

Sounds like you are trying to create what is known as a "pareto" graph. This graph is often used in quality-control reporting.

Pareto's are not part of standard Crystal Reports. It might be possible to "simulate" the look with clever use of overlays or other charting tricks.

If all else fails, this graph IS part of our CRChart add-in library.

-Dan

Disclaimer: I work for the company, www.threedgraphics.com, that makes this product. This product costs money.
0

Featured Post

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.

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