Starting Vocational Training From 1-May-2024 Get Detail

Crystal Report

Crystal Report

Crystal Reports is a business intelligence application, currently marketed to small businesses by SAP SE.It is used to design and generate reports from a wide range of data sources.


Sensible Contact Quick Contact Call a Course Adviser for discussing Curriculum Details Sensible Computers Customer Care +91 93013-51989

Syllabus

  • Overview of Crystal Reports and its purpose
  • Features and benefits of using Crystal Reports
  • Installing and setting up Crystal Reports
  • Creating a new report
  • Connecting to a data source (SQL Server, Oracle, Excel, etc.)
  • Exploring the Crystal Reports interface
  • Basic report structure (Report Header, Page Header, Details, Footer)

  • Adding and formatting fields
  • Inserting text objects, images, and special fields (date, time)
  • Grouping and sorting data
  • Using the Record Sort Expert

  • Applying filters using the Select Expert
  • Creating parameter fields for dynamic filtering
  • Using formulas for conditional data selection

Formatting Reports

  • Formatting text, numbers, and date fields
  • Conditional formatting using formulas
  • Adding borders, colors, and alignment to enhance report presentation

  • Introduction to the Formula Workshop
  • Creating basic formulas for calculations
  • Using built-in functions (math, string, date functions)
  • Writing conditional formulas (If-Then-Else statements)

  • Creating group sections in reports
  • Adding summary fields (SUM, AVG, COUNT, etc.)
  • Using the Group Tree for navigation
  • Charts and Graphs

    • Adding charts to reports (bar, pie, line charts)
    • Customizing chart appearance and data labels
    • Creating dynamic charts based on report data

  • Understanding subreports and their use cases
  • Creating linked and unlinked subreports
  • Embedding subreports within main reports
  • Exporting reports to different formats (PDF, Excel, Word)
  • Configuring report settings for printing
  • Setting up page layout and print options

  • Using cross-tab reports for summary tables
  • Applying running totals and percent calculations
  • Implementing dynamic report sections (hide/show)
  • Using Crystal Reports with programming languages (e.g., C#, VB.NET)

Creating a complete business report from scratch, applying all the learned concepts (e.g., sales report, inventory report, or employee performance report).