Training Crystal Report 10

DESCRIPTION
Crystal Report 10 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.

COURSE OUTLINE

Creating a Report
• Set Default Report Setting
• Specify Fields for a New Report
• Preview the Report
• Modify Field Display
• Add Fields From Additional Tables

Displaying Specific Report Data
• Find Data
• Sort Data
• Filter Data by single Criteria

Grouping Report Data
• Insert a Group
• Add Summaries
• Format Summary Information
• Change Group Options
• Filter by Group
• Create a Top N sort Group

Building Formulas
• Write a Formula
• Group by Formula
• Build a Filter by Multiple Criteria
• Create parameter Field
• Write a Formula that incorporates Null Fileds

Formating Reports
• Remove White Space
• Insert Page Header/Footer Data
• Add Border and lines
• Change the Margins

Enhancing Reports
• Create a section to Contain a Watermark
• Insert Object Using OLE
• Modify Format Based on Data Value
• Insert Hyperlinks

Creating and Modifying Pie Charts
• Create Pie Chart with Drill Down
• Modify Chart Text
• Format Chart
• Present a Chart by Group

Distributing Data
• Export to PDF
• Export to Excel
• Export to Access Database
• Create a Report Definitions
• Create Mailing Labels

Distributing Data
• Export to PDF
• Export to Excel
• Export to Access Database
• Create a Report Definitions
• Create Mailing Labels

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

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

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

Creating Drill Downs
• Create a Drill Down
• Create separate headings for Drill Down

Enhancing Report Processing Using SQL
• Create a Report using SQL Query
• Summarize Report Data Using SQL Aggregate Function
• Create Join Using SQL
• Create Subqueries

Charting Data
• Create Bar Chart
• Modify Chart
• Create a Top N Chart
• Format a Chart
• Create a Chart Template

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

Fasilitas Yang Diperoleh

• Lokasi Training di Hotel Bintang 3-5
• Ruang Pelatihan Full AC, Toilet dan Musholla
• Perlengkapan Visual LCD Proyektor, & Whiteboard
• Modul / Handout(Hard Copy & Soft Copy)
• Training Kit (Co-Card, Bolpoin, & Buku Catatan)
• 1x Makan Siang dan 2x Coffee Break (Snack)
  
• Penjemputan Bandara Hotel (Pulang-Pergi selama pelatihan)
• Basement Tempat Parkir Motor dan Mobil yang Aman
• Akses Internet Wireless
• Smoking Area.
• Sertifikat Keikutsertaan Training
• Merchandise menarik dari Duta Pro Training & Consulting
• Konsultasi dengan Instruktur setelah Pelatihan