Lesson 5: Hiding Model Items

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 properties drop-down list, select True.

  5. On the File menu, select Save All.

Next Steps

You have successfully hidden an attribute. Now, when the AdventureWorks2008R2 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.