HEAT Crystal Reports

Course Description: Starting with the very first screens encountered when loading and launching Crystal Reports, a foundation is built to help understand all the key tools and concepts available in this program including basic report design against a HEAT database. Learn how data being retrieved from a HEAT database can be managed to better understand what it means.

Student Profile and Prerequisites: This course is designed for HEAT System Administrators / users who are currently using the product and will be responsible for designing and maintaining their HEAT System with working knowledge of help desk procedures and process flow. They should have user knowledge of Microsoft Windows® operating system.

HEAT Crystal Reports Training Topics

• Foundation Principles - Know the HEAT database, ten tips for better reports, initial settings, the report gallery, connecting to a HEAT database, purpose of the design tab bands, inserting fields onto reprots, print preview tab, formatting fields, the formula editor, stringing fields together, duration calculations, stopwatch and activity log's duration field, if-then-else formulas...simple to complex, extracting portions of a field, preparing HEAT time fields to enable a crystal time formatter, using more than one table, visual linking expert, SQL join types 

• Design and Data Retrieval - Simple sort, group by group...no counting, change group expert, group by summary...counting, counting records, counting records not on the report, calculating percentages by referencing structure, counting issues per duration, grouping on forumulas and crystal dates, mixing groups and formulas to invoice, structuring two reports inside one, time spent on unsaved activities, counting abandoned tickets, hiding blank lines for empty fields, shading alternate bands, multiple counting reports

• Special Features and Design Tips and Tricks - Select expert, selecting only records with blank fields, record selection requiring a group, length of time on a selected call status, the fancy select expert: parameters, providing default values to a parameter, adding parameters to titles and subtitles, pull tickets resolved...but not closed, creating charts and graphs, fine tuning or changing a chart, creating a cross-tab report, using formulas in a cross-tab, day-specific order in cross-tab, creating labels for a mass mailing, visualizing data on a map, troubleshooting

HEAT Crystal Training Schedule

Classes: July 21 - 22, 2008 (Milwaukee, Wisconsin)

Cost: $1495  

Register online or call Sherri toll-free at 866.842.6649.