Crystal Reports versions 8.5, 9.0, 10 and XI Level 2
Course Description
Crystal Reports Trainig Course Level 2 is an instructor led course designed for people who know how to create basic list and group reports, and need to create reports that include sub-reports, cross-tabs, advanced formulae and charts based on multiple data series.
Note: Although this is a 2 day course, highly motivated students can complete this course in 1 day. Please call to discuss experience
Upon successful completion of this course, students will be able to:- Create running totals in a report
- Build cross-tab reports
- Add subreports to a report
- Design a report that uses a drill-down
- Improve report processing speed
- Chart single and multiple data series
- Report from excel data
Duration: 2 days
Creating running totals
Create a running total field Modify a running total field Create a manual running total on detail data Create a manual running total on summary dataBuilding Cross-Tabs
Create a cross-tabCreate a specified sort order
Filter a cross-tab by group
Change the cross-tab format
Conditionally format rows and columns
Keep groups together
Adding sub-reports
Insert a sub-reportLink a sub-report to the primary report
Edit a sub-report
Format a sub-report using the format editor
Share formulae between main & sub-reports
Create an on-demand sub-report
Creating drill-downs
Create a drill-downCreate separate headings for drill-downs
Using SQL with Crystal Reports
Create a report using SQL queriesSummarize report data using SQL aggregate functions
Create joins using SQL
Create sub-queries
Create a SQL expression field to promote server-side processing
Charting data
Create a bar chartModify a chart
Create a top N chart
Format a chart
Create a chart template
Reporting on Excel data
Create a report based on Excel dataModify a report generated from Excel data
Update data in a report based on Excel data