Overview

This course enables users to create more complex Crystal Reports. Report objects such as cross-tabs and sub-reports will be used, and techniques such as Data Dictionaries and direct SQL queries are examined. This course is designed for users with basic report skills, needing to create more complex reports that include sub-reports, cross-tabs, advanced formulas, and charts. Users may or may not have programming and / or database experience

Duration

2 Days

Target Audience

Attendance at a Crystal Reports Introduction session is required; knowledge of SQL / Query tools would be helpful, as well as some understanding of database principles.

Topics

Advanced Formatting (Conditional)

Advanced Formula Techniques

Multiple-Pass Reporting

SQL/ODBC & SQL Designer

Crystal Dictionaries

Parameter Fields

Multiple Sections

Sub reports

Using Cross Tab Reports

Advanced Cross Tabs

Graphing / Charting

A more comprehensive course outline is available in the Course Download section, to the right of this page.

MTC serves the whole of the North East region, including, Sunderland, Newcastle, Durham Teesside, Tyne and Wear, Cumbria, Northumberland, Darlington, North Yorkshire, Carlisle, Hartlepool. In addition MTC supports many clients nationally within the UK.