Crystal Reports XI Designer 2 Workshop
Request a Class
9:00am - 4:30pm
This two-day workshop is designed to enhance your basic report writing skills 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 professional design, techniques, subreporting and advanced formulas. This course incorporates a number of hands on exercises that reinforce the learning process.
AUDIENCE AND PREREQUISITES
Designed for the experienced Crystal Reports user, this course covers the more complex and powerful features of the program. The class discusses very technical issues and includes several fast-paced, comprehensive exercises. Our instructors have years of experience helping students to get the most out of their training; however, it is not always possible in a high level workshop to assist students with basic tasks.
In order to maximize the benefit you receive from the Crystal Reports Designer 2 Workshop, you should come into the training with a certain skill level. We assume all students who sign up for this workshop have a comfortable level of understanding in regards to relational databases.
Students should also be able to perform the following tasks in Crystal Reports:
- Create a new report, insert fields, save the report, and refresh the data.
- Add multiple tables to the report using the Data Explorer.
- Use the select expert to pull only the data needed from the database.
- Insert groups and summarize fields within the group.
- Perform formatting tasks.
- Create, save, and use formulas in the report.
Successful completion of either the Designer 1 Workshop or the Pre-qualification Exercise is strongly recommended. Please contact VTEC at 207-775-0244 for more information.
PREREQUISITE COURSESFOLLOW UP COURSES
*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.
Refresher Exercise Review of Planning a Report Creating the Report Placing Fields on the Report Creating the Formulas Advanced Grouping Selecting Certain Records Helpful Hints for Formatting the Report Adding and Working with Text Objects Hiding and Suppressing Sections GuidelinesPower Formatting with Multiple Sections Using Multiple Sections in Reports Using the Section Expert to Work with Sections Conditionally Formatting Multiple Sections Advanced Drill Down Group LevelUsing the Running Totals Feature Understanding Running Totals Creating Running Totals for a List of Numbers Conditional Running TotalsPrompting with Parameters Parameter Field Considerations Creating a Parameter Field Using a Parameter to Select Records Using a Parameter Field Creating a Dynamic Value List for Parameter Values Importing a Pick List Adding Parameter Values to Text Objects Allowing Multiple Values in Parameters Using Multiple Parameter Fields in Reports Specifying and Limiting a Range for a Parameter Using Parameters in Conditional Formatting Using an Edit Mask to Limit StringUsing Advanced Formula Features Understanding How Crystal Reports Processes the Data What Is a Pass? Using Evaluation Time Functions Working with Variables Declaring a Variable Assigning a Value to a Variable Using a Variable in a Formula Variable Scope Separating Statements in Complex Formulas Working with ArraysUsing Sub reporting as a Workaround Solution Understanding Sub reports Unlinked versus Linked Subreports Creating an Unlinked Sub report Linking a Subreport Database Links versus Subreports in One-to-Many Situations Creating On-Demand Subreports Creating Hyperlinks Using Subreports to Link "Unlinkable" DataCreating Powerful Groups Using the Group Expert Using a Field Name to Customize the Group Name Using a Formula to Customize the Group Name Field Creating Custom Groups Grouping on a Formula Field Using Group Selection to Filter the Records in the Report Grouping Hierarchically Create Customized Grouping Brain Teaser - Using Group SelectionWorking with Cross-Tab Reports Understanding How Cross-Tabs Affect Your Data Creating a Cross-Tab Report Creating a Cross- Tab with Multiple Rows or Columns Applying a Formatting Style to the Cross-Tab Customizing the Cross-Tab Format Changing Background Colors Formatting Individual Cells Changing the Summary Operation Suppressing Rows, Columns or Totals Repeating Row Heading for Multi-Page Cross-Tabs Using Alias Names for Column and Row Headings Charting Cross-TabsReport Alerts What are Report Alerts Creating Report AlertsReport Templates What is a Report template Standard Report Creation Wizard and Templates The Template Expert Applying a Template and the consequences Template Considerations Creating Your Own Templates Inserting Template Fields Formatting Template Fields Giving Template Fields a Value