Online Live Training On: Crystal Report Using PL/SQL

Crystal Report: Crystal Reports is quite a user-friendly tool. It can be easily learnt. All that you need is a basic knowledge of how to connect with the database from where the data is to be drawn to generate the reports.

Benefits of Crystal Report:

• As crystal reports are created in designer interface, less coding part is covered.
• Complex reports can be made interactive through chart view and hence make easy view of the business model.
• It can easily interact with other ASP.NET web form controls.

Users: Crystal Reports is most often used by companies with 50-200 employees and 10M-50M dollars in revenue.

PL/SQL:

• Tight Integration with SQL.
• High Performance.
• High Productivity.
• Portability
• Scalability
• Manageability
• Support for Object-Oriented Programming.
• Support for Developing Web Applications.

Who will be benefited: PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database. PL/SQL saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and object-oriented data types. Applications written in PL/SQL are fully portable.

Training Outline:

PL/SQL

• Introduction to PL/SQL
• Declaring PL/SQL Variables
• Writing Executable Statements
• Writing Control Structures
• Using Explicit Cursors
• Handling Exceptions
• Introducing Stored Procedures and Functions
• Creating procedures
• Creating functions and debugging subprograms
• Creating packages
• Use existing report related package.
• Add new functions and procedure to existing package.
• How to use MIS library in creating procedure.

Creating Report using Crystal Report

• Crystal report options
• Connect to oracle database
• Use SQL command
• Use table & store procedure
• Field explorer dialogue box
• Basic conventions for BankUltimus
• Section expert option
• Adding Group
• Sample report
• How to add sub-report
• Link main report with sub-report
• How to add formula
• Apply sample formula
• Briefly describe the MIS library and its utilization.