1 out of 1 rated this helpful - Rate this topic

Lesson 5: Hiding Model Items

SQL Server 2005

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

In the Tree view, select the Sales Order entity.
In the List view, select the Rowguid attribute.
In the Properties window, select the Hidden property.
In the property's drop-down list, select True.
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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Lesson 5: Hiding Model Items

Tasks

Other Resources

Help and Information

Community Additions