Find Courses Find Providers Providers - Promote Your Courses About Us

Crystal Reports V9-V10 Advanced

Training Courses

Would you like to see more Databases courses?

Training course summary

Sponsored links

Objectives: After completing this course, you will know how to: Create and use parameter fields to accept user input; create and use edit masks and pick lists for parameter fields; and create and use subreports. Arrange field objects by adding, merging, and deleting report sections; and add hyperlinks and OLE objects. Use variables, arrays, and ranges in formulas; create formulas that use multiple functions; use Evaluation Time functions to determine when a formula is evaluated; and use For and While constructs to control the execution of statements in a formula; and create and modify running totals. Use dictionaries to create and modify views of relevant data; use ODBC to access data from different types of databases; use Crystal SQL Designer to create SQL queries; and create, modify, and delete Report Alerts. Create and customize charts and maps to display report data graphically and geographically. Prerequisites: Delegates should have attended Crystal Reports V9-V10 Introduction or have the equivalent knowledge.

Regions:
  • All Areas
Delivery:
  • In House
  • Public
  • Computer Based
Category:
Difficulty:
  • Advanced

Further Details

Course Content: Creating Running Totals Creating a Running Total Field. Editing the Running Total Field. Creating a Manual Running Total on Detail Data. Creating a Manual Running Total on Summary Data. Building CrossTabs in your Report Create a CrossTab. Create a specified group order. Filter CrossTab by group. Change the CrossTab format. Adding Subreports Insert and Edit a Subreport. Link a Subreport in a primary report. Format a Subreport object. Share formula between Main and Subreports. Create and on-demand Subreport. Improving Report Processing Speed Create an SQL Expression. Select Records on the Server. Write and Edit an SQL query. Build a Report on your SQL query. Create SQL commands in the Crystal Report Environment Building Dictionaries Create a Dictionary. Organise the view of data in a Dictionary Adding Graphics to a Dictionary Building a Report based on a Dictionary Charting Data Create and Modify a Chart Create a Top N Chart Format a Chart Create a Chart Template Reporting on Excel Data Create, Modify and Update a Report

Guide price

£750 per person (public course)

 

Sponsored links

Interested in this course?

 

 

Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net