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
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    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