How to insert database fields
Click the INSERT FIELDS button on the standard toolbar. The Insert Fields dialog box appears with the Database Field Tab active listing all of the fields in the chosen database(s).
2 Click the field you want to appear in your report.
3 Click the Insert button to place it in your report.
To speed the report building process, this dialog box remains on screen until you click the Close button. You can move the dialog box wherever you wish.
4 Click the Browse button to review the values in the selected field.
How to insert special fields
Seagate Crystal Reports allows you to insert Page Number,
Record Number, Group Number, Print Date, and Total Page
Count fields, among others, into your report easily.
To insert special fields, choose the SPECIAL FIELD command from the Insert menu. A submenu appears with the special fields available for use in your report. Search for Special Field commands in Seagate Crystal Reports online Help.
118 |
Seagate Crystal Reports User’s Guide |
Choose a command to insert the desired special field.
Each special field is inserted into your report as an object. An object frame appears that you can place into the desired position on your report.
NOTE: If you want to change the formatting of any of the inserted objects, right-click the object and click the OBJECT PROPERTIES
button on the supplementary toolbar. The Format Editor appears where you can make the desired changes. See Formatting, Page
231.
How to insert a page n of N field
You can use special fields and text objects to create a Page n of N field where n is the current page number and N is the total number of pages in the report.
Insert a text object where you want the field to appear in the Page Header or Page Footer section of your report. See How to insert text objects, Page 120.
Type in the word “Page” followed by a space.
NOTE: The text object must be in edit mode for you to be able to enter text. See How to work with text objects, Page 216, for more
information on the text object edit mode.
!Insert a Page Number field in the text object using the PAGE NUMBER command on the Insert|Special Field menu. (Search for Page Number command in Seagate Crystal Reports online Help.)
" Type in a space, the word “of” and another space.
Reporting 101 |
119 |
#Insert a Total Page Count field using the TOTAL PAGE COUNT command on the Insert|Special Field menu. (Search for Total Page Count command in Seagate Crystal Reports online Help.)
Now, when you print the report the program will print “Page n of
N” for each page of your report.
How to insert text objects
Click the INSERT TEXT OBJECT button on the standard toolbar.
An empty object frame appears.
Position the text object where you want it to appear in the report.
●Click once on the border of the text object to select it for resizing and moving.
●Double-click inside the text object to select it for editing. The Design Tab ruler changes to a text object ruler sized to the dimension of the selected object. To the left, a tab indicator appears.
Left-aligned tab.
Right-aligned tab.
Center-aligned tab.
Decimal-aligned tab.
Drag to set the |
Drag to set the |
|||
left margin. |
right margin. |
|||
|
|
|
|
|
|
|
|
|
|
Once you have chosen the desired tab, click the position on the ruler where you want to insert it.
The ruler allows you to add indents and align text within the text object. By clicking the tab indicator, you can cycle through the four tab options available.
120 |
Seagate Crystal Reports User’s Guide |
How to use a database field in a text object
The primary function of a text object is to hold text. However, text objects can hold database fields as well, making them ideal for creating custom form letters.
Insert a text object in your report.
2 Type in the text and spaces that you want to appear before the first database field (if any).
!Click the INSERT FIELDS button on the standard toolbar. The Insert Fields dialog box appears with the Database Tab active.
"Highlight the database field you want to insert and drag it into the text object. As you move the drag and drop cursor over the text object, the program displays a movable insertion point. See Cursors, Page 64.
5 Drag the object so the insertion point is located where you want the database field to appear and drop the field.
How to insert a picture
Often when you are developing reports you would like to include a picture. For example, you may wish to put a company logo into the header of a report.
Click the INSERT PICTURE button on the supplementary toolbar. The Open dialog box appears.
Reporting 101 |
121 |