Lesson 5: Hiding Model Items

New: 5 December 2005

Model items, such as Guid fields, are automatically created when you generate the model; but they might not be useful for creating reports. In such cases, you can hide the model item so that Report Builder users do not see it when they build reports using the model. In this lesson, you will learn how to hide a model item.

To hide a model item

  1. In the Tree view, select the Sales Order entity.

  2. In the List view, select the Rowguid attribute.

  3. In the Properties window, select the Hidden property.

  4. In the property's drop-down list, select True.

  5. On the File menu, select Save All.

Next Steps

You have successfully hidden an attribute. Now, when the AdventureWorks model is used in Report Builder, the Rowguid attribute will not appear. Next, you will specify the field width used when the attribute is added to a report. See Lesson 6: Specifying the Default Width of a Field.

See Also

Tasks

Tutorial: Refining a Report Model in Model Designer

Other Resources

Model Designer Object Properties
HiddenFields Collection (Model Designer)

Help and Information

Getting SQL Server 2005 Assistance