Objectives: After completing this course, you 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 colour; 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.
Prerequisites: Delegates must have a working knowledge of Windows applications and a basic knowledge of database concepts such as tables, fields and records |
|
