Crystal Reports training - 2 days - private courses from £1450 + vat
Crystal Reports training uk
This Crystal Reports training course will teach Students the basics of report creation including sorting, grouping, linking, basic formula creation, working with report experts and how to distribute reports to other users.
This Crystal Reports training course is designed for users with little or no experience with Crystal Reports but who have the need to generate reports based on data available to them.
Crystal Decisions Crystal Reports Training Course Objectives
Upon successful completion of this crystal reports training course, students will be able to:
- Plan the needs for your report including data as well as appearance.
- Become familiar with components of the Crystal Reports application window.
- Create reports based directly on database information, use a report expert or create a copy of an existing report.
- Add, modify and remove report objects such as data fields, text objects, file information, graphics or decorative lines and boxes.
- Format the appearance of your report using font, colour, border and number choices.
- Change the selection criteria and sort order of your data.
- Create subtotals, grand totals and summaries for your report data.
- Create, edit and delete formulas. Understand Crystal's formula language.
- Understand linking concepts then create and modify your own links.
- Identify and control Crystal's report sections.
- Distribute your reports to those who need the information through a variety of methods.
Crystal Reports Training Course Content
Overview
- Examine the application's capabilities
- Think about the steps necessary to create reports
- Review reports and databases to be used in class
- Modify the program default settings
- Use help
Creating Simple Reports
- Identify the sections of the report
- Create a new report
- View your report as it will print
- Format your report by changing the size and position of the fields
- Enhance your report by adding a report title and changing the font attributes of your labels
- Add page numbers and other document information as well as a company logo or other graphics in your report
- Save your report
Sorting and Selecting Records
- Sort records
- Use the Select Expert to limit records
- Add an additional selection criterion using the "And" statement
- Modify composite formulas and the selection criteria statement
Grouping and Summarizing
- Define a single level group
- Define a multiple level group
- Modify grouping options
- Insert subtotals and grand totals
- Insert summary fields
- Insert percent of the total fields
- Insert grand total summary fields
- Use Top N/Sort Group Expert
Parameter Fields
- Understand Parameter fields
- Creating Parameter fields – Free Text Entry
- Creating Parameter fields –To Select Records
Using the Report Expert
- Create new reports using the Standard Report Expert
- Create new reports using the Mailing Labels Report Expert
- Edit a report created using an Expert
Linking
- Understand relational database basic concepts
- Create links using the Visual Linking Expert
- Examine Link Options
- Look at the difference between PC and SQL links
Creating Formulas
- Understand Formula Components
- Create new formulas using the Formula Editor
- Make changes to formulas
- Create and use String formulas
- Create and use Date functions
- Work with summary formulas
- Create and use If-Then-Else functions
Formatting Sections
- Review sections
- Resize sections in Design view
- Use the Section Expert
- Create Summary and Drill Down reports
Distributing Data
- Identify exporting options
- Export a report into office suite applications
- Create a report using spreadsheet data
- Discuss Web browser options to view reports on-line
Crystal Reports Course Prerequisites
For this Crystal Reports Training course:
- Some previous use of mail merge type documents or access importing would be useful but not essential.
- A basic knowledge of relational data concepts is also recommended.
Crystal Reports Training Recommended Reading
Crystal Reports 10: The Complete Reference - George Peck – buy from amazon
Crystal Reports 10 for Dummies - Allen G Taylor – buy from amazon
Crystal Reports 9 Standard Full Product – buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Microsoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.