Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

  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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.