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.