Course Outline
• Get Started with Crystal Reports
• Obtain Crystal Reports
• Configure the ODBC connection
• Connect to your Sage 300 CRE database
• Plan & Design a Report
• Create a report from scratch
• Set Crystal Reports options
• Use the Database Expert
• Add fields, formatting and graphical elements to the report
• Setting Criteria & Data Relationships
• Use the Select Expert
• Set criteria on the report
• Link tables
• Set join types
• Sorting, Grouping & Summaries
• Sort data on the report
• Group report information
• Add group totals and grand totals
• Introduction To formulas
• Introduction to the Formula Workshop
• Sneak Peak at building formulas in Preparation for the Beyond the Basics course
• Formatting Fields
• Suppress zero values
• Format fields conditionally (according to their value)
• Discuss section formatting