Crystal Reports XI Advanced

This 2-day course teaches the basic features and functions of Crystal Reports XI. Students will explore the program environment and learn how to open, navigate, create, modify, and save reports. They will learn the fundamentals of formatting report objects, of sorting and selecting records, and creating groups and summaries. They will also learn how to create simple formulas and functions. Finally, students will work with experts and wizards, and learn how to export reports to various file formats . After completing this one-day course, students will know how to:

• Explore the Crystal Reports window; open, create, save, and modify simple reports; and use Help.
• Format a report by changing font style, size, and color; add lines, boxes, and shapes; and format fields conditionally.
• Sort records in ascending and descending order; select records based on single or multiple criteria, and delete criteria from a selection formula.
• Learn to create groups and subgroups, delete groups, group data by a date field, display groups in a specified order, create a subgroup, set group options, insert subtotals and grand totals, and display the top number of groups of records.
• Create, modify, and delete formulas; insert date functions; concatenate fields; and use string and mathematical functions.
• Use the Database Expert and Report wizards, and create, modify, and format cross-tab reports.
• Export reports to different formats such as Excel, Access, HTML, and XML; create a report definition; and print and e-mail reports

Target audience

Students taking this course should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that students have completed the Crystal Reports XI Basic course or have equivalent experience.

Course content

Selecting data Parameter fields • Defining report elements

Advanced formulas and functions Running totals • Variables • Advanced functions • Constructs

Charts and maps Working with charts • Creating maps

Formatting complex reports The Section Expert • Advanced conditional formatting • Objects

Alerts and subreports Report alerts • Subreports

Data management features The Business Objects Enterprise Repository • The Workbench

Advanced data access techniques ODBC data sources • SQL and the Database Expert

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today