Crystal Reports is a report generation program that allows a user to create reports from a variety of data sources. It can access data from Microsoft Excel spreadsheets, Oracle databases, Microsoft SQL Server databases, Microsoft Access databases, and many other programs.
Report designers can place fields from these sources on the design surface, and can also use custom formulas to calculate information based on those fields. A wide array of formatting options is available. If necessary, these can be applied only to certain records by using conditional rules.
Our Introduction to Crystal Reports training course show attendees how to connect to the correct data source using the program’s Database Expert. Reports can then be built, positioning, aligning and formatting fields as required. The ability to Sort and Group records is explained, alongside the creation of Group Totals.
In the Advanced Crystal Reports course, Parameter Fields are explained. These allow the person running the report to decide, on-the-fly, which records to include. By making use of the different Sections available, standard letters can created for a mail-merge. Sub-Reports, Report Alerts and Running Totals are other advanced features which are investigated.