Crystal Reports Intermediate Training

In this Crystal Reports Intermediate Training Course, students will build on their existing knowledge of Crystal Reports to create more complex reports for specific business scenarios. Students will learn how to use Running Totals in a Crystal Report, which allow a user to summarize only specific data in a report (unlike Subtotals and Grand Totals, which don't provide as much control over which data is included in an aggregation.) As students progress through the course, they will also see how to create more advanced formulas that use loops to iterate over data and arrays to hold values for use in other places in the report. Another key takeaway for students in this course is how to use Subreports in situations where data from multiple, potentially unrelated, tables needs to be brought together in one report. The course continues with a lesson on how to use SQL statements directly in Crystal Reports as well as how to use Table Joins, Subqueries and SQL Expression fields. Students will also see the power and flexibility of Cross-Tab reports and Cross-Tab charts in Crystal and how they can be used to summarize data quickly and efficiently. Lastly, students will see some additional features to enhance reports, like adding dynamic images and creating reports that use geographic maps to display data.