Lesson 4: Adding a Table to the Report (Reporting Services)
After the dataset is defined, you can start designing the report. You create a report layout by dragging and dropping report objects from the Toolbox pane to the Design surface. Some of the types of report objects include:
- Text Box
Items that contain repeated rows of data from underlying datasets are called data regions. After you add a data region, you can add fields to the data region. A basic report will have only one data region. You can add additional ones to display more information such as a chart.
Add a table data region and fields to a report layout
Select the Toolbox tab in the left pane of the Report Designer. With your mouse, select the Table object and drag it to the report design surface. Report Designer draws a table data region with three columns in the center of the design surface. If you don't see the Toolbox tab, select View menu > Toolbox.
You can also add a table to the report from the design surface. Right-click the design surface and select Insert > Table.
In the Report Data pane, expand the AdventureWorksDataset to display the fields.
[Date]field from the Report Data pane to the first column in the table.
When you drop the field into the first column, two things happen. First, Report Designer displays the field name, known as the field expression, in brackets:
[Date]in the data cell. Second, it adds a column label to the header row, just above the field expression. By default, the column label is the name of the field. You can select the column label and type a new value if you want to change it.
[Order]field from the Report Data pane to the second column in the table.
[Product]field from the Report Data pane to the third column in the table.
[Qty]field to the right edge of the third column until you get a vertical cursor and the mouse pointer displays a plus sign [+]. When you release the mouse button, a fourth column is created for the
[LineTotal]field in the same way, creating a fifth column. The column label is added as "Line Total". Report Designer automatically creates a friendly name for the column by splitting "LineTotal" into two words.
The following diagram shows a table data region that has been populated with these fields: Date, Order, Product, Qty, and Line Total.
Preview your report
Previewing a report enables you to view the rendered report without having to first publish it to a report server. Preview your report frequently while designing it. By doing so, you validate the design and data connections allowing you to correct errors and issues as you go.
To preview a report
Select the Preview tab. Report Designer runs the report and displays it in the Preview view.
The following diagram shows part of the report in Preview view.
Look at the Date and Line Total values. In the next lesson, you're going to learn how to format them to display more neatly.
From the File menu, select Save All to save the report.
You've successfully added a table data region to your report, added fields to the data region, and previewed your report. In the next lesson, you're going to learn how to format column headers and field expressions. Next, continue with Lesson 5: Formatting a Report (Reporting Services).