In this 2-day instructor-led course participants who have been building and modifying reports are enabled to use the advanced functionality of Crystal Reports to generate reports in a more effective format. Students will create complex reports and data sources using the tools in Crystal Reports 2020. Participants will also learn to use tools that can increase the speed with which data is retrieved.
Student will not only create more sophisticated reports, including subreports and cross-tabs, but will also increase the speed and efficiency of your reports by using SQL queries. Even though learners may be familiar with Crystal Reports, participants take some time to study its various tools that enable them to generate reports with the desired data using advanced methods such as SQL querying. This way learners won't be slowed down by large databases or databases with which they are unfamiliar. By creating subreports, cross-tabs, and running totals, students will turn raw data into meaningful, customized reports that will help business' run more smoothly. Note: to ensure success in this course, participants should have the knowledge and skills covered in SCR1 SAP Crystal Reports 2020 Part 1, or equivalent experience. Learners may or may not have programming and/or SQL experience.
This course is designed for people 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 that make it easier for other people to create reports.
What You'll Learn
- 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 Number SCR2
- Course Length 2 days
- Course Fee $1,195.00
- Delivery Format VLT (Instructor Led; Virtual LIVE Online; Remote Training)
- Course Topic Data Management and Analytics
- Vendor SAP
- Technology Crystal Reports