AUDIENCE:   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. PREREQUISITES:   Delegates should have attended the Crystal Reports Basic Skills course. DURATION:   2 days. Hands on. OBJECTIVES:   On completion of the course delegates will be able to: - Use Advanced Formulas. - Understand Cross-tab Reports. - Work with Parameter Fields. - Create Subreports. - The Crystal Repository. - Use Crystal SQL Designer and SQL/ODBC using Crystal Query Designer. - Create, use and change dictionaries using Crystal Dictionaries. - Geographical Mapping COURSE CONTENT:   Review Exercise Creating a basic report Adding and linking databases Selecting, grouping and summarizing Creating formulas Formatting sections for Summary/Drill-Down Advanced Formulas Use variables in formulas Understand multiple pass reporting Use evaluation time functions Create formulas using multiple variables Parameter Fields Define parameter fields Create parameter fields Create a pick list parameter field Use parameter fields in the record selection formula Use edit masks Use parameter fields to specify the sort criteria Use the Like statement Use parameter fields to set conditional formats Cross-Tabs Understanding cross-tab reports Use the Cross-Tab Expert Edit your cross-tab report Modify cross-tab layout options Format your cross-tab report Insert multiple rows, columns and summarised fields Format cross-tab components Use formula fields in cross-tab layouts Use parameter fields with cross-tab reports Insert a cross-tab for each group value Subreports Identify when subreports are needed Insert unlinked subreports Format subreports Insert linked subreports Create on-demand subreports SQL/ODBC and Crystal SQL Designer (version 8x only) Defining SQL Defining ODBC Use Crystal Query Designer Using a query to create a report Crystal Dictionaries (version 8x only) Define a dictionary Use existing dictionaries Create dictionaries Enhance dictionaries Modify a dictionary Geographical Mapping Discuss map types and layout options Use the Map Expert Format existing maps Advanced Conditional Formatting Advanced section formatting and suppressing Advanced field formatting and suppressing The Crystal Repository (versions 9 onwards) Accessing the Crystal Repository Adding objects to the Repository Modifying a Repository Object Updating Repository Objects in reports Running Totals Using Running Totals Editing Running Totals Using the Evaluate and Reset options Advanced Grouping Creating Top N Reports Specified Order Grouping All third-party brands and trademarks belong to their respective owners. MW07/01