1 / 19

Dharmesh Patel +44 (0)7968 369 266 info@dharmeshpatel.co.uk www.dharmeshpatel.co.uk Friday, 06 February 2009

MPUG London Chapter. Dharmesh Patel +44 (0)7968 369 266 info@dharmeshpatel.co.uk www.dharmeshpatel.co.uk Friday, 06 February 2009. Using SQL Reporting Services with Project Server 2007. What is MPUG. Introduction. The Report Pack Setting up the Report Pack from the SDK

bebe
Download Presentation

Dharmesh Patel +44 (0)7968 369 266 info@dharmeshpatel.co.uk www.dharmeshpatel.co.uk Friday, 06 February 2009

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MPUG London Chapter Dharmesh Patel +44 (0)7968 369 266 info@dharmeshpatel.co.uk www.dharmeshpatel.co.uk Friday, 06 February 2009

  2. Using SQL Reporting Services with Project Server 2007 What is MPUG

  3. Introduction • The Report Pack • Setting up the Report Pack from the SDK • Using Visual Studio to create reports • How will the information be displayed to end users

  4. Overview

  5. Requirements • Microsoft SQL Server 2005 SP1 • SQL Server Reporting Services (SSRS) 2005. • SQL Server Business Intelligence Development Studio • Extension of Microsoft Visual Studio 2005. • Business Intelligence Development Studio is installed with SQL Server. • Install the Project 2007 SDK - Part of the Project SDK • In the ‘Samples\Report Pack’ sub-directory

  6. Report Pack Setup – 1 • Copy the files in the Code Samples\Report Pack subdirectory of the Project 2007 SDK to a directory on a computer where you have the Microsoft SQL Server Business Intelligence Development Studio installed. • Open the Project 2007 Report Pack.sln file. If Microsoft Visual Studio 2005 is installed on the same computer, the report project opens in Visual Studio. • In Solution Explorer, double-click Project Data Source.rds. In the Shared Data Source dialog box, click Edit. • In the Connection Properties dialog box, modify the server name, the RDB name, and the authentication fields if necessary.

  7. Report Pack Setup – 2 • Click Test Connection to make sure the connection works, and then click OK. Click OK again to save the data source information. • On the Project menu, click Project 2007 Report Pack Properties. • Change the TargetServerURL value to the URL of your report server. The value for the sample project is http://ps2007demo:81/reportserver. • Change the TargetDataSourceFolder value if necessary. The value for the sample project is Data Sources. • Build and then deploy the solution to your SQL Server Reporting Services instance. On the Build menu, click Deploy Solution.

  8. The Different Reports – Cost Center Availability Report

  9. The Different Reports – Project Deliverable Gives/Gets Report

  10. The Different Reports – Project Portfolio Trend Report

  11. The Different Reports – Project Proposals Listing Report

  12. The Different Reports – Project Review Report

  13. The Different Reports – Timesheet Audit Report

  14. The Different Reports – Work Versus Effort Audit Report

  15. Project Server Extended Report Pack from Project Conference • Christophe Fiessinger's Blog • Reports added are: • Deliverables and Dependencies • Issues and Risks Report • Project Workspaces • ProjectList PSI XML • ResourceList PSI XML • Risks - XML Data Srouce • SSAS Timesheet • Timesheet Audit 2 http://blogs.msdn.com/chrisfie/archive/2007/10/30/project-server-extended-report-pack-from-project-conference.aspx

  16. Using Visual Studio to Create Reports • Report Wizards

  17. End User Experience • What do the Users see

  18. Hints and Tips • Install Reporting Services on a different port to SharePoint/Project Server • Use the Database Schema’s provided in the SDK • It is Only supported to report from the Reporting Database

  19. Thank You – Questions.... MPUG London Chapter Dharmesh Patel +44 (0)7968 369 266 info@dharmeshpatel.co.uk www.dharmeshpatel.co.uk Friday, 06 February 2009

More Related