Crystal Reports Tools: Improve Performance While Saving Time and Money

  Resources  
Best sellers:
cView
Report Analyzer
cViewSERVER
ReCrystallize
 

Buy Crystal Reports


Articles:
Administration
Advanced
Basic
Crystal eNL
Database
Financial
Problems Solved

Books:
CR Books

Database Books
Developer Books

 
Tools:
All CR Tools
CR Analyzers
CR Bestsellers
DataBase Tools
CR Graphics
International
CR Mail UFLs
ReCrystallizePro
CR Schedulers
CR UFLs
CR Viewers


Add'l:

About us

Contact Us
cViewSUITE Ppt
Support

CR trial
 

Crystal Reports
on Steroids

Crystal Reports Basics: Summary Fields and Statistical Functions

This is based on the book, Crystal Reports: A Beginner’s Guide. For more detail and explanation, plus practice exercises, order the book here.

Crystal Reports provides many statistical functions, all of which are covered in detail in Crystal Reports: A Beginner’s Guide. These differ from the summary fields.

Summary Fields

  • Sum
  • Average
  • Minimum
  • Maximum
  • Count
  • Distinct Count (counts duplicates only once)

Statistical Functions

  • Correlation
  • Covariance
  • Median
  • Mode
  • Nth Largest
  • Nth Smallest
  • Nth Most Frequent
  • Pth percentile
  • Sample Variance
  • Standard Deviation
  • Population Variance
  • Weighted Average

For even more functionality, you can use third-party programs, such as the ones available here.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.