Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Finance & Accounting Money Management Tools Crystal Reports

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

Design Business Intelligence Reports and drill down data.
Rating: 3.6 out of 53.6 (14 ratings)
127 students
Created by Quantic Statistics
Last updated 12/2016
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Deep knowledge of the Crystal Reports features.
  • Cross Tab Reports to generate Business Intelligence.
  • Sub Reports to drill down detail of data.

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 this course is for:

  • Designers and developers of Reports for Management.
  • Managers that want to learn the features of SAP Crystal Reports.

Course content

6 sections • 9 lectures • 2h 4m total length

  • Preview10:19

  • Lesson One: Master Detail Charts Part One
    15:17
  • Lesson One: Master Detail Charts Part Two
    16:35

  • Lesson Two: Total, Groups and Sort. Part One.
    16:02
  • Lesson Two: Total, Groups and Sort
    13:07

  • Lesson Three: Select Expert and Parameters
    16:13

  • Lesson Four: Cross Tab Reports
    17:11

  • Lesson Five: Sub Reports Part One
    03:17
  • Lesson Five: Sub Reports Part Two
    16:06

Instructor

Quantic Statistics
SAP, Tableau, Power BI,Business Analysis
Quantic Statistics
  • 3.7 Instructor Rating
  • 287 Reviews
  • 1,423 Students
  • 14 Courses

Process and quality control using statistics.  The data entry for data analysis is done with mobile software developed in house.  
Expertise 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). 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.