Share via

Lesson 6: Specifying the Default Width of a Field

New: 5 December 2005

When Report Builder users add a field to their report, the width of the field is the same width as the corresponding column in the database by default. To make it easier for Report Builder users to create their reports, you can change the default width of a field by changing the Width property in the model. In this lesson, you will change the default width of a field.

To specify a default field width

  1. In Tree view, select Sales Order.

  2. In List view, expand the Total Due field.

  3. Select the Sum Total Due field.

  4. In the Properties window, locate the Width property and then type 15.

    This specifies that, by default, up to 15 characters can appear on a line within the column. If the first line contains more than 15 characters, the contents wrap to the next line within the column.

  5. On the File menu, click Save All.

Next Steps

Now, when the Sum Total Due field is added to the Report Builder design area, it will be 15 characters wide when displayed. In the next lesson, you will format a field. See Lesson 7: Specifying the Default Format of a Field.

See Also


Tutorial: Refining a Report Model in Model Designer

Other Resources

Working with Model Designer
Model Designer Object Properties

Help and Information

Getting SQL Server 2005 Assistance