Database Reference
In-Depth Information
Creating the excel report
1. open Excel. You can do so by clicking the start button and selecting All Programs
➤
Microsoft office
➤
Microsoft Excel 2010.
Important:
Remember to right-click the menu item, select Run as Administrator, and then answer Yes to
close the UAC.
2. go to the Data tab, as shown in figure
15-2
.
3. Create a new data source using the from sQl server option (figure
15-2
).
4. specify the name of your sQl server in the Data Connection wizard (figure
15-4
).
5. select the DwPubssales database from the dropdown box shown in figure
15-5
.
6. select the view called vQuantitiesByTitlesDate (figure
15-5
).
7. select a pivot table report (figure
15-8
). An empty pivot table will be created.
8. Using the PivotTable field list window, drag and drop or select the checkboxes to
make your report look like figure
15-11
.
Figure 15-11.
The report for Exercise 15-1
save Your report
You have created you first report for the Publications industries Bi solution. it is time to save your work in a
subfolder within the Publications industries Visual studio solution folder.
1. save your report using Excel's file
➤
save As menu item. when you do, a dialog
window appears similar to figure
15-12
.