Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. Several other applications, such as Microsoft Visual Studio, bundle an OEM version of Crystal Reports as a general purpose reporting tool. Crystal Reports became the de facto standard report writer when Microsoft released it with Visual Studio.
Crystal Reports allows users to graphically design data connections 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, Business Objects Enterprise business views, and local file system information. Fields from these tables can be placed on the report design surface, and can also be used 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 formulae have a wide array of formatting options available, which can be applied 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.
Supported data sources
Crystal Reports allowAccessible data sources include the following:
- Databases such as PostgreSQL, Sybase, IBM DB2, Ingres, Microsoft Access, Microsoft SQL Server, MySQL, Interbase and Oracle
- Spreadsheets such as Microsoft Excel
- Text files
- HTML XML files
- Groupware applications as Lotus Notes, Microsoft Exchange and Novell GroupWise
- SAP: BW, Info Sets, Tables, and Business Objects Universes
- Any other data source accessible through a web service, ODBC, JDBC or OLAP.
Crystal Reports comes integrated with Visual Studio. Crystal Reports allows Java developers to build applications with Crystal Reports components.
View Other Database and Business Intelligence Skill Sets:
- Business Objects
- Crystal Reports
- Database Administration
- Data Modeling
- Data Warehousing
NEED TALENT?Fill out form below and we will get started...
* denotes required field