Pelatihan Crystal Report

Training Crystal Report

TRAINING CRYSTAL REPORT

DESCRIPTION PELATIHAN CRYSTAL REPORT

Crystal Report is the primary recommended course you should take if your job responsibilities require you to obtain output from database. In this course, you will build basic list and group report that work with almost any database.

MANFAAT TRAINING CRYSTAL REPORT

With the power of this industry-leading report-writing tool, Crystal Reports users and developers can integrate their organization’s data, making sophisticated reports readily available to support critical business decisions. In this hands-on course, you gain extensive experience using Crystal Reports to connect to databases, retrieve raw data, format data, and create and present reports for widespread distribution. You return to your organization with a detailed process to help you connect to data sources and create useful reports right away.

WHO SHOULD ATTEND

Anyone involved in creating reports from stored data. Experience using Windows and working with a spreadsheet is assumed.

METODE PELATIHAN CRYSTAL REPORT

Presentation, Discussion,Case Study, Evaluation

COURSE OUTLINE TRAINING CRYSTAL REPORT

1. Creating a Report
   • Set Default Report Setting
   • Specify Fields for a New Report
   • Preview the Report
   • Modify Field Display
   • Add Fields From Additional Tables
2. Displaying Specific Report Data
   • Find Data
   • Sort Data
   • Filter Data by single Criteria
3. Grouping Report Data
   • Insert a Group
   • Add Summaries
   • Format Summary Information
   • Change Group Options
   • Filter by Group
   • Create a Top N sort Group
4. Building Formulas
   • Write a Formula
   • Group by Formula
   • Build a Filter by Multiple Criteria
   • Create parameter Field
   • Write a Formula that incorporates Null Fileds
5. Formating Reports
   • Remove White Space
   • Insert Page Header/Footer Data
   • Add Border and lines
   • Change the Margins
6. Enhancing Reports
   • Create a section to Contain a Watermark
   • Insert Object Using OLE
   • Modify Format Based on Data Value
   • Insert Hyperlinks
7. Creating and Modifying Pie Charts
   • Create Pie Chart with Drill Down
   • Modify Chart Text
   • Format Chart
   • Present a Chart by Group
8. Distributing Data
   • Export to PDF
   • Export to Excel
   • Export to Access Database
   • Create a Report Definitions
   • Create Mailing Labels
9. Distributing Data
   • Export to PDF
   • Export to Excel
   • Export to Access Database
   • Create a Report Definitions
   • Create Mailing Labels
10. Creating Running Totals
    • Create a Running Total Field
    • Modify a Running Total Field
    • Create a Manual Running Total on Detail Data
    • Create a Manual Running Total on summary Data
11. Building Cross-tabs in Your Report
    • Create a Cross tab
    • Create a Specified Group Order
    • Filter a Cross Tab by Group
    • Change the cross tab format
    • Conditionally Format Rows and Columns
12. Adding SubReports
    • Insert a SubReport
    • Link a subreport to data in a Primary Report
    • Edit a SubReport
    • Format a subreport using the format editor
    • Share Formulas Between Main and Subreport
13. Creating Drill Downs
    • Create a Drill Down
    • Create separate headings for Drill Down
14. Enhancing Report Processing Using SQL
    • Create a Report using SQL Query
    • Summarize Report Data Using SQL Aggregate Function
    • Create Join Using SQL
    • Create Subqueries
15. Charting Data
    • Create Bar Chart
    • Modify Chart
    • Create a Top N Chart
    • Format a Chart
    • Create a Chart Template
16. Reporting on Excel Data
    • Create a Report Based on Excel Data
    • Modify a Report Generated from exel data
    • Update Data in a Report Based on Excel Data

INSTRUKTUR

Instruktur yang mengajar pelatihan Crystal Report ini adalah instruktur yang berkompeten di bidang Crystal Report baik dari kalangan akademisi maupun praktisi.

Jadwal Pelatihan Transform-mpi.com 2024 :

• Batch 1 : 03 – 04 Januari 2024 | 16 – 17 Januari 2024
• Batch 2 : 07 – 08 Februari 2024 | 20 – 21 Februari 2024
• Batch 3 : 05 – 06 Maret 2024 | 19 – 20 Maret 2024
• Batch 4 : 09 – 10 April 2024 | 13 – 24 April 2024
• Batch 5 : 07 – 08 Mei 2024 | 22 – 23 Mei 2024
• Batch 6 : 05 – 06 Juni 2024 | 25 – 29 Juni 2024
• Batch 7 : 09 – 10 Juli 2024 | 23 – 24 Juli 2024
• Batch 8 : 06 – 07 Agustus 2024 | 20 – 21 Agustus 2024
• Batch 9 : 04 – 05 September 2024 | 18 – 19 September 2024
• Batch 10 : 18 – 19 Oktober 2024 | 15 – 16 Oktober 2024
• Batch 11 : 06 – 07 November 2024 | 26 – 27 November 2024
• Batch 12 : 04 – 05 Desember 2024 | 18 – 19 Desember 2024

Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda.

Biaya dan Lokasi Pelatihan :

• Jakarta :
• Bandung
• Yogyakarta
• Surabaya
• Malang
• Bali
• Lombok

Catatan : Biaya diatas belum termasuk akomodasi/penginapan. Apabila ada pertayaan mengenai materi, biaya, lokasi, jadwal dan penawaran lainnya, hubungi kami di nomor CS kami.

Fasilitas Pelatihan di transform-mpi.com:

1. Penjemputan dari Hotel/Bandara/Stasiun/Terminal.
2. Training Kit (Dokumentasi photo, Blocknote, ATK, Flashdisk, dll).
3. Transportasi Peserta ke tempat pelatihan.
4. 2x Coffe Break & 1 Lunch (Makan Siang).
5. Training Room Full AC and Multimedia.
6. Free Bag or Bagpackers (Tas Training).
7. Softfile Foto Training
8. Sertifikat Pelatihan.
9. Souvenir Exclusive.