EventsIT  Step By Step Membuat Laporan dengan Crystal Report

Step By Step Membuat Laporan dengan Crystal Report



Crsytal Report merupakan salah satu tools untuk membuat laporan yang paling laris dan sukses di dunia dalam hal mengolah data menjadi suatu informasi, Dimana tercatat sampai pada tahun 2015 Crsytal Report merupakan tools yang paling banyak dipakai oleh para user bahkan diyakini sampai saat ini, Menjadi pilihan berbagai kalangan tentunya Crsytal Report memiliki berbagai hal yang patut dijadikan alasan, selain sebagai tools yang sangat populer dan mudah dipelajari oleh berbagai kalangan baik Pemula ataupun Ahli, yang didukung penuh oleh Microsoft selalu dikembangkan dan disesuaikan dengan kebutuhan zaman seperti penyesuaian model-model bentuk dari sebuah laporan.

Pelatihan ini bertujuan agar peserta mendapatkan dasar-dasar pengetahuan tentang tools dari teknologi Crystal report sebagai langkah awal dalam berkarir didunia IT Admin, IT Programmer, IT Konsultan dan IT Support.

OBJECTIVES

Setelah mengikuti pelatihan ini peserta diharapkan mampu untuk :

  1. Melakukan pembuatan laporan, desain laporan.
  2. Mengolah data dari database untuk dijadikan laporan.
  3. Bekerja dengan Text Object
  4. Membuat laporan dengan bentuk graphic
  5. Filtering, sorting and grouping
  6. Menggunakan formula pada laporan
  7. Menggunakan parameter untuk membuat laporan yang dinamis
  8. Membuat subreport, report alert, driil down report, Cross tab report

