Sign Up for Seminars from Over 600 Providers
Find a Seminar
The Essentials Of Crystal Reports®
Pick a Date & Sign Up
Bring Seminar On-site- This seminar may be brought
on-site to your location for
groups of 10 or more.
Provider:
SkillPath Seminars
Topic(s):
Computers & Software > Programming & Software
Who Should Attend?
Those who work with data and need to make reports
Full Seminar Description
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!. Fee per person: $199; $189 each for four or more.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
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 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
Sponsor Background:
SkillPath's seminars, videos, books and software packages offer expert guidance on everything from how to get the most from the latest version of your favorite computer programs to how to manage people, time, projects or priorities and just about everything in between. At current count, SkillPath's curriculum includes more than 60 different seminar topics and nearly 200 book, audio and video titles.SKILLPATH GUARANTEES RESULTS If you're not happy, SkillPath is not happy. Go back to work and apply the new techniques you learned in any of SkillPath's seminars. If you're not absolutely delighted with the results you achieve, write to them right away. They will issue you a refund or arrange for you to attend another SkillPath seminar without paying another penny. That's the SkillPath Guarantee!
Cancellation Policy: Cancellations received up to five business days before the workshop are refundable, minus a registration service charge, which you may apply toward any future workshop. After that, cancellations are subject to the entire workshop fee, which you may also apply toward a future workshop. Please note that if you don’t cancel and don’t attend, you are still responsible for payment. Substitutions may be made at any time.

