DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
SITE SEARCH SQLUSA.com HEADLINES NEWS
SQL E/BOOKS   SQL 2014 PROGRAMMING   DOWNLOADS
SCRIPTS SQL 2005 SQL 2008 ARTICLES
SQL JOBS TWITTER FORMAT VIDEOS
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.

 

 

Exam Prep 70-461
Exam 70-461
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE