SAP Crystal Reports:Master-Detail,Cross-Tab,Sub-Reports
4.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
18 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP Crystal Reports:Master-Detail,Cross-Tab,Sub-Reports to your Wishlist.

Add to Wishlist

SAP Crystal Reports:Master-Detail,Cross-Tab,Sub-Reports

Design Business Intelligence Reports and drill down data.
4.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
18 students enrolled
Last updated 12/2016
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Deep knowledge of the Crystal Reports features.
  • Cross Tab Reports to generate Business Intelligence.
  • Sub Reports to drill down detail of data.
View Curriculum
Requirements
  • Basic understanding of relational database.
  • Understanding of the Tables Schema of the database to get the data.
  • Basic knowledge of SQL query language.
Description

Summary:
Crystal Reports is owned by SAP.  But it can be used to generate reports
for any kind of database and Enterprise Resource Planning.
This course is intended for all of those developers, programmers and
system analysts that provides information and Business Intelligence for
the strategic Management.
Master Detail reports to represent the clients and products sold to
each one.  Cross tab are for Business Intelligence.  Drill down data
from general information to specific data can be done by Sub-Reports.

Index

Lesson One:
a) Link Tables of Database
b) Master Detail Report
c) Calculations Formula for Master Detail Report.
d) Group Fields to display data.
e) Charts of Group Fields.
Lesson Two:
a)  Total in fields.
b) Group by criteria.
c) Sort Control for user.
Lesson Three:
a)  Select Expert to display data with defined criteria.
b)  Advance Chart to display drill-down data.
c) Pass user parameters to the Select Expert.
Lesson Four:
a)  Cross tab reports.
b)  Cross tab charts.
c)  Include Formula Field in a cross tab report.
d)  User defined parameter to drill down details on Cross Tab Reports.
Lesson Five:
a) Sub Reports
b) Linked Sub Reports to print drill down details in a 
   Master Detail relationship.

Who is the target audience?
  • Designers and developers of Reports for Management.
  • Managers that want to learn the features of SAP Crystal Reports.
Compare to Other Crystal Report Courses
Curriculum For This Course
9 Lectures
02:04:07
+
General Introduction to Crystal Reports
1 Lecture 10:19
+
Lesson One: Master Detail Charts
2 Lectures 31:52
Lesson One: Master Detail Charts Part One
15:17

Lesson One: Master Detail Charts Part Two
16:35
+
Lesson Two: Total, Groups and Sort
2 Lectures 29:09
Lesson Two: Total, Groups and Sort. Part One.
16:02

Lesson Two: Total, Groups and Sort
13:07
+
Lesson Three: Select Expert and Parameters
1 Lecture 16:13
Lesson Three: Select Expert and Parameters
16:13
+
Lesson Four: Cross Tab Reports
1 Lecture 17:11
Lesson Four: Cross Tab Reports
17:11
+
Lesson Five: Sub Reports
2 Lectures 19:23
Lesson Five: Sub Reports Part One
03:17

Lesson Five: Sub Reports Part Two
16:06
About the Instructor
Fernando Roque SD Metrics
3.1 Average rating
11 Reviews
101 Students
6 Courses
Director SD Metrics

I do process and quality control using statistics.  The data entry for data analysis is done with mobile software developed by my company, SD METRICS.  
Expert in Geographical Information Systems, Logistics and data acquisition with mobile and using Google Maps API.
Cross platform development for Android, Windows Mobile and Iphone with HTML5 and JSONP with webservices and Database on the Cloud (PHP, MYSQL).