To Create a New Report without a Template

To Create a User Designed Report without a Template

From the eSite menu, select Reports—User Designed Reports—Call Report Builder. The Microsoft Report Builder opens.
From Report Builder, from the Select a source of data for your report list in the Getting Started pane, select the report model. The blank report form appears in the work area.
From the Explorer pane, from the Fields list, drag and drop the fields of your choice onto the report and position the fields as desired. (The available fields are based on the report model you selected).
To add filters to the report:

From the Report Builder toolbar, click the Filter button.

From the Filter Data window, from the Fields list, drag and drop each field you want to use as a filter to the work area within the window.

For each filter you added, right-click the field in the work area and, from the drop-down list that appears, select Prompt. A question mark icon next to the field indicates you will be prompted for the filter value when you run the report.

Click OK.

Note

If you add filters to the report, you will not have the option to run the report from eSite. You will have to select the filters and run the report from within Report Builder.

From the File menu, select Save As and save the report to the SSRS server.
To run the report, from the Report Builder toolbar, click the Run Report button. If you added filters, you will be prompted to complete the filter values. Click View Report.