Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you're ready to move ahead to create complex reports and data sources using Crystal Reports' tools. In this course, you'll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you'll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.
This course is designed for delegates who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to make it easier for other people to create reports. They may or may not have programming and/or SQL experience.
Crystal Reports Foundation and knowledge of programming and/or SQL would be helpful.
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 data
Create a cross-tab • Create a specified group order • Filter a cross-tab by group • Change cross-tab by group • Change the cross-tab format • Conditionally format rows and columns • Keep groups together
Insert a subreport • Link a subreport to data in a primary report • Edit a subreport • Format a subreport using the format editor • Share formulas between main and subreports • Create an on-demand report
Create a drill-down • Create a separate heading for drill-down data
Create a report using SQL queries • Summarise report data using SQL aggregate function • Create joins using SQL • Create subqueries • SQL expressions to promote server side processing
• Craeta a bar chart • Modify a chart • Create a top N chart • Format a chart • Create a chart template
Create a report based on Excel data • Modify a report based on Excel data • Update data in a report based on Excel data
Sorry, we are not arranging any scheduled public courses for this course.
Perhaps you may like to organise a private training session. Please feel free to contact us. One of our training consultants would be pleased to discuss the best options available for you.
Alternatively, why not design your own course? Our Customised Course Builder will allow you to select the modules appropriate for your particular training needs.