4.50 (485 reviews)
$695
Enhance your basic report writing skills
and move you into creating more complex reports
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
Create automatic and manual running totals
Work with cross-tab reports.
Add subreports.
Create drill-downs in a report.
Use SQL statements in report processing.
Create complex formulas.
Add charts to reports. Enhance report functionality.
Course Overview
Audience:
The course would suit people who have completed Crystal Reports Basic and wish to further their report writing skills.
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. In order to successfully complete this course, you should feel comfortable creating basic reports from scratch and using wizards; attaching a database, inserting text, and special fields; format objects; sort, group, and total data; and write basic formulas to calculate information.
Inclusions
Training Manual with step by step instructions
Practice files with relevant to the training material
Training Completed files you are free to take away any completed files for review
Unlimited online support as training does not stop when you walk out our door
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
Delivery Options
Public Courses
Live online - learn by doing.
Our Live Online courses are conducted through a dedicated learning platform that enables us to provide instructor-led, hands-on training to develop real skills, in real time. Each participant logs into their own virtual environment setup specifically for the course. This is a fully interactive experience - just like in a classroom. No passive lectures. No videos to follow - real time hands-on practice with your instructor guiding you every step.
Instructor:
- provides real-time live hands-on instruction and demonstration,
- provides step-by-step practical activities for participants,
- can assist participants on their screen, if necessary,
- can share participant screens to enhance discussion.
Participants:
- receive hands-on instruction, step-by-step exercises and skill-builder activities,
- see the instructor screen while working on their own environment,
- can interact with the instructor and the group of participants,
- can ask questions at any time,
- join the course from any location with internet using a Course Invitation.
- no need for any software, just a computer with internet and a browser.
- no downloads on installs necessary on the participant computer.
Inclusions:
- E-Book Training Manual/activity booklet will be provided
- Certificate of Completion
- Post-course support to the level of the course
- Access to any training exercises used during the session
Session Times:
- Full Day Course: 9:00 am-4:30 pm
- Half Day Course: 9:00 am-12:30 pm or 1:30 pm-5:00 pm
Private Courses
Private sessions can be arranged through our Live Online platform for group training. Group training content and duration can also be tailored to your needs. To discuss your training requirements, contact our Course Scheduling team.
Classroom
Classroom sessions are delivered at a nominated location (Private courses only).
Requirements:
If training is being delivered on your site:
- A computer is required for each participant, configured with appropriate software (if necessary).
- If participants are using laptops, ensure power cords are provided for use during the session.
- The instructor will bring their own laptop - please provide power
- Screen/Projector for trainer to connect their laptop to. Please indicate the connection method - hdmi or wifi.
Inclusions:
- Training Manual/activity booklet
- Certificate of Completion
- Post-course support for queries relating to the course content.
Available Crystal Reports Avanced courses
| Event | Event Date | Location | Individual Price | Register |
|---|---|---|---|---|
| Crystal Reports Advanced | 29-04-2026 | Live Online | $695.00 |
Brochure