Crystal Reports 2016 Designer 3
9:00am - 4:30pm
This two-day workshop is designed to expand your working knowledge of Crystal
Reports and move you into creating more complex reports. Time will be spent
walking you through the tips and tricks of advanced report writing along with a good
amount of hands on practice. In addition, you will cover custom functions, advanced
formulas and report efficiencies techniques. This course incorporates a number of
hands on exercises that reinforce the learning process.
AUDIENCE AND PREREQUISITES
This course is designed for people who know how to create basic list and group reports and need to create reports that include advanced formulas, and reports that may be based on more complex SQL statements. Students attending this course may or may not have programming and/or SQL experience.
Successful completion of the Designer 1 and 2 Workshops is strongly recommended.
*Course Cost listed does not include the cost of the courseware. Course is subject to a minimum enrollment to run. Course may run as a Virtual Instructor led class if the minimum enrollment is not met. For more information, please contact: firstname.lastname@example.org or call 207-775-0244.
Module 1: Refresher Exercise Review of Planning a Report Creating the Report Placing Fields on the Report Advanced Grouping Selecting Certain Records Group Sorting Group ChartingModule 2: Advanced Database Concepts What is SQL? Native Database Driver ODBC, OLE DB, ODBC, OLE DB or Native Using the Database Expert for Linking Adding a table Multiple Times Changing Join Types Database Changes Database Verification Set Data Source Location Re-mapping Database Fields Views, Stored Procedures, SQL Commands, Creating an SQL CommandModule 3: Using the Advanced Formula Features Select Case Statement For Loop Control Structure While... Do Loops Do... While Loops Building Arrays The Split Function Array Sizing LimitationsModule 4: Custom Functions What is a Custom Function Function Arguments When to use a Custom Function Using the Custom Function Editor Using Crystal Syntax Using Basic Syntax Custom Function Properties Using the Formula Expert and Custom Functions Using the Formula Extractor Custom Function LimitationsModule 5: Running Reports Efficiently Understanding What Crystal Sends to the Database Strategies for Efficient Report Performance Using the SQL Statement Record Selection and Performance Performance Information Report Definition Saved Data Processing Latest Report Changes Performance Timing Server Based Grouping Select Distinct CommandModule 6: Advanced Cross-Tab Design Dissecting a Cross-Tab Grid Cross-Tab Parts Listing Row and Column Indexes Summary Indexes Grid Value Functions Embedded Summaries Conditionally Formatting Embedded Summaries Calculated MembersModule 7: Tips and Tricks