datetime century date into pad dynamic cursor money percent sp job isnumeric isdate over update
SQLUSA.com
SQL 2008 GRAND SLAM ON 49 CD
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL Server Training SQL 2005 Scripts SQL 2008 Articles
SQL JOBS News Format Developer
How to load example reports from Reporting Services training bonus CD?

Execute the following steps to load up reports from the bonus CD. These are the steps to load up reports generally from a disk folder also.


1. Place Bonus CD into CD/DVD drive. Copy/paste folders to a designated disk folder.

2. Enter Business Intelligence Development Studio

3. Select on File dropdown menu Open Project/Solution

4. Point to designated disk folder, subfolder "bonus/CD1Reports" (similarly for other CDs)

5. Select project CD 1 - BI Delivery (there is only one project in each subfolder)

6. After project loads, go to Solution Explorer window; If not docked usually on the right hand side, select it from the View dropdown menu

7. Right click, Open/Edit Shared Data Sources for valid connection properties

8. Under File tab, click on Save All ( saves Solution, Project, & Reports)

9. Double click on any of the reports in Solution Explorer

10. Report should appear in design mode.

11. Click on Data tab. Test all datasets, fix properties/queries when needed

12. Save All

13. Click on Preview tab. Report should run and result appear.

 

 

Order SQL 2008 GRAND SLAM Today!
SQLUSA.com Home Page
SQL Server Training at www.sqlusa.com.
Microsoft SQL Server 2012 Training Videos at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.
Accounting
Administrative
Advertising
Arts
Architecture
Banking
Business Intelligence
Career Jobs
Celebrity
Computer
Consulting
Customer Service
Education
Engineering
Entertainment
Entry Level
Executive
Federal
Finance
Government
Hardware
Healthcare
Hospital
Human Resources
Information Technology
Insurance
Internet
Job Openings
Laboratory
Law Enforcement
Legal
Logistics
Manufacturing
Marketing
Medical
Military
Nursing
Pharmaceutical
Physician
Public Relations
Publishing
Real Estate
Restaurant
Retail
Sales
Social Media
Software
SQL Database
Telecomm
Therapist
Training
Transportation
Truck Driver
Travel
Web
Work from Home

FREE SS SQL / BI OLAP Short Videos on YOUTUBE.com

Microsoft Community Contributor 2011 Microsoft Community Contributor 2012

Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts

JOIN US ON TWITTER

Copyright 2005-2012, SMI Corp. All Rights Reserved.

SQL Server 2012 is a program product of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.