Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Posted Oct 11, 2006

Procedure: Open the Sample Report Server Project

By William Pearson

Objective:

Use this procedure to locate and open the AdventureWorks Sample Reports project that ships with MSSQL Server Reporting Services 2005.

To begin, we’ll launch the SQL Server Business Intelligence Development Studio.

1.  Click Start.

2.  Navigate to, and click, SQL Server Business Intelligence Development Studio, as appropriate.

The equivalent on my PC appears as depicted in Illustration 1.


Illustration 1: Launching SQL Server Business Intelligence Development Studio

We briefly see a splash page that lists the components installed on the PC, and then Visual Studio .NET 2005 opens at the Start page.

3.  Close the Start page, if desired.

4.  Select File -à Open from the main menu.

5.  Click Project / Solution … from the cascading menu, as shown in Illustration 2.


Illustration 2: Selecting a New Project

The Open Project dialog appears.

6.  Browse to the AdventureWorks sample reports folder.

The reports are installed, by default (and, therefore, subject to be installed in a different location on our individual machines), in the following location.

C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples\AdventureWorks Sample Reports

7.  Select the AdventureWorks Sample Reports.sln file within the sample reports folder, as depicted (circled) in Illustration 3.


Illustration 3: The Open Project Dialog, with Our Selection Circled ...

8.  Click Open.

The AdventureWorks Sample Reports solution opens, and we see the various objects within appear in Solution Explorer, as shown in Illustration 4.


Illustration 4: The Solution Opens within BI Development Studio ...



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
DB2 Forum
Topic By Replies Updated
tables get lock during backup in db2 v9.5 Hamsoo 0 May 8th, 01:03 AM
Query to Pull Last 7 days records from a table vgoushik 0 March 20th, 06:05 PM
DB2 Visual studio addin: ANSI/Unicode problem 10Pints 0 October 5th, 02:08 AM
Things that are everbodys labor day ideas? Lipsett197 0 September 1st, 09:42 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date