Online Live Training On: Crystal Report Using PL/SQL

5,000.00 ৳ 

Start Date: 20 May , 2023

Time: Friday, Saturday (07:30 PM – 09:30 PM)

Duration: 16 Hours.

Contact: 01847179477, 0181144806


Trainer: Sraboni Biswas [View Profile]

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.


  • 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:


  • 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.