Inserting Report Fields

Usually, the most important information in a report comes from the database tables. Each table contains one or more columns of data. The database columns make up the fields in the query. When you place fields in the layout, their values print in the report.

To insert fields in the report layout:

Drag a field from the Object Explorer into the desired report layout section (see Using the Object Explorer).
Insert the fields from the Database tab in the Report Fields dialog box.
To access the Report Fields dialog box, click on the Object Toolbar, select Insert, then Field, or right-click Fields in the Object Explorer and select Insert.
When you insert fields from the Report Fields dialog box, you can:
- Drag a field from the Database tab to the desired area in the report layout.
- Place your cursor in the desired section in the layout, click the field in the Database tab, and click Insert. The field appears in the upper left-hand corner of the layout section in which it is inserted.

After you insert a field in the report layout, you can change the properties of the field if desired. To change the properties of a field:

Select the field in the layout and change the properties in the Property Explorer (see Using the Property Explorer).
Double-click the field in the layout.
Right-click the field and select Object Properties.
Tip:
When you insert a field into the report layout, the field changes to the actual width of the field, along with the field name. If the field is too wide or narrow, you can resize it with the "handles." Be aware, however, that making a field narrower might result in truncated data.
Tip:
To remove a field from the layout area, click it and press the [Delete] key. SQR Production Reporting Studio removes the field from the layout, but leaves it in your query.