Seagate Crystal Reports allows you to limit or restrict the records that are to be included in a report. In this section you will learn how to:
For example, it may be useful to have a customer list that only lists customers from the USA. The sample data contains records from the United States and International customers. It is easy to restrict lists like this using the Select Expert. See Record Selection.
When you scroll through the report, you will see that it contains information for customers from many different countries. In this step, you will limit the number of countries displayed to the USA.
The Choose Field dialog box appears.
This dialog box lists all the fields currently in the report in the Report Fields section and then lists all fields that are available from each table in the database fields section.
Select all records where a customer's country is
You complete the sentence with the condition you want the program to use when selecting records for your report. Right now the condition is any value, which implies there is no restriction on the record selection.
A new box appears on the right. The dialog box sentence now reads:
Select all records where a customer's country is equal to
All that you need to complete the sentence is the value USA.
Select all records where a customer's country is equal to USA
The Change in Record Selection Formula Detected dialog box appears.
Congratulations! You have started formatting your report and have added selection criteria to it. More than that, you have learned how to manipulate your data. By now, you have a good idea of the powerful kinds of reports you can prepare.
Now that the report contains only records from the USA, displaying the Country field in the body of the report is not necessary. You can delete this field before continuing.
That is all it takes to delete fields from the report.
The report should now look similar to this:
Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com |