10-17-2024, 09:04 PM
Sap Crystal Reports 2020 (And Earlier Versions)
Last updated 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.56 GB | Duration: 3h 27m
How to create reports quickly and easily. For SAP Crystal Reports 2008, 2011, 2013, 2016 and 2020
[b]What you'll learn[/b]
Have a good knowledge of Crystal Reports, having installed it on your laptop.
Know about the different types of data sources, and how to create a report from scratch, including grouping, sorting and filtering/selecting.
Be able to format dates, numbers, text and other fields, insert and format graphics and other objects, and know when and why to insert additional sections.
Find out why hard-coded figures do not give the best interaction to the end-user, and use parameters to overcome this problem.
Add all manner of graphs, from bar charts to pie charts, radar charts and more.
Create subreports and drill-down reports, including using Cross-tab (PivotTables) in these reports.
Know what types of formulas are available, and how they can be used.
[b]Requirements[/b]
You just need a positive attitude for this course - nothing else!
It would be helpful if you had a computer on which you could download the free trial of Crystal Reports, but it is not essential.
[b]Description[/b]
Reviews:"I've recently started a new job and need to use Crystal Reports 2016 which is software I'd not previously used at my old organization. I feel much more comfortable now working out what my predecessor did when putting her reports together, and will be able to more effectively roll-forward and update the previous reports." - John"Despite having some empirical experience of CR use, I was at the total beginners' level when starting this course. I can use SAP CR much more consciously now. Especially enjoyed the Formulas section. Thank you, Phillip!" - Julius"Neatly articulated and presented with full of joy. Felt very good all the way till end with his friendly teaching method. Feel good learning experience. Thank You!" - ParthasarathiHello, and welcome to Crystal Reports 2008 to 2020. This course has been completely re-recorded using SAP Crystal Reports 2020In this course we'll be looking at SAP Crystal Reports, and how to use it.This course starts right at the beginning, and so is good for absolute beginners, but would also be useful for you if you have previously used it, perhaps viewing reports or making basic reports, and would like to improve your skills.You don't need to have Crystal Reports on your computer, as first of all we will install a trial version of Crystal Reports for free, so that you can use it on your computer free for 30 days. This way, you can practice with your new skills, experiment with your own data and create your own reports.This course is separated into 7 levels, each getting progressively more deeper into Crystal Reports. They are:Creating your first report,Adding grouping, sorting and filtering, also known as Selecting.Formatting,Adding user interaction through parameters,Graphs and charts,Subreports, andFormulas.All of this will be taken at a fairly leisurely pace, so you can really get familiar with the menus and icons.By the end, you will be able to develop your own reports, and start to explore other people's. And there's a Certificate of Completion available if you complete the course.
Overview
Section 1: Introduction
Lecture 1 Hello
Lecture 2 Welcome to Udemy
Lecture 3 Introduction to Udemy
Lecture 4 Do you want auto-translated subtitles in more languages?
Lecture 5 Curriculum
Section 2: Level 1: Creating our first report
Lecture 6 Installing Crystal Reports
Lecture 7 Source Data, and some problems with recent versions of Crystal Reports
Lecture 8 Running Crystal Reports, and adding a Data Source
Lecture 9 Creating our first report
Lecture 10 Altering our report, and saving it.
Section 3: Level 2: Diving in deeper
Lecture 11 Saving data with report, and updating data source
Lecture 12 Other Data sources
Lecture 13 Using the Xtreme database source?
Lecture 14 Creating a report from scratch - adding fields
Lecture 15 Sorting results
Lecture 16 Grouping
Lecture 17 Filtering (or Select Expert)
Lecture 18 Practice Activity
Lecture 19 Exercise - Creating a detailed, filtered, sorted, grouped report
Section 4: Level 3: Formatting
Lecture 20 Formatting font and font colors
Lecture 21 Formatting - borders and background color
Lecture 22 Common formatting, including Can Grow, suppress, and hyperlinks
Lecture 23 Formatting text and boolean fields
Lecture 24 Formatting numbers
Lecture 25 Formatting dates and times
Lecture 26 Adding and formatting text boxes, boxes, graphics and lines
Lecture 27 Aligning and resizing objects
Lecture 28 Adding and formatting additional sections
Section 5: Level 4: Parameters
Lecture 29 Adding user interaction by using a parameter
Lecture 30 Parameter Options
Section 6: Level 5: Graphs, charts and all manner of diagrams
Lecture 31 Let's insert a chart and chart options
Lecture 32 Different types of charts 1 - bar, area, line and pie charts
Lecture 33 Different Types of Charts 2 - from doughnut (donut) charts to histogram charts
Lecture 34 Context of charts
Section 7: Level 6: Subreports
Lecture 35 Creating a drill down report
Lecture 36 Designing a subreport using a Cross-tab
Lecture 37 Creating linked subreports
Section 8: Level 7: Formulas
Lecture 38 Creating formulas
Lecture 39 Special fields
Lecture 40 If and Iif, Boolean logic and other Control Structures
Lecture 41 Text functions
Lecture 42 Mathematical functions
Lecture 43 Summary functions
Lecture 44 Date formulas
Lecture 45 Solving our subreport problem
Lecture 46 Using parameters for conditional formatting and selecting
Section 9: Conclusion
Lecture 47 Congratulations
Lecture 48 Bonus Lecture
You should take this if you want to learn about Crystal Reports 2008, Crystal Reports 2011, Crystal Reports 2013, or the new Crystal Reports 2016,No prior experience in reporting programs is required, although it would be helpful if you have previously created reports in other reporting tools.,If you already have some significant experience in Crystal Reports, this introductory course is probably not for you. However, there may be some things, such as subreports and drill-down reports, that you might help you.
[b]What you'll learn[/b]
Have a good knowledge of Crystal Reports, having installed it on your laptop.
Know about the different types of data sources, and how to create a report from scratch, including grouping, sorting and filtering/selecting.
Be able to format dates, numbers, text and other fields, insert and format graphics and other objects, and know when and why to insert additional sections.
Find out why hard-coded figures do not give the best interaction to the end-user, and use parameters to overcome this problem.
Add all manner of graphs, from bar charts to pie charts, radar charts and more.
Create subreports and drill-down reports, including using Cross-tab (PivotTables) in these reports.
Know what types of formulas are available, and how they can be used.
[b]Requirements[/b]
You just need a positive attitude for this course - nothing else!
It would be helpful if you had a computer on which you could download the free trial of Crystal Reports, but it is not essential.
[b]Description[/b]
Reviews:"I've recently started a new job and need to use Crystal Reports 2016 which is software I'd not previously used at my old organization. I feel much more comfortable now working out what my predecessor did when putting her reports together, and will be able to more effectively roll-forward and update the previous reports." - John"Despite having some empirical experience of CR use, I was at the total beginners' level when starting this course. I can use SAP CR much more consciously now. Especially enjoyed the Formulas section. Thank you, Phillip!" - Julius"Neatly articulated and presented with full of joy. Felt very good all the way till end with his friendly teaching method. Feel good learning experience. Thank You!" - ParthasarathiHello, and welcome to Crystal Reports 2008 to 2020. This course has been completely re-recorded using SAP Crystal Reports 2020In this course we'll be looking at SAP Crystal Reports, and how to use it.This course starts right at the beginning, and so is good for absolute beginners, but would also be useful for you if you have previously used it, perhaps viewing reports or making basic reports, and would like to improve your skills.You don't need to have Crystal Reports on your computer, as first of all we will install a trial version of Crystal Reports for free, so that you can use it on your computer free for 30 days. This way, you can practice with your new skills, experiment with your own data and create your own reports.This course is separated into 7 levels, each getting progressively more deeper into Crystal Reports. They are:Creating your first report,Adding grouping, sorting and filtering, also known as Selecting.Formatting,Adding user interaction through parameters,Graphs and charts,Subreports, andFormulas.All of this will be taken at a fairly leisurely pace, so you can really get familiar with the menus and icons.By the end, you will be able to develop your own reports, and start to explore other people's. And there's a Certificate of Completion available if you complete the course.
Overview
Section 1: Introduction
Lecture 1 Hello
Lecture 2 Welcome to Udemy
Lecture 3 Introduction to Udemy
Lecture 4 Do you want auto-translated subtitles in more languages?
Lecture 5 Curriculum
Section 2: Level 1: Creating our first report
Lecture 6 Installing Crystal Reports
Lecture 7 Source Data, and some problems with recent versions of Crystal Reports
Lecture 8 Running Crystal Reports, and adding a Data Source
Lecture 9 Creating our first report
Lecture 10 Altering our report, and saving it.
Section 3: Level 2: Diving in deeper
Lecture 11 Saving data with report, and updating data source
Lecture 12 Other Data sources
Lecture 13 Using the Xtreme database source?
Lecture 14 Creating a report from scratch - adding fields
Lecture 15 Sorting results
Lecture 16 Grouping
Lecture 17 Filtering (or Select Expert)
Lecture 18 Practice Activity
Lecture 19 Exercise - Creating a detailed, filtered, sorted, grouped report
Section 4: Level 3: Formatting
Lecture 20 Formatting font and font colors
Lecture 21 Formatting - borders and background color
Lecture 22 Common formatting, including Can Grow, suppress, and hyperlinks
Lecture 23 Formatting text and boolean fields
Lecture 24 Formatting numbers
Lecture 25 Formatting dates and times
Lecture 26 Adding and formatting text boxes, boxes, graphics and lines
Lecture 27 Aligning and resizing objects
Lecture 28 Adding and formatting additional sections
Section 5: Level 4: Parameters
Lecture 29 Adding user interaction by using a parameter
Lecture 30 Parameter Options
Section 6: Level 5: Graphs, charts and all manner of diagrams
Lecture 31 Let's insert a chart and chart options
Lecture 32 Different types of charts 1 - bar, area, line and pie charts
Lecture 33 Different Types of Charts 2 - from doughnut (donut) charts to histogram charts
Lecture 34 Context of charts
Section 7: Level 6: Subreports
Lecture 35 Creating a drill down report
Lecture 36 Designing a subreport using a Cross-tab
Lecture 37 Creating linked subreports
Section 8: Level 7: Formulas
Lecture 38 Creating formulas
Lecture 39 Special fields
Lecture 40 If and Iif, Boolean logic and other Control Structures
Lecture 41 Text functions
Lecture 42 Mathematical functions
Lecture 43 Summary functions
Lecture 44 Date formulas
Lecture 45 Solving our subreport problem
Lecture 46 Using parameters for conditional formatting and selecting
Section 9: Conclusion
Lecture 47 Congratulations
Lecture 48 Bonus Lecture
You should take this if you want to learn about Crystal Reports 2008, Crystal Reports 2011, Crystal Reports 2013, or the new Crystal Reports 2016,No prior experience in reporting programs is required, although it would be helpful if you have previously created reports in other reporting tools.,If you already have some significant experience in Crystal Reports, this introductory course is probably not for you. However, there may be some things, such as subreports and drill-down reports, that you might help you.