Database Reference
In-Depth Information
7.
Add a table to your report by clicking the Table icon in the Toolbox and dragging it to
the Report Designer surface (Figure
16-24
).
8.
In the new table, click the first column of the Data row. When the Smart Tag icon
appears, click it to display the context menu. When the context menu appears, select
the Title data field, and it will be added to the report table (Figure
16-25
).
9.
Repeat this process to add the orderDate data field to the second column of the data
row and to add the Total_for_That_Date_by_Title data field to the third column.
10. Use the Preview tab and review your current report design. It should look similar to
the one shown in Figure
16-26
.
11. Use the Design tab to change the names of the columns to Title
,
order Date
,
and
Sales Qty, as shown in Figure
16-27
.
12. Add a Text Box to the report and type in
Sales Qty by Titles
, as shown in Figure
16-28
.
13. Use the Format toolbar to format both the table and textbox to your liking.
14. once you have completed your formatting, take a look at the report using the
Preview tab. Continue adjusting it until you are satisfied with the look of your report.
In this exercise, you created a new SSRS project and added it to a current solution. You then added a
data source, a data set, and a simple report to the project. now we can deploy the report to the Reporting
Services web service so that users can access the reports either through the SSRS web service or more
appropriately through the SSRS web application.
Deploying the Report
To deploy the report to the SSRS web service, you need to configure the Visual Studio project appropriately. This
can be done by accessing the property pages shown in Figure
16-31
. To access this property sheet, right-click the
Project icon in Solution Explorer and select Properties from the context menu.
