I would like to register or request more information

Crystal Reports for FM:Systems

Course Description

Course Length = 2 days

The class is designed to teach both basic as well as some advanced features of Crystal Reports while using typical FM:Systems CAFM data to generate reports for Facilities. It is tailored for the FM:Systems customers who want to take their reports to the next level.

Some example reports include:

  • Financial Allocations
  • True Vacancies
  • Space Utilization
  • Move Statistics
  • Real Estate Area Calculations
  • Alternate Roll-Up Hierarchies
  • Population Breakout
  • Move Lists

The Software

FM:Systems software is a powerful CAFM software suite used to manage facilities and share information throughout the organization. Crystal Reports is an advanced reporting application that allows you to query and display information to create eye-opening reports. Together, these applications work great together to collect, calculate, and display stunning dynamic reports about your CAFM data.

Course Outline

Best Practices

  • Templates
  • Header & Footers

Design Environment

  • Preferences
  • Objects
  • Size & Alignment
  • Suppressing
  • Hyperlinks


  • Basic & Advanced
  • Join Types

Record Selection

  • Details
  • Operators & AND/OR
  • Remarks


  • Groups & Labels
  • Suppressing & Drill-Down

SQL Statements

  • Overview
  • When to use

Formula Fields

  • Math & Logic
  • Categories

Running Totals

  • Types
  • Grouping
  • Conditional


  • Types
  • Linking & Formatting



Course Cost

This 2-day course is $745 per person.

Course Dates

There are no dates scheduled for this course at this time. Please Contact Us to request a new course date or view our full course schedule for similar courses.


Note: The suggested course duration is a guideline. Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

AMS CAD + CAFM Solutions Training & Development Center 271 Route 46 West, Bldg. A-105 Fairfield, NJ 07004 T (973) 882-8008 F (973) 882-0122