Crystal Reports

Crystal Reports

Crystal Reports 2008 displaying a sample report
Developer(s) BusinessObjects
Operating system Windows
Available in Chinese (Simplified), Chinese (Traditional), English, French, German, Italian, Japanese, Korean, Spanish
Type Reporting software
License Trialware
Website www.crystalreports.com

Crystal Reports is a business intelligence application, currently marketed to small businesses[1] by SAP SE. It is used to design and generate reports from a wide range of data sources.[2]

History

Terry Cunningham and the Cunningham Group originated the software in 1991.[3] Crystal Services Inc. marketed the product[4] (originally called "Quick Reports") when they couldn't find a suitable commercial report writer for their accounting software. After producing versions 1.0 through 3.0, Crystal Services was acquired in 1994 by Seagate Technology.[5] Crystal Services was combined with Holistic Systems to form the Information Management Group of Seagate Software, which later rebranded as Crystal Decisions and produced versions 4.0 through 9.0. Crystal Decisions was acquired in December 2003 by BusinessObjects, which produced versions 10, 11 (XI) and version 12 (2008). SAP acquired BusinessObjects on October 8, 2007 and released Crystal Reports 2011 (version 14) on May 3, 2011.

Several other applications, including Microsoft Visual Studio versions 2003 through 2008, and Borland Delphi, at one time bundled an OEM version of Crystal Reports as a general purpose reporting tool.[6] Microsoft discontinued this practice and later released their own competitive reporting tool, SQL Server Reporting Services (SSRS).[7]

Versions and Editions

Version Release Date[8] Ownership
1   Crystal Services  
2 1992 Crystal Services  
3 1994 Crystal Services  
4 1995 Crystal Decisions  
5 1996 Crystal Decisions  
6 1997 Crystal Decisions  
7 1998 Crystal Decisions  
8 2000 Crystal Decisions D,P,S
8.5 2001 Crystal Decisions A,D,P,S
9 2002 Crystal Decisions A,D,P,S
10 2003 BusinessObjects A,D,P,S
XI (11) 2004 BusinessObjects D,P,S
XI R2 (11.5) Nov 24, 2005 BusinessObjects D,P,S
2008 (12) Mar 31, 2008 BusinessObjects D
2011 (14.0.x) Aug 31, 2011 SAP SE  
2013 (14.1.x)   SAP SE  
2016 (14.2.x) SAP SE
Nothing new yet July 2016

Features

Report designer

   Crystal Reports allows users to graphically design data connection(s) and report layout. In the Database Expert, users can select and link tables from a wide variety of data sources, including Microsoft Excel spreadsheets, Oracle databases, Microsoft SQL Server databases, Microsoft Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface.  Formulas can be evaluated at several phases during report generation as specified by the developer.

Both fields and formulas have a wide array of formatting options available, which designers can apply absolutely or conditionally. The data can be grouped into bands, each of which can be split further and conditionally suppressed as needed. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Central Management Server

The Central Management Server (CMS, formerly "Crystal Management Server") operates as the main server for BusinessObjects XI.[10]

Supported data sources

Target audience

Crystal Reports became integrated with Visual Studio versions prior to 2010. Crystal Reports competes with several products in the Microsoft market, such as SQL Server Reporting Services, XtraReports, ActiveReports and List & Label. Users can also access Crystal Reports from outside of Microsoft environments; this allows (for instance) Java developers to build applications with Crystal Reports components.

See also

References

  1. ↑ Crystal Reports small business marketing website
  2. ↑ Official Website
  3. ↑ "Meet the Team". Retrieved 2012-10-11. That's what initially motivated his family business, The Cunningham Group, and his brother Terry to begin building [...] Crystal Reports in 1991.
  4. ↑ "Crystal Reports links dBASE and Paradox data". Data Based Advisor. September 1, 1992. Retrieved 2009-07-09. Crystal Services says that they will address both the installation problem and the documentation omission in the new version. [...] Crystal Reports is being marketed by them and Borland International [...]
  5. ↑ "Seagate to acquire Crystal Services". San Jose Mercury News. 1994-05-11. Retrieved 2009-04-14.
  6. ↑ Peck, George (2008). Crystal Reports 2008: The Complete Reference. McGraw-Hill Professional. p. 566. ISBN 978-0-07-159098-3. Retrieved 2009-07-09. Not only was Crystal Reports bundled with earlier versions of Visual Basic..., but every Professional or higher version of VS.NET, up to and including Visual Studio 2008, includes an option to install Crystal Reports as well....
  7. ↑ "Support for Crystal Reports for Visual Studio".
  8. ↑ Short history and resources for Crystal Reports Software Developer Kits (SDK)
  9. ↑ (PDF) http://www.recrystallize.com/merchant/crystal-reports/Crystal_Reports_2008_version_comparison.pdf. Missing or empty |title= (help)
  10. ↑ Ganz, Carl (2006). Pro Crystal Enterprise / BusinessObjects XI Programming. Expert's voice in .NET. Apress. p. 22. ISBN 9781430202776. Retrieved 2014-09-25. The aptly named Central Management Server (CMS) is the main server in the BO XI collection. Before the rebranding effort, it was known as the Crystal Management Server, and before that as the Automated Process Scheduler (APS).
  11. ↑ Compare for example: "Crystal Reports Server 2008 V1 Service Pack 4 for Windows: Supported Platforms". SAP Community Network. SAP. 2012-02-15. pp. 8ff. Retrieved 2015-07-28. Supported Data Sources for Crystal Reports
  12. ↑ Fitzgerald, Neil (2008). Crystal Reports 2008 Official Guide. Business Objects Press. Pearson Education. ISBN 9780768685701. Retrieved 2015-07-27. The two major indirect access drivers provided are ODBC and OLE DB. [...] The Crystal Reports ODBC database driver communicates with an ODBC driver, which in turn communicates with the actual database. The database vendors generally develop the ODBC drivers, which often come bundled with the database software.

Bibliography

External links

This article is issued from Wikipedia - version of the 11/21/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.