Design the Report

After adding a data set, you can design the visual representation of your report.

Report Builder gives you many options of how the data can be represented on a report. You can use tables, lists, matrices, charts, etc. You can also insert text boxes, lines, images, and other graphics. In this tutorial, we will create a simple report that displays the data in a table format.

To insert a table into the report:

1. In Report Builder, make sure you have the main design view displayed.

2. Right-click in the report's empty space and then click Insert > Table.

3. Expand the Datasets folder in the left pane and then expand your data set, so you can see the fields included in the set.

4. Drag a data field to a desired column in the table. Repeat for other fields.

To test the report, click Run or press F5. To return back to the designer, click Design.

When you are satisfied with how your report looks in the Report Builder, you can save it in the database as follows:

1. In Report Builder, click File > Save As.

2. In the Save As Report dialog, select your report server URL in the drop-down list at the top of the dialog.

3. Double-click the Custom reports folder, type a name for your report and click Save.

Note: You can create sub folders to section the reports as you like. To set a particular order for your reports, you can add numbering to the report name in form of ####.REPORT_NAME, such as: '0001.My Custom Report'. This can also be used with subfolder names.