- June 29-30, 2021
June 29, 2021 - June 30, 2021
9:00 am - 4:00 pm
- November 4-5, 2021
November 4, 2021 - November 5, 2021
9:00 am - 4:00 pm
About this Course
This two-day course covers the more complex and powerful features of Crystal Reports. The course focuses on the student’s ability to perform tasks using the most productive techniques allowing you to pull data from all times of data sources. The course discusses very technical issues and includes several fast-paced, comprehensive exercises.
Experienced administrators, developers and end-users who are experienced with Crystal Reports.
At Course Completion
1. Refresher Exercise Review of Planning a Report Creating a 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 2. Power FormattingUsing Multiple Sections in Reports Using the Section Expert to Work with Sections Exercises 3. Using the Running Totals Feature Understanding Running Totals Creating Running Totals for a List of Numbers Conditional Running Totals 4. Prompting with Parameters Parameter Fields Overview Parameter Field Considerations Creating a Parameter Field Using a Parameter to Select Records Using a Parameter Field Using the Parameter Panel Creating a Dynamic Value List 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 String Parameters Sorting with a Parameter Group Sorting with a Parameter Using a Parameter to set N in a Top N or Bottom N report Displaying Parameter Fields Cascading Parameter Fields5. Using Advanced Formula Features Understanding How Crystal Reports Processes the Data What is a Pass? Using Evaluation Time Functions Working with Variables Declaring a Variable Variable Scope Separating Statements in Complex Formulas Working with Arrays Understanding the Formula Evaluation Time Debugger 6. Using Subreporting as a Workaround Solution Understanding Subreports Unlinked versus Linked Subreports Creating an Unlinked Subreport Linking a Subreport Database Links versus Subreports in One-to Many Situations Formatting the Subreport Passing Data from the main Report into a Subreport Creating on-demand Subreports Creating Hyperlinks Using Subreports to Link “Unlinkable” Data 7. Creating Powerful Groups Creating Custom Groups Customizing Group Sort Order Using Group Selection to Filter the Records in the Report Grouping on a Formula Field Grouping Hierarchically 8. Working with Cross-Tab Reports Understanding How Cross-Tabs Affect Your Data Creating a Cross-Tab Report Crating a Cross-Tab with Multiple Rows or Columns Applying a Formatting Style to the Cross-Tab Customizing the Cross-Tab Format Changing the Summary Operation Charting Cross Tabs Customizing Cross-Tab Group Names CurrentFieldValue 9. Report Alerts What are Report Alerts? Creating Report Alerts Basing Report Formulas or Conditional Formatting on Report Alerts Creative Usage for Report Alerts Appendix A – Report 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 Appendix B: The Northwind 2008 Database Appendix C: Installation and System Requirements Installing the Application Minimum Installation RequirementsAppendix D: Setup Instructions for Crystal Reports 2013 Crystal Reports 2013 Application Installation Instructions Installing Required Class Files Appendix E: Function and Operation Locations
A comfort level of understanding in regards to relational databases.
Venue: LIVE Online
Live Online Training
Get the same training you expect in the classroom without leaving your office or home. These are NOT recorded classes. They are LIVE sessions with an expert instructor. We use the latest in video conferencing technologies and audio so you can confidently participate in any class just like being right there in person. We guarantee the effectiveness of our online training delivery approach that we will give you your money back if you are not totally satisfied. Ask us for a demo.
Online class requirements:
- Moderate to fast Internet
- Phone or computer headset is required in order to hear the instructor/moderator). You can use Computer Audio (VoIP) or you can dial-in from a regular phone. For convenience, we recommend a hands-free headset or phone.
- Training software must be installed on your computer (trial versions are acceptable)
- RECOMMENDED: Dual Monitors or computers. For optimal online learning experience, we recommend participants have dual monitors or two computers. Your online classroom credentials allow you to join multiple times from multiple computers. Participants should use one monitor or computer to view the instructor’s shared screen and another monitor or computer to work with the software.
What happens when you enroll in an online class
When you register for an online class, you will receive a welcome email followed by login access to the Citrix GoToTraining virtual classroom. A workbook (printed copy or eBook) will be sent to you prior to the start of class.
Online Training Advantages
Convenience: You don’t have to travel and can attend from your home, office or anywhere with an internet connection. Our online classes are conducted using GoToTraining, a more robust version of the popular GoToMeeting screen sharing and conferencing platform. To accommodate multiple time zones, courses are typically scheduled from 10am – 5pm Eastern with a one-hour lunch break at 12:30 – 1:30 pm Eastern and a 10-minute break in the morning and afternoon. When conducting custom online course for your group, class times can be modified to accommodate your timezone.
Interactive Learning: Our online training is fully interactive. You can speak and chat with the instructor and classmates at any time. Various interactive techniques are used in every class. Our small class sizes (typically 4 – 8 students), allow our instructors to focus on individual performance and issues and to work closely with you to meet your unique needs. Classes are designed to be a hands-on learning experience, providing opportunities for you to try your new skills while the instructor is available for review, questions, and feedback. You have the option to give the instructor permission to view your computer to provide one-on-one assistance when needed.