How to Set Up the Work Surface in Report Builder 3.0

Report Builder is a small report design tool that is installed on your report server as part of Microsoft SQL Server. Similar in look and feel to Microsoft Word, it is a comfortable environment for users of other Microsoft Office tools. You can create simple or complex reports very quickly through wizards and an intuitive interface. If you have SQL and scripting skills you can customize SQL queries within Report Builder, but it is often just as quick to follow the UI and use the wizards.

When you use a Template, the ruler and display settings are already set up. However, you can quickly change the page setup.

1. In the View tab, clear the check boxes for Properties and Grouping. (This opens up more real estate.)
2. Select Ruler.

   

3. Right-click on the blue area on the Report Design Surface (outside the report document), and select Report Properties.

   The Report Properties window displays.

4. Set the units and dimensions appropriately for your report.