Lesson 2: Adding Fields and Entities to a Tabular Report (Report Builder 1.0)
In this lesson, you will add fields and entities to the report layout. The available entities are listed in the Explorer pane. Each entity contains at least one field, typically more. Fields and entities provide Report Builder and the report server with the information needed to retrieve the data from the AdventureWorks database.
To add entities and fields to the report layout
In the Explorer pane, select the Customer entity from the Entities list.
Drag the entity to the Drag and drop column fields area in the design area.
The Account Number and Customer Name fields are added to the report layout.
In the Entities list, select Sales Orders.
In the Fields list, select the #Sales Orders field.
Drag the field to the Customer tab.
You have successfully created a report displaying four columns. Notice that your data does not appear in the report yet. In Report Builder design mode, you are working with a representation of the data. In the next lesson, you will group the data within the report. See Lesson 3: Grouping Data (Report Builder 1.0).