Add SSRS report to Project Detail Page Project Server

Often clients want to be able to drill down to SSRS reports with the project pre selected when they are viewing project information from project detail pages. This post describes how to embed SSRS report in a project detail page.

Add SSRS Report to Project Detail Page in Project Server

1. Navigate to a PDP (Project Detail Page) , e.g. Schedule PDP.
2. Edit Page
3. Click “Add a Web Part”. Select the “SQL Server Reporting Services Report Viewer” web part.

SQLReportViewerWebPart

4. Click “Add a Web Part”. Select the “SQL Server Reporting Services Report Viewer” web part.

ToolPane_SelectReport

5. Click “Click here to open the tool pane”.

SelectReport

6. Click on the “…” button to select a SSRS report and click apply. In the example below the “Project Overall Status” has been selected with one parameter capable of accepting ProjectUID.

Report_ProjectOverallStatus_NoParam_Passed_edited.png

7. Click “Add a Web Part” to add “Query String (URL) filter”.

QueryString(URL)Filter

8. Click “Open the tool pane” to configure “Query String (URL) filter”.

QueryString(URL)Filter_OpenTheToolPane

9. Add “projuid” into the “Query String Parameter Name” property.

QueryString(URL)Filter_ProjUid

10. Click on the “Arrow Down” on the webpart and click on “Connections”-”Send Filter Values To” – .

SendFilterTo

11. Click on the “Arrow Down” on the webpart and click on “Connections”-”Send Filter Values To” – .
Pick the parameter defined in the SSRS report into “Filtered Parameter”.

FilteredParam

12. Click on “Stop Editing”.

StopEditing

13. The report is rendered displaying only information of the project

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s