When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 4 modules in this course
In this course, you'll continue developing your data-reporting skills in Crystal Reports by using creating, editing, and filtering data in reports. You'll also build parameterized reports and group report data to make the process of interpreting data easier.
This is the second course in a multi-course Specialization.
All of the courses in this Specialization require that you have SAP Crystal Reports 2020 installed. You also need to have an installation of Office 2019 apps or later, particularly Access. The course setup instructions provided in the first course go into more detail about the hardware and software requirements.
You created reports that contain data from a database. Sometimes, you may want to create calculated fields in a report.
What's included
1 reading8 plugins
Show info about module content
1 reading•Total 5 minutes
⚠️READ THIS FIRST⚠️•5 minutes
8 plugins•Total 170 minutes
Lesson Introduction•5 minutes
Create a Formula•30 minutes
Edit a Formula•30 minutes
Filter Data by Using a Formula•30 minutes
Work with Advanced Formulas and Functions•30 minutes
Handle Null Values•30 minutes
Mastery Builder: Creating Formula Fields•10 minutes
Lesson Summary•5 minutes
Building Parameterized Reports
Module 2•1 hour to complete
Module details
You used advanced formulas and functions in your reports. These reports return the same data every time you run them. With SAP® Crystal Reports® 2020, you can add parameters and prompts to make your reports accept values from the user and display data based on user input.
What's included
6 plugins
Show info about module content
6 plugins•Total 70 minutes
Lesson Introduction•5 minutes
Create a Parameter Field•15 minutes
Use a Range Parameter in a Report•15 minutes
Create a Prompt•15 minutes
Mastery Builder: Inserting Parameters in a Report•15 minutes
Lesson Summary•5 minutes
Grouping Report Data
Module 3•3 hours to complete
Module details
You added specific information from a database to your report. To ease the data-interpretation process, you have to organize the report data into meaningful groups and, if desired, summarize each group.
What's included
7 plugins
Show info about module content
7 plugins•Total 180 minutes
Lesson Introduction•5 minutes
Group Report Data•40 minutes
Modify a Group Report•40 minutes
Group by Using Parameters•40 minutes
Create a Parameterized Top N Report•40 minutes
Mastery Builder: Creating a Report with Groups•10 minutes
Lesson Summary•5 minutes
Completing the Course
Module 4•25 minutes to complete
Module details
You'll wrap things up and then validate what you've learned in this course by taking an assessment.
What's included
1 reading1 assignment
Show info about module content
1 reading•Total 5 minutes
Course Summary•5 minutes
1 assignment•Total 20 minutes
Course Assessment•20 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Logical Operations is the world's largest general publisher of instructor-led technology curriculum, and a leader in the technical training community for over 40 years. We employ a rigorous, expert-driven authoring process that, for decades, has produced successful results for learners the world over. Our courseware aligns with real-world business needs and objectives, ensuring learners are able to apply their newly developed skills while on the job.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.