SWATuk

Return to pass home page | About pass | Request A Brochure | Contact Us | Sitemap   
     

Advanced Crystal Reports

Two Day Course

Course Description
The two day workshop is designed to increase report design skills focusing on advanced formulas, sub reports, multiple sections and Crystal Architecture.

Pre-requisites
A minimum of six months designing reports, or completion of the introductory course.

Topics Covered

  • Report Review
    • Advanced grouping
    • Advanced record selection
    • Linking in Crystal reports
    • Inserting and editing text
  • Sections
    • The selection expert
    • Working with multiple sections
    • New formatting options
  • Form Letters and Statements of Reports
    • Creating conditional message
    • Formatting form letters
    • Creating statement of account
  • Graphing
    • Graphing subtotals or summary
    • Graphing detail / formula data
    • Graphing cross-tab data
    • The PG editor
  • Conditional Reporting
    • Attribute vs. checkbox properties
    • Conditionally formatting objects
    • Conditionally formatting sections
  • Formulas
    • String formulas
    • Date formulas
    • Working with null values
    • Nested if-then-else formulas
    • Working with variables
    • Evaluation times in formulas
    • Running totals and conditional counts
    • Data / Time math
  • Sub Reports
    • Unlinked sub reports
    • Linked sub reports
    • Passing data values into sub report
  • Parameter Fields
    • Creating Parameter fields
    • Using multiple
  • Cross-Tab Objects
    • The value of cross-tab
    • Multiple summarised field cross-tab
    • Grouping and formulas in cross-tab
    • Formatting cross-tabs
  • Architecture / Database Connect
    • The components of Crystal reports
    • External Dynamic Link Library
    • Connecting to PC and SQL
    • Page-on-Demand architecture
    • Compiled reporting
    • Runtime file and locating requirements
    • Report distribution expert
  • SQL
    • How and when Crystal report SQL statement
    • Viewing and modifying SQL
  • The Query Designer
    • Using the query expert
    • Using SQL in Crystal query
  • Crystal Dictionaries
  • Creating Reports from Diction

This course is only available as Private Tailored Training On YOUR Premises

 

Pass Training, London. Computer training, Accountancy training, Auditing and taxation courses, personal Development, and Business Development training courses in London UK
SWAT UK Block 2, Angel Square, London, EC1V 1NY (UK)
Tel: 0845 330 2772 Fax: 0845 450 0545
 Email: info@pass.co.uk