|
Lesson 1
Opening the Extreme database
This lesson shows you how to open the example database that ships with
Crystal Reports. From that database, all the lessons are built. You do
not have to have the extreme database to follow the lessons. We also show
you how to use the Explorer to locate your own database.
Lesson 2
Inserting fields into a report
Inserting fields is where most beginners get stuck. Using the Extreme database,
we show you how to find the correct tables and the fields in the tables
and to make sure the are linked so that the field data appears in the report.
Lesson 3
Previewing a report
After you add fields to the report, you will want to take a look at the
result. Previewing a report gives you a WYSIWIG view. Crystal Reports
automatically
stops at 500 records in the preview so you do not have 5 ga-zillion records.
Lesson 4
Saving a report
Making sure the hard work is saved and can be retrieved is the subject
of this lesson.
Lesson 5
Opening a saved report
The report is saved safely to disk. The next step is retrieving it.
Lesson 6
Adding More Fields to the report
Now that you have a report, you are certainly going want more fields. But,
you may to rearrange the layout to get them
Lesson 7
Browsing a Field to see to see the data type
Check the data in the field you have selected to make sure it is what you
expect.
Lesson 8
Moving report objects
Move fields and other objects exactly where you need them
Lesson 9
Adding a header to the report
Headers make your report look like a professional report
Lesson 10
Inserting special fields
Crystal has a series of fields, such as page number, date and time that
are are already created for you that you can add to the report.
Lesson 11
Sorting Records
Crystal can sort record in several ways.
Lesson 12
Creating and inserting a group
Groups are a way of displaying your data in ways that sorting alone cannot.
Lesson 13
Inserting sub/grand totals
Create detailed number driven reports with subtotals by groups and then
add a grand total.
Lesson 14
Formatting Numbers
Add the right format to the numbers in the report.
|
Lesson 15
Formatting dates
Get the date format right, too.
Lesson 16
Formatting report sections
After creating a report, you can add formatting to the individual sections,
too.
Lesson 17
Inserting a running total
A new feature of Crystal 8 is the ability to add a running to total to
a list of numbers.
Lesson 18
Creating a Top N sort
A top N sort is a way of locating my the values you specify
Lesson 19
Inserting a chart
See your data in graphic format
Lesson 20
Price extension formula
Create a formula that calculates a value from the values in other fields.
Lesson 21
Date Math
Calculate the time in days between two dates
Lesson 22
Record Selection
Learn how to exclude or include specified records in the report
Lesson 23
Report Expert
Use the Report Expert to build a report from scratch
Lesson 24
Auto-formatting
Build a report and let Crystal add formatting for you.
Lesson 25
Adding OLE logos to a report
OLE (object linking and embedding) objects can be linked to a report so
that if the object is edited the report automatically reflects the change!
Lesson 26
Hyper-links
HTML links can be created in a report
Lesson 27
Link to Excel
Linking report data to an Excel spreadsheet is easy and adds another analysis
tool.
Lesson 28
Sub-reports
Insert a sub-report into a report, very cool
Lesson 29
If-then-else formula
Create formulas that have intelligent branching
Lesson 30
Adding a Parameter field
Create a report that adds user input that you design
|