Database Reference
In-Depth Information
Important:
You are practicing administrator-level tasks in this topic; therefore, you need administrator-level
privileges. The easiest way to achieve this is to remember to always right-click a menu item, select Run as
Administrator, and then answer Yes to access administrator-level privileges. In Windows 7 and Vista, logging
in with an administrator account is not enough. For more information, search the Web for the keywords
Windows 7 True Administrator and User Access Control.
2.
open the Publications Industries solution you have been working on throughout the
book using the File
➤
open Project/Solution menu item.
3.
Locate and select the SLn file
C:\_BISolutions\PublicationsIndustries\
PublicationsIndustries.sln
.
4.
Click the open button at the bottom of the dialog window to open the solution.
add a project to the Current Solution
1.
Add a new project to the solution by selecting File
➤
Add
➤
new Project from the
main menu at the top of Visual Studio. An Add new Project dialog window appears
(Figure
16-15
).
2.
Select the Business Intelligence
➤
Reporting Services template category on the
left of the dialog window. Then select the Reporting Server Project option from the
center of the dialog window (Figure
16-15
).
3.
name the Project PubsBIReports at the bottom of the dialog window and click oK to
add the new project to your current solution (Figure
16-15
).
4.
Use the View
➤
Solution Explorer menu item to display the Solution Explorer
window.
Create a Shared Data Source
We need a way to connect to the data warehouse to access our report data. Let's create a shared data
source.
1.
Add a new shared data source by right-clicking the Shared Data Sources folder and
selecting the Add new Data Source option in the context menu (Figure
16-16
).
2.
When the Shared Data Source Properties dialog window appears (Figure
16-17
),
type
DataSourceDWPubsSales
in the name textbox.
3.
In the Type dropdown box, select Microsoft SQL Server (Figure
16-17
).
4.
Click the Edit button next to the Connection String textbox and type in the name of
your SQL Server, as shown in Figure
16-17
.
5.
Using the dropdown box beneath the “Select or enter a database name” radio
button, select the DWPubsSales database (Figure
16-17
).
6.
Close both dialog windows by clicking the oK buttons to complete the creation of the
shared data source.