SYLLABUS

  • Introduction Of Crystal Report & It’s Benefit’s
    • Overview crystal report
    • Benefit of crystal report
  • Designing Reports
    • Toolbars
    • Start Page and Report Tabs
    • Design/Preview Views
    • Field Explorer
    • Report/Repository Explorers
    • Sample Reports
    • Section Expert
  • Interface Overview
    • Toolbars
    • Start Page and Report Tabs
    • Design/Preview Views
    • Field Explorer
    • Report/Repository Explorers
    • Sample Reports
    • Section Expert
  • Creating Basic Reports
    • Blank Report
    • Placing Fields on Reports
    • Previewing Field Data
    • Selecting/Sizing Fields
    • Aligning, Moving, and Using Guides
    • Customizing Layout Options
    • Creating Report Titles
  • Previewing, Saving, and Deleting
    • Saving Reports
    • Previewing Reports
    • Deleting Fields
  • Advanced Database Concepts
    • Using Oracle
    • Entering Oracle Queries
    • Linking Tables
    • Joins
    • Verifying Database Connections
  • Data Connections
    • Database Expert
    • Data Source Options
    • Oracle Connectivity
    • Oracle Connectivity With OLEDB
    • Access/Excel Connections
    • ODBC Connections
    • Selecting Database Objects
    • Database Object Types
  • Working with Text Objects
    • What is Concatenation?
    • Adding Text Fields
    • Concatenating Text and Data
    • Editing Concatenations
    • Creating a Form Letter
    • Formatting Fields
    • Special Fields
  • Basic Formatting
    • Template Expert
    • Page Margins and Orientation
    • Font and Alignment
    • Formatting Multiple Selections
    • Format Painter
    • Formatting Editor Options
    • Customizing Formatting Editor
    • Preview Formatting
  • Adding Graphical Elements
    • Inserting Lines
    • Border Styles and Colors
    • Drawing/Formatting Boxes
    • Inserting Pictures
  • Filtering Records
    • Case Sensitivity
    • Select Expert
    • Select Statements
    • And Statements
    • Or Statements
    • Editing Formulas
    • Formula Workshop
    • Help Menu Options
  • Grouping and Sorting
    • Insert Group
    • Insert Group Options
    • Keeping Groups Together
    • Group Tree
    • Reordering Groups
    • Grouping Multiple Fields
    • Changing/Deleting Fields
    • Record Sort Expert
  • Conditional Formatting
    • Conditional Highlighting
    • Reordering Highlight Conditions
    • Removing Highlight Conditions
    • Conditional Formatting Formulas
    • Formatting Groups
  • Running Totals
    • Running Total Fields
    • Running Totals by Group
    • Running Total Counts
  • Formula Overview
    • Formula Uses
    • Function Basics
    • Syntax Rules
    • Formula Workshop
    • Formula Editor
  • Manipulating Data with Formulas
    • Date Added
    • Date Add Arguments
    • Concatenated Formulas
    • Converting Dates to Text
    • Boolean Fields
    • Nested If-Then-Else Statements
  • Basic Parameters
    • Parameter Uses
    • Considerations
    • Characteristics and Options
    • Value Choices
    • Static List Parameters
    • Dynamic List Parameters
    • Exporting Data
    • Importing Data
  • Drill-Down Summary Reports
    • Starting a New Report
    • Grouping Using Formulas
    • Advanced Grouping Formulas
    • Summarizing Groups
    • Hiding Sections
    • Viewing Hidden Sections
  • Subreports
    • Subreport Uses
    • Linked vs. Unlinked
    • How Linked Subreports Work
    • Creating an Unlinked Subreport
    • Creating a Linked Subreport
    • Subreport Context Menu
  • Cross-Tab Reports
    • Elements and Features
    • Cross-Tab Report Creation Wizard
    • Rows and Columns
    • Summary Fields and Grid Styles
    • Resizing/Aligning Fields
    • Contents, Labels, and Column Options
    • Modifying Reports
    • Customizing Report Style
  • Report Alerts
    • Creating Alerts
    • Alert Name and Status
    • Setting Alert Conditions
    • Triggering Alerts
    • Conditional Alerts
    • On-demand Subrep
  • Charts
    • Standard Report Wizard
    • Manipulating Charts
    • Chart Options/Types
    • Data, Axes, and Options
    • Color Highlights and Text
    • Format Editor and Options
    • Arrange and Drill Down
    • Saving as Templates
  • Exporting Reports
    • Export Formats
    • Exporting to E-mail
    • Export Destinations
    • Exporting to Exce
    • Exporting to PDF
    • Exporting to HTML
    • Copying Report Objects
    • Exporting Report Definitions
  • Crystal Reports Settings
    • Layout Options
    • Database Options
    • Formula Editor Options
    • Reporting Options
    • Field Options
    • Font Options
  • Templates
    • Overview
    • Formattable/Unformattable Objects
    • Creating New Templates
    • Inserting Template Field Objects
    • Formatting/Moving Fields
    • Adding Special Fields
    • Graphics and Summary Info
    • Saving and Applying Templates

AUDIENCE TARGET (Basic and Intermediate Level)

  • IT/Technical Staff :
    Software Developer/Programmer, Software Consultant, System Analyst, System Administrator, Database Administrator, IT Support, IT administration
  • High School Graduate

DURATION :

2 Hari

TRAINING METHOD :

  1. 25% Theory
  2. 75% Practices (Case study)
  3. Dynamic and interactive training presentation

Course Leader :


Step By Step Membuat Laporan dengan Crystal Report

Schedule
Events IT:

IT Strategic Planning

Jakarta, 2 - 4 Juni 2020 54 clicks

ISO-IEC 20000 Foundation

Jakarta, 8 - 10 Juni 2020 61 clicks

IT Balanced Scorecard (IT BSC)

Jakarta, 8 - 10 Juni 2020 55 clicks
Training Service

Rose
rose@tds-solution.com
HP & WA : 0813 8201 2413

Zulfa
trainingservice01@tds-solution.com
HP & WA : 0857 7331 5631

Telp.: 021-2780 6606

Stats