LEADS Corporation Limited
HOME > LTCL > Training > Online Course: Creating Report using Crystal Report & PL/SQL

Online Course: Creating Report using Crystal Report & PL/SQL

Last Date of Registration: 24 September, 2020
Start Date: 25 September, 2020
Time: Friday, Saturday (07:00 PM – 09:00 PM)
Duration: 30 Hours
Course Fee: 6,000 TK
Contact: 01811449483, 01847179477, 01811448063

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.


Start Course