.

Thursday 1 January 2015

Kursus Crystal Report

Pengenalan

Crystal Report merupakan satu aplikasi yang digunakan untuk membuat, menganalisa dan menterjemahkan data yang terkandung dalam database ke dalam pelbagai jenis laporan seperti laporan grafik, laporan kewangan dan sebagainya. Crystal Report dirancang untuk membuat laporan yang berintegrasi dengan produk Microsoft seperti Visual Basic, Microsoft Visual Studio dan sebagainya.





Kelebihan Crystal Reports 
  1. Hasil cetakan Crystal Report lebih baik dan lebih mudah kerana pada Crystal Report banyak tersedia objek dan komponen yang mudah digunakan.
  2. Laporan yang dilakukan tidaklah terlalu rumit dan banyak melibatkan kod pengaturcaraan.
  3. Mempunyai integrasi dengan bahasa-bahasa pengaturcaraan lain.
  4. Laporan Crystal Report dapat menyokong format seperti Microsoft Word, Microsoft Excel, Microsoft Access, Adobe Acrobat Reader, HTML dan sebagainya.
Contoh Laporan Menggunakan Crystal Report

Rajah Menunjukkan Contoh Antarmuka Crystal Report
Rajah menunjukkan contoh membina Crystal Report menggunakan
 Microsoft Visual C#
Rajah Menunjukkan Hasil Crystal Report yang Telah Diconvert ke Dalam Bentuk pdf
Kandungan Kursus

Day 1
9.00am - 10.00am Introduction
  • What Crystal is and What It is Not
  • What You Will Need
  • A Few Words on Versions
  • CRXI Installation Options
  • Course Overview
  • 10.00am - 10.30am Breakfast
    10.30am - 01.00pm Create a Basic Report
  • Data Connections - ODBC
  • Data Connections - Direct
  • Getting to Know Your Data Source
  • Report Wizard - Tables & Fields
  • Report Wizard - Group & Filter
  • 01.00pm - 02.00pm Lunch
    02.00pm - 05.00pm Designing a Basic Report
  • The CRXI Work Area
  • Layout & Presentation
  • Basic Formatting
  • Basic Grouping & Sorting
  • Summary Functions
  • Inserting Objects into Reports
  • Previewing & Exporting Reports
  • Day 2
    9.00am - 10.00am Create a Report Beyond the Basics
  • Report Wizard - Multiple Tables
  • Report Wizard - Multiple Filtering
  • Grouping Data pt. 1
  • Grouping Data pt. 2
  • Inserting Summaries
  • Fields - Dimensions vs. Metrics
  • Select Expert
  • Export Options
  • 10.00am - 10.30am Breakfast
    10.30am - 01.00pm Design a Report Beyond the Basics 1
  • Report Options
  • Crystal Options pt. 1
  • Crystal Options pt. 2
  • Grids & Layout Options
  • Section Expert
  • Colors/Fonts/Borders
  • 01.00pm - 02.00pm Lunch
    02.00pm - 05.00pm Design a Report Beyond the Basics 2
  • Graphs & Charts pt. 1
  • Graphs & Charts pt. 2
  • Graphic Files
  • Drawing Lines
  • Field Options
  • Special Fields
  • Design Tips pt. 1
  • Design Tips pt. 2
  • Report Exercise 1
  • Report Solution 1
  • Day 3
    9.00am - 10.00am Fields Dimensions Metrics 1
  • Database Fields
  • User Defined Fields
  • The Formula Editor
  • String Functions
  • Date Functions
  • Metric Functions
  • Conversion Functions
  • Formula Problem 1
  • Formula Solution 1 pt. 1
  • Formula Solution 1 pt. 2
  • 10.00am - 10.30am Breakfast
    10.30am - 01.00pm Fields Dimensions Metrics 2
  • Modifying Fields - Two Methods
  • Working with Dates
  • Working with Strings
  • Working with Numbers
  • Conditional Formula Pitfalls
  • Conditional Formula Problem 1
  • Conditional Formula Solution 1 pt. 1
  • Conditional Formula Solution 1 pt. 2
  • 01.00pm - 02.00pm Lunch
    02.00pm - 05.00pm Filtering Data
  • Select Expert Reintroduction
  • The Formula Editor for Select Expert
  • Filter Formulas pt. 1 - AND
  • Filter Formulas pt. 2 - OR
  • Filter Formulas pt. 3 - AND & OR
  • Filters - Database vs. User Fields
  • Select Statement Considerations
  • Filter Formula Problem 1
  • Filter Formula Solution 1
  • Day 4
    9.00am - 10.00am Report Templates
  • Template Expert
  • Templates Review
  • Template Limitations
  • Modifying Templates
  • Exporting Template Reports
  • 10.00am - 10.30am Breakfast
    10.30am - 01.00pm Modifying a Report
  • Changing Groups
  • Changing Fields
  • The Database Expert - Adding Tables
  • 01.00pm - 02.00pm Lunch
    02.00pm - 05.00pm
  • Database Changes pt. 1
  • Database Changes pt. 2
  • Report Performance
  • Database Change Problem 1
  • Database Change Solution 1
  • Day 5
    9.00am - 10.00am The Cross Tab Report
  • Layout
  • Functions
  • Options
  • 10.00am - 10.30am Breakfast
    10.30am - 01.00pm
  • Formatting
  • Limitations
  • Problem 1
  • Solution 1
  • 01.00pm - 02.00pm Lunch
    02.00pm - 05.00pm Excel Export
  • Preparing Reports for Excel
  • Field Layout & Design
  • Cross Tabs & Excel
  • Exporting to Exce Options l
  • Sekiranya anda berminat untuk mempelajari kursus Crystal Reports ini, sila hubungi kami di talian 03-61880601 ataupun menerusi emel sales@2-sigma.com untuk mendapatkan kandungan kursus atau keterangan yang lebih lanjut.

    0 comments:

    Post a Comment