Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0


Topics include: creating a list report, displaying data in a report, grouping report data, building formulas, formatting reports, enhancing reports, creating and modifying pie charts, and distributing data.


 
Course Outline

Some database programs have limited reporting tools, or the user may not have sufficient programming or SQL knowledge to create some reports. This course is intended to introduce the use of Crystal reports to produce reports from almost any database data (for example, Microsoft Access).

This course is classroom style instruction: Instructor-led, hands-on training.

Creating a List Report
Set Default Report Settings
Build the Report
Preview the Report
Add a Report Title
Align Fields

Displaying Data in a Report
Find Data
Sort Data
Filter Data by Single Criteria

Grouping Report Data
Insert a Group
Add Summaries
Change Group Options
Add an Additional Group
Format a Group Header
Filter by Group
Create a Top N Sort Group

Building Formulas
Write a Formula
Edit a Formula
Group by Formula
Delete a Formula
Build a Filter by Multiple Criteria
Modify a Filter with to Create an OR Condition
Create a Parameter Field
Write a Formula that Incorporates Null Fields

Formatting Reports
Remove White Space
Insert Page Header/Footer Data
Add Borders and Lines
Change the Background Colour
Change the Margins

Enhancing Reports
Create a Watermark
Add Bulleted Lists
Modify Format Based on Date Value
Conditionally Suppress Data
Insert Hyperlinks
Hide Report Objects

Creating and Modifying Pie Charts
Create a Pie Chart with a Drill-down
Change the Chart Title
Format a Chart
Present a Chart by Group

Distributing Data
Export to Excel
Export to an Access Database
Create a Report Definition
Create Mailing Labels


Prerequisites & Certificates
Pre-Requisites

Basic Windows knowledge and an understanding of database concepts.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion


Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 621 times.