Create a New Dataset using the Query Designer 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.

You can use the Query Designer in Report Builder to specify the data that you want to use in a report. Use the query Designer to create and modify datasets.

If you want to add elements and format them, please refer to the Report Builder online help. In the Search tab, type "Tutorials" and select List Topics for a great selection of help for adding and editing items within the Report Builder design surface.

1. In the Report Data pane, right-click Datasets .
2. Click Add Dataset.
3. Name the dataset, select Use a dataset embedded in my report.
4. Click Query Designer.