Support

Crystal Reports 11 Advanced Course

2 sessions available starting from $1,055.00

Subject: Computer Training

Ages: All ages

Skill level: All difficulty levels

This two-day course has been designed to build on the topics presented in the Crystal Reports - Basic course. The course will enhance basic skills and enable creation of more complex reports.

Duration:

2 Days

Audience:

The course would suit people who have completed Crystal Reports Basic and wish to further their report writing skills. The content would suit those using Crystal Reports V8 and above.

Prerequisites:

To successfully understand all the content and complete activities, students must be proficient in Microsoft Windows and have knowledge of basic databases as well as a solid understanding of all concepts taught in the Basic course.

Course Content:

Report Creating Review

• Reviewing Report Creation
• Group Options and Sections

Complex Reports

• Building...

see more

This two-day course has been designed to build on the topics presented in the Crystal Reports - Basic course. The course will enhance basic skills and enable creation of more complex reports.

Duration:

2 Days

Audience:

The course would suit people who have completed Crystal Reports Basic and wish to further their report writing skills. The content would suit those using Crystal Reports V8 and above.

Prerequisites:

To successfully understand all the content and complete activities, students must be proficient in Microsoft Windows and have knowledge of basic databases as well as a solid understanding of all concepts taught in the Basic course.

Course Content:

Report Creating Review

• Reviewing Report Creation
• Group Options and Sections

Complex Reports

• Building reports using parameter Fields
• Defining a parameter
• Using parameter fields
• Edit masks
• Pick lists in a parameter field

Formatting Complex Reports

• Using the Section Expert
• Adding new sections
• Modifying sections
• Suppressing a blank section
• Merging sections
• Deleting sections
• Displaying records on separate pages
• Adding Hyperlinks
• OLE objects

Subreports

• Creating an unlinked subreport
• Linked subreports

Advanced Formulas and Functions

• Using Variables in formulas
• Declaring variables
• Understanding Variable scope
• Using Arrays
• Array variables in a formula
• Range Variables
• Advanced Functions
• Using Nested functions
• Constructs
• For construct
• While construct
• Adding Running Totals

Advanced Data Access Techniques and Alerts

• Introduction to ODBC Data Sources
• Using ODBC data sources to create reports
• SQL and Database Expert
• Defining an SQL Query
• Understanding SQL syntax
• Command objects
• Adding a command to repository
• Using queries
• Report Alerts
• Creating and modifying report alerts

Charting

• Creating Charts in Crystal
• Working with and modifying Charts

Advanced Formulas and Functions

• Using Variables in formulas
• Declaring variables
• Understanding Variable scope
• Using Arrays
• Array variables in a formula
• Range Variables
• Advanced Functions
• Using Nested functions
• Constructs
• For construct
• While construct
• Adding Running Totals

Advanced Data Access Techniques and Alerts

• Introduction to ODBC Data Sources
• Using ODBC data sources to create reports
• SQL and Database Expert
• Defining an SQL Query
• Understanding SQL syntax
• Command objects
• Adding a command to repository
• Using queries
• Report Alerts
• Creating and modifying report alerts

see less

Choose from 2 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,055.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,055.00

Type

  • Class / Group Sessions



My Other Listings

Access 2003 Course - Intermediate
Access 2003 Course - Intermediate
1 session available for $700.00
Excel 2003 Course - Intermediate
Excel 2003 Course - Intermediate
6 sessions available starting from $700.00
MYOB Course | End of Period Reconciliation
MYOB Course | End of Period Reconciliation
1 session available for $350.00

see all listings »


Found In