Crystal Reports

Crystal Reports


    Crystal Reports Course Content :

    1. Overview of Crystal Reports

    • Formatting and summarizing data
    • Filtering, sorting and grouping data
    • Customizing reports with business logic
    • Connecting to SQL Server, Oracle and Access databases
    • Adding charts and subreports to a report

    2. The Crystal Report Writer

    3. Writing a basic report

    • Selecting a format
    • Adding text and fields
    • Connecting to remote data sources
    • Configuring the reporting environment

    4. Formatting and styling

    • Tailoring sections within a report
    • Annotating header and footer fields
    • Designing fields for quality presentations
    • Adding color, borders and pictures
    • Highlighting data with Highlight Expert

    5. Linking Crystal Reports to Data

    6. Connecting to popular data sources

    • SQL Server
    • Oracle
    • Access
    • Web logs
    • Reporting from stored procedures and views

    7. Establishing data connections

    • Creating a connectivity checklist
    • Configuring ODBC and OLE DB
    • Integrating SQL commands in a report

    8. Interpreting Structures and Retrieving Data

    9. Navigating complex data

    • Deciphering data structures
    • Identifying data relationships

    10. Gathering the right data

    • Merging data from multiple tables
    • Building business queries
    • Optimizing data retrieval

    11. Combining Powerful Report Techniques

    12. Organizing and summarizing reports

    • Sorting user sort control and grouping
    • Grouping with formulas
    • Summary and Rolling Total fields
    • Using Report Alerts

    13. Building advanced reports

    • Embedding linked and unlinked subreports into reports
    • Creating crosstab and drill-down reports
    • Designing dynamic and cascading prompts
    • Multipass reporting, Hyperlinking Reports and Multilingual Reports
    • Achieving reusability with templates

    14. Visualizing complex data

    • Simplifying data with charts and graphs
    • Organizing fields into sections
    • Adding, merging, suppressing sections

    15. Programming Data Functionality

    16. Coding in formula language

    • Working with variables and operators
    • Deciphering formula syntax
    • Adding and modifying formulas with the Formula Workshop
    • Calling and working with functions
    • Sharing formulas with the Repository

    17. Writing effective formulas

    • Building if/then/else statements
    • Converting and comparing data
    • Debugging the code
    • Employing the Formula Workshop

    18. Converting to Basic Syntax

    • Writing formulas with Basic Syntax
    • Laying a foundation for complex reporting logic

    19. Deploying Reports to the Internet, Intranets, Visual Basic and .NET

    20.Deploying Crystal Reports

    • Deciding among Push, Pull, Static and Dynamic reports
    • Migrating to production by switching databases
    • Determining when to use the Crystal Reports Server

    21. Publishing reports to a Web site

    • Exporting reports to HTML
    • Publishing to

    22. Integrating into custom applications

    • Adding Crystal Reports to Visual Basic and .NET
    • Exploring application development options with Crystal Reports

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies


    This web site or team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information


    +91 9989754807