A Quick Glance

  • black-arrow

    Exposure through certified and trained industrial experts

  • black-arrow

    Getting advanced knowledge in perfect reading environment

  • black-arrow

    Inclusion of manuals and certifications as a complement from the team

  • black-arrow

    Union of small groups for best interactions in a class

  • black-arrow

    Stand up support 24*7 helping you in your thick and thins

The Crystal Report course is designed for those who want to know about the functionality of SAP. This is also essential for those who want to learn advanced features of Crystal Reports. It prepares candidates with practical exercises. This helps in developing skills in crystal reporting format and data sources reports.

The advanced reports of SAP 2016 help in knowing business intelligence reporting systems. It's in-built guide structure that supports you throughout the developing reports. It was developed by Terry Cunningham and the Cunningham Group in 1991 with the name of ‘Quick reports’.

SAP acquired it from Business Objects in 2007 and re-framed it as crystal reports in 2011. SAP Crystal always produce reports according to your resource objects. Crystal reports editor is a helpful source for editing and managing your information.

Who should take this course

Various delegates from different backgrounds comprise the part of this course and include:

  • Managers who are running their own companies
  • Professionals who need SAP Crystal Report training to maintain accounts
  • Report developers who keeps on researching new innovations in relation to the project
  • Finance analysts who are linked with big companies
  • Delegates looking forward for SAP certification
  • Quality control analysts for interpretation purpose
  • Top level managers to became the part of advanced web reporting

 

More

Prerequisites

There are certain brass tacks which must be kept in mind before starting up with the project:

  • All attendees must have basic familiarity with one of the relational database like Microsoft access, SQL server, MYSQL, Oracle, Sybase or DB2.
  • Prior knowledge of creating basic reports and getting connection to data sources.
  • Basic understanding of modifying existing reports with certain changes.
  • Creating of groups in a report and sub-total and grand total in a report in organized way.
  • Awareness regarding creation of basic formulas and performing simple filters and using sort functions.
More

What Will You Learn

After successful completion of the course the delegates will be able to handle different parameters of crystal application such as:

  • Learning to insert OLE objects and how to edit them in your reports
  • Deciding on creating certain examples of Cross-tab
  • Improving their skills in building queries and connecting to a universe
  • Developing cognition in creating ad updating OLAP reports
  • Organizing and designing various report alerts
  • Selecting dynamic prompts and understanding them
  • Understanding and inserting sub-reports and linking them to the primary report
  • Understanding and Working with SQL databases
  • Integrating business development application with crystal reports
  • Working on assessment of data sources
More

What's included

  Course Overview

This course is helpful to create the group reports including sub reports and charts. Reports must be based on more than one data series. There might be an expectation from users that they can also build tools. So, that other people can also create their own reports.

The reports are into revealing important relationships which companies do not reveal easily. It supports an easy customization and reports are generated in preferred language. People do not need any technical expertise for handling Crystal Reports 2016 documents.

The Advanced Web reporting is beneficial to analyse the inner web browser reports. It will also help in creating alerts and sub reports and adding of OLE objects in your reports. Moreover, training in working with cross tabs, SQL, OLAP reports are also given in this course of PENTAGON’s.

More

  Course Content

Quick start with OLE

  • Overview of OLE
  • Inserting OLE objects into data reports
  • Edition of OLE objects
  • Working with static OLE objects

Working with cross tab objects

  • Understanding cross tab objects
  • Example of cross tab objects
  • Creating cross tab report
  • Working with cross tab

Working with OLAP reports

  • OLAP reporting with crystal reports
  • Creating an OLAP report
  • Updating an OLAP report
  • Data formatting in OLAP grid
  • Sorting and filtering 

Using report alerts

  • Understanding report alerts
  • Working with report alerts

Parameter fields and prompts

  • Over viewing parameter an prompts
  • Understanding dynamic prompts
  • List of values
  • Creation of parameter with static prompt
  • Creation of parameter with dynamic prompt
  • Creation of parameter with cascading list of values
  • Understanding parameter panel
  • Advanced parameter features

Working with Sub-reports

  • What are sub-reports?
  • Inserting sub-reports
  • Linking sub-reports
  • Combining unrelated reports
  • Creating on-demand sub-reports

Database working

  • Overview of database
  • Using SQL and its database
  • Changing data sources
  • Linking tables
  • Mapping database fields
  • Advanced database features

Integrating business development application with crystal reports

  • Integrating with SAP
  • Integrating with Oracle
  • Integration with Siebel
  • Integration with PeopleSoft
  • Integration with JD Edwards

Assessment of data sources 

  • Introduction to it
  • Direct access database files
  • ODBC data sources
  • JDBC data sources

Model of report processing

  • What is ‘Pass’?
  • Pre-pass 1
  • Pre-pass 2

Creation of accessible reports

  • What is accessibility?
  • Improving report accessibility
  • Designing for flexibility
  • Accessibility and customization

 

More


Crystal Reports 2016 Advanced Enquiry

 

Enquire Now


----- OR -------

Reach us at +44 1344 961530 or info@pentagonit.co.uk for more information.