Developer(s) | SAP SE |
---|---|
Operating system | Windows |
Available in | English, French, German, Japanese, Spanish, Simplified Chinese, Italian, Dutch, Russian, Korean, Traditional Chinese, Portuguese, Swedish, Polish, Danish, Norwegian, Finnish, Thai, Czech, Hungarian, Slovakian, Turkish, Romanian, Slovenian, Arabic, Hebrew, Ukrainian, Kazakh |
Type | Reporting software |
License | Trialware |
Website | www.crystalreports.com |
Crystal Reports is a business intelligence application, marketed to small and medium businesses[1] by SAP SE.
History[edit]
Terry Cunningham and the Cunningham Group originated the software in 1991.[2] Crystal Services Inc. marketed the product[3] (originally called 'Quik Reports') when they couldn't find a suitable commercial report writer for their accounting software.[citation needed] After producing versions 1.0 through 3.0, Crystal Services was acquired by Seagate Technology in 1994.[4] 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. The latest version released is Crystal Reports 2016 (version 14.2.x) on March 8, 2016.
The file extension for Crystal Reports' proprietary file format is .rpt. The design file can be saved without data, or with data for later viewing or sharing. Introduced with the release of Crystal Reports 2011 (version 14.0), the read-only .rptr file extension option allows for viewing, but cannot be modified once exported.[5]
When you upgrade to Crystal Reports 2011 or Crystal Reports 2008, consider the. Crystal Reports can run a report that is saved in an earlier version of Crystal. Answers which just contain links are considered bad practice.Please summarize the content here (don't copy/paste) so the answer can stand on its own. If you don't you run the risk of your answer being removed, especially if the link ever dies.
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 competing reporting tool, SQL Server Reporting Services (SSRS).[7][verification needed]
Versions and editions[edit]
Version | Release Date[8] | Ownership | Edition |
---|---|---|---|
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 | Business Objects | D,P,S |
XI R2 (11.5) | Nov 24, 2005 | Business Objects | D,P,S |
2008 (12) | Mar 31, 2008 | Business Objects | D |
2011 (14.0.x) | Aug 31, 2011 | SAP SE | D |
2013 (14.1.x) | Aug 29, 2013 | SAP SE | D |
2016 (14.2.x) | Mar 08, 2016 | SAP SE | D |
- A=Advanced Developer, D=Developer, P=Professional, S=Standard[9]
See also[edit]
References[edit]
- ^Crystal Reports small business marketing website
- ^'Meet the Team'. Indicee. Archived from the original on 2012-10-11. 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.
- ^'Crystal Reports links dBASE and Paradox data'. Data Based Advisor. Access my library. 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…
- ^'Seagate to acquire Crystal Services'. San Jose Mercury News. News bank. 1994-05-11. Retrieved 2009-04-14.
- ^'Crystal Reports family of offerings. Features by edition comparison chart'(PDF). SAP. 2019.
- ^Peck, George (2008). Crystal Reports 2008: The Complete Reference. McGraw-Hill Professional. p. 566. ISBN978-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…
- ^'Support for Crystal Reports for Visual Studio'. Support (knowledge base). Microsoft.
- ^Short history and resources for Crystal Reports Software Developer Kits (SDK)
- ^'Crystal Reports family of offerings. Features by edition comparison chart'(PDF). SAP. 2019.
Bibliography[edit]
- G. Taylor, Allen (June 3, 2008). Crystal Reports 2008 For Dummies (1st ed.). For Dummies. p. 396. ISBN0-470-29077-3.
- Peck, George (June 19, 2008). Crystal Reports 2008: The Complete Reference (1st ed.). McGraw-Hill Osborne Media. p. 968. ISBN0-07-159098-6.
- McCoy, Cate; Maric, Gord (2002). Mastering Crystal Reports 9 (1st ed.). Sybex. p. 639. ISBN0-7821-4173-0.
External links[edit]
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Crystal_Reports&oldid=926668809'
When you start Crystal Reports 10, generally you want to do one of three things: create a report, modify a report, or run a report against the data in your database. Reports take data from a database, process it, format it, and then output it to a printer, computer screen, or Web site.
Crystal Reports comes with a sample database you can use for practice. It’s a Microsoft Access database for a fictitious company named Xtreme Mountain Bikes Inc.
The xtreme.mdb database contains a number of database tables that are representative of the tables a real bike manufacturer might maintain. The tables are filled with sample data that you can manipulate and display with Crystal Reports. You can use this sample data as the basis for your first report.
To create a report, you need to know a few things:
- Which tables in the database contain the data you want
- Which data items you want in those tables
- What manipulations of the data must be performed to give you the information you want
- How you want your report to be formatted
- Whether the users of your report retrieve it from a black-and-white printer, a color printer, a local computer screen, or a Web site
For the purposes of this introduction (and for now), imagine you already know all those things.
Starting Crystal Reports 10
You’ve probably chosen Crystal Reports because you have a database that contains information that’s important to you. In all likelihood, the data in that database changes with time, and you want to be able to keep up with its current status. You could retrieve the information you want by making SQL queries, but that would be too much like work. It’s far better to create a report with Crystal Reports, and then run the report whenever you want the latest status of the information of interest. You have to create the report only once, but you can run it many times, getting the latest results with each successive run. You don’t have to learn SQL or any other method of pulling data out of databases. Reports created with Crystal Reports are easy to build, easy to read, and easy to understand. What could be better?
The first step to creating a report is to launch Crystal Reports from the Windows Start menu. When you do, the Crystal Reports main window appears, displaying the dialog box that welcomes you to Crystal Reports.
You are invited to choose from three options. You can create a Crystal Reports document using Report Wizard or by starting with a blank report. Alternatively, you can open a report that already exists, either to change it or to run it.
Although Report Wizard can be a time- and labor-saver, it does constrain the form of the report. So this chapter takes you right to the point and shows you how to create a report your way, starting from a blank report instead of using Report Wizard.
Using the Blank Report Option
To create a report from scratch, starting with the blank report option, follow these steps:
1. Start Crystal Reports.
The Welcome to Crystal Reports dialog box appears.
2. Select the As a Blank Report option, and then click the OK button.
The Database Expert dialog box appears, which shows possible places to find the source of your data.
3. In the Available Data Sources pane, click the plus sign to the left of the Create New Connection folder to expand it.
This is the folder you choose whenever you’re creating a report from scratch. When you have connected to a database, Crystal Reports remembers where it is.
4. Double-click the database type that matches your data source.
Crystal Reports recognizes a variety of different database types. You must select the right one. If you don’t know which type is correct, ask someone familiar with the data source. To follow along with the example, double-click Access/Excel (DAO). The Access/Excel (DAO) dialog box appears, which asks how to connect to your data source.
5. Click the ellipsis (…) button to the right of the Database Name box.
The Access and Excel files on your system appear. This example uses an Access database file named xtreme. This may not be as easy as it sounds — the file was located at D:Program FilesCrystal DecisionsCrystal Reports 10SamplesEnDatabasesxtreme.mdb.
You may have to browse to find this file on your system.
6. Click the Finish button.
Database Expert reappears, with the xtreme database connected.
7. Expand the Tables node, and then double-click the table on which you want to base your report.
The tree in the Available Data Sources pane consists of a number of nodes, some of which branch off from others. Every data source has four of these nodes branching off from it: Add Command, Tables, Views, and Stored Procedures.
8. To follow along with the example, expand the Tables node and then double-click Product.
Doing so copies the Product table from the Available Data Sources pane to the Selected Tables pane.
9. Click the OK button to close Database Expert.
A blank report fills the window.
The Design tab (on the left edge) shows five sections of the report:
- Report Header: Appears only at the top of the report and is the first thing that a viewer sees.
- Page Header: Appears below the report header and at the top of all the other pages in the report.
- Details: The actual content of the report.
- Report Footer section: Appears after the last detailed information in the report.
- Page Footer: Appears at the bottom of every page of the report.