Course Outline
• Quick Review of the Basics
• Configure the ODBC connection
• Connect to your Sage 300 CRE database
• Criteria, Grouping
• Data Relationships (Linking)
• Link Tables
• Set join types correctly
• Understanding how Joins effect what data is returned
• Parameters, Charts & Graphs
• Add a parameter to a report
• Control the display of data based on a parameter’s value
• Add a graph to a report
• Working with Formulas
• Create a formula using correct syntax
• Understand order of precedence and syntax rules
• Check formulas for errors
• Copy and delete formulas
• Functions & Special Characters
• Add functions to formulas
• Understand data type issues
• Use functions to convert data types
• Formatting Fields & Sections
• Format fields conditionally
• Change section formatting
• Format sections conditionally
• Suppress records conditionally
• Cross Tabs
• Creating Cross tab reports
• Summarizing the detail into meaningful summaries