Lesson 6: Specifying the Default Width of a Field

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.

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.

Community Additions