Crystal Reports 8.5: Advanced

This content has been designed for a one day classroom course. On course completion, students will be able to:

• Create and use parameter fields, use an Edit Mask, create a pick list to view data, and create and use subreports.
• Add, suppress, and delete report sections to arrange field objects; add hyperlinks and OLE objects to a report.
• Use variables, arrays, and ranges in a formula, create a formula by using multiple functions, use EvaluateAfter functions, and use for and while constructs.
• Use dictionaries to create views of relevant data. Use ODBC to access data from different types of databases, and use Crystal SQL Designer to create SQL queries.
• Create and customize charts and maps

Students will get the most out of this course if they want to learn about the advanced features of Crystal Reports 8.5, such as using parameter fields, subreports, section formatting, and advanced formulas. Students will also learn how to create reports by using dictionaries, ODBC, and SQL queries, and how to use charts and maps.

Target audience

Students should be familiar with PCs and the use of a keyboard and mouse. Students should also be have completed the Crystal Reports 8.5: Basic course or have equivalent practical experience.

Course content

Complex reports Parameter fields . Creating a parameter field . Applying an edit mask to a parameter field . Using a pick list in a parameter field . Subreports . Creating an unlinked subreport . Creating a linked subreport

Formatting complex reports The Section Expert . Adding new sections . Suppressing a blank section . Deleting a section . Displaying each record on a separate page . Objects . Adding a hyperlink . Adding a linked OLE object

Advanced formulas and functions Variables . Declaring and using a variable in a formula . Using an array variable in a formula . Using a range variable in a formula . Advanced functions . Creating a formula by using multiple functions . Using the EvaluateAfter function . Constructs . Using a For construct . Using a While construct

Advanced data access techniques Dictionaries . Creating a dictionary . Using a dictionary to create a report . ODBC data sources . Discussing ODBC data sources . Creating a report by using an ODBC data source . Crystal SQL Designer . Using SQL syntax to retrieve report data . Using the SQL Expert to create an SQL statement . Creating a report based on a query . Report Alerts . Creating a Report Alert . Modifying a Report Alert . Deleting a Report Alert

Charts and maps Charts . Creating a chart . Modifying a chart . Maps . Using the Map Expert to create a map . Customizing a map

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