THE ESSENTIALS OF CRYSTAL REPORTS®
In this seminar you'll learn...
How to take advantage of the full power of Crystal Reports by creating reports from scratch, and maintain total control over the look and feel of your reports
How to quickly apply style templates to your reports that´ll take them from drab to dazzling
How to use the built-in report wizards to create amazing reports with just a few mouse clicks
How to export your report as a Word document, Excel® spreadsheet, HTML page or one of several other file types
And much more
Businesses both large and small have at least one thing in common—and that´s data. Running effectively means that data has to work hard for you—and that´s where this incredible workshop comes in. In The Essentials of Crystal Reports, we teach you the steps for making your data "go to work"—and you don´t have to be an expert in databases to use it. You´ll learn to create reports that run the gamut—from complex reports containing huge amounts of information to simple reports that distill your information down to a single easy-to-understand summary. Stop being at the mercy of your IT department´s schedule when you need a report. Once you harness the business-reporting power Crystal Reports can supply, generating reports yourself is a whole lot easier!
WORKSHOP AGENDA
E-mail this Page
Program Hours: 9 a.m. – 4 p.m.
Session 1: Getting started with Crystal Reports
Crystal Reports is one of today´s most versatile reporting programs on the market. It provides the necessary tools to integrate raw data from database applications into useful, business-friendly reports. This session will highlight Crystal Reports´ capacity to illustrate relationships for analysis and interpretation, leading to successful business decisions. You´ll also learn ...What Crystal Reports can do for you—the different reports you can create
What´s new and different with today´s Crystal Reports
Step-by-step instructions for installation: What you need to know to install the tools you want
How to get a handle on the Crystal Reports user interface and how to customize it to meet your needs
Why there are different report design environments and the importance of each
Session 2: Data connectivity: Selecting your database for seamless Crystal Reports integration
Before you can begin to create a customized report, you must first be able to access your data, and that´s what this session is all about. You´ll discover how to connect to virtually any kind of database to get the information you need. You´ll also discover how to use the Database Expert to create data connections to not only existing databases but also to Excel files, text files and much more. In this session, you´ll learn ...What a relational database is versus a flat database—uncover the advantage of being able to join tables based on related data
Understand the different types of data sources that Crystal Reports can utilize
Step-by-step directions for connecting to common data sources such as Access, SQL Server®, Excel and many more
What to do when Crystal Reports doesn´t properly link your tables and it´s up to you to create links manually
What a View is and how to use one as the foundation for your report
Session 3: Creating different reports to display the information you need
This session will give you the opportunity to explore the various Wizards and then move right into using the Blank Report for more versatility. You´ll look at the different sections of a report and learn to group, sort and summarize your data for valuable output. You´ll discover ...How to use the different Report Wizards and what they can do for you
How to create a report from scratch and the added benefits of doing so
How to use the Record Sort Expert for customizing the order of your records
Group Expert: The importance of grouping and how to use it productively
How to create a summary report and other options for including summary information in your detailed reports
Session 4: Using formatting to create a professional and effective report
The layout and design of data can greatly impact the effectiveness of a report. This session will guide you through templates and numerous customization tools to get the look and feel you want for the professional report you need. You´ll learn ...How to modify the page orientation and margins of your report to adapt to the information you wish to display
How to quickly apply templates and the trick you can use if you don´t get the look you expected
Step-by-step directions to manipulate background colors to emphasize important data
How to snap objects into place using grids and guidelines for a consistent and professional appearance
The best methods to jazz up your reports by adding images, text boxes and other useful objects
How to use the Highlighting Expert to apply conditional formatting that will allow you to dynamically format objects based on the criteria you select
Session 5: Using the power of Crystal Reports: Hyperlinks, parameters, charts and formulas
Taking Crystal Reports to the next step of customization and efficiency is what this session is all about. You´ll use the Format Editor, Parameter Field, Chart Expert and Formula Workshop to take that advanced step needed to create complex or specialized reports. In this session, you´ll learn how to ...Use hyperlinks to link to Internet Web sites, e-mail addresses and files on your computer or network
Take advantage of the Formula Editor to create, edit and check formulas easily
Develop conditional formulas that involve "If ... Then ... Else" statements for better control of your information
Insert a chart into your report to graphically represent summarized data
Integrate Flash® files into your report to add an even greater level of professionalism, and wow those who view your reports
Session 6: Exporting and publishing your reports for easy access
Once you´ve created reports, it´s time to get that information out to the people who need it. Crystal Reports offers many options for file exportation and publishing. You´ll discover how to export reports to various formats and the value that each adds to your reports. You´ll find out ...How to export your report in different formats, and why page-based versus record-based formatting is important to understand
Why it´s vital to export to a Crystal Report format based on the functionality you wish to maintain
How to publish your report to your company´s Web server for Internet or intranet access
Important considerations you need to know when exporting your report using the HTML format
What format you should select if you plan on sending your report to others via e-mail
CEU Credits: 0.5
CPE Credits: 6
Field of Study: Computer Science
NASBA#: 107719
View our Seminars
Computer Skills
Business &
Professional Skills
Professional Skills
CALL TOLL FREE:
1-800-867-4340
1-800-867-4340
FIND A SEMINAR NEAR YOU
