Course outlines may be downloaded for many of the courses.

If you would like additional outlines please do not hesitate to contact us.

Crystal Reports - Adv This course is for all delegates wishing to learn the advanced skills of Crystal Reports. It can be delivered at all versions of Crystal Reports, including 9,10, XI and CR2008.   Review  Creating reports Formatting  Grouping Summarizing Selecting records Summary Drill Down  Linking   Formulas CrossTabs Advanced Formulas  Creating multiple statement formulas Using variables  Understanding two-pass reporting  Using evaluation time functions Creating running totals Adding User Functions Libraries (UFLs) Conditional Formatting Types of formatting  Absolute formatting Conditional on/off formatting Conditional attribute formatting Using the highlighting feature Multiple Sections Inserting sections Splitting Sections  Moving sections Deleting sections Multiple section formats (underlay following sections) Example uses (watermark, shading every other record, creating different header/footers, different form letters, suppress blank lines) Parameter Fields Creating parameter fields Using parameter fields in record selection formula Advanced CrossTabs  Multiple rows, columns and summarised fields Formatting CrossTabs  Using formulas, parameter fields in crosstabs  Simulated CrossTabs Subreports  What are subreports?  Linked subreports  Unlinked subreports On-demand subreports SQL/ODBC Query Designer What is the SQL/ODBC? What is the Query Designer? What is an ODBC data source? SQL statement components Creating queries Creating Data Sources Using Access files Graphing  Creating a graph on summary fields  Graphing on multiple summary values  Graphing on CrossTabs Editing and formatting graphs Dictionaries What are Dictionaries? Using dictionaries to create reports Creating dictionaries Reporting Crystal Web Report server installation Introduction to Web Reporting  Viewing Crystal Reports on the Web Crystal Reports - Adv