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:

  • Table
  • Text Box
  • Image
  • Line
  • Rectangle
  • Chart
  • Map

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

  1. 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.

    ssrs_ssdt_addtable

    You can also add a table to the report from the design surface. Right-click the design surface and select Insert > Table.

  2. In the Report Data pane, expand the AdventureWorksDataset to display the fields.

  3. Drag the [Date] field from the Report Data pane to the first column in the table.

    Important

    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.

  4. Drag the [Order] field from the Report Data pane to the second column in the table.

  5. Drag the [Product] field from the Report Data pane to the third column in the table.

  6. Drag the [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 [Qty] field expression.

    ssrs_tutorial_addcolumn

  7. Add 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. rs_BasicTableDetailsDesign

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.

    ssrs_ssdt_preview

The following diagram shows part of the report in Preview view.

Preview, Detail rows of table with five columns

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.

Note

From the File menu, select Save All to save the report.

Next steps

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).

See also

Tables (Report Builder and SSRS)
Dataset Fields Collection (Report Builder and SSRS)