Details Price Qty
Crystal Beyondshow details + $350.00 (USD)  

  • June 22, 2021
    1:00 pm - 5:00 pm

System Requirements: Workstation MUST have Crystal Reports installed. A MS Access Database will be provided prior to the start of class.

This 4-hour course is designed for participants who have a basic understanding of Crystal Reports and can design a basic report from scratch, make edits to an existing report, and work with basic formatting. A Microsoft Access Database is used during the course. The database has similar tables to both Sage 100 Contractor and 300 CRE databases. This allows both Sage 100 Contractor & 300 CRE clients to take the class.

Click to download agenda

Agenda

  • 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

Venue:  

Description:

This is an online class. You will receive a separate email with instructions on how to access the course 1-2 business days prior to the date of the class. You will need an internet connection and phone access to take this course.