Ravendra's Blog

February 2, 2010

SSRS Report on TFS 2010 Portal


Sometimes default reports which comes out of the box with process templates are not enough and custom reports are required. These reports can be put together on SharePoint team portal to create a dashboard or part of existing pages/ dashboards. If using SSRS on SharePoint integrated mode than rdl files of these reports can be copied directly on document libraries. Sometimes SSRS is not running on SharePoint integrated mode specially when SSRS is deployed in different box then SharePoint box. In such cases using Web page view web part can be quite useful.

Let’s say there is project collection called “PCollection” contains a project called “PProject” contains a report called “PReport” then URL for this report on page viewer web part will be something like

/PCollection/PProject/_layouts/tfsredirect.aspx?IsReport=1&ReportName=PReport

If report is located within folders let’s say “Dashboards” then URL will be

/PCollection/PProject/_layouts/tfsredirect.aspx?IsReport=1&ReportName=Dashboards/PReport

If report name of folder name contains multiple words then space between these words should be replaced by ‘+’ symbol. For example in above examples folder name is “Project dashboards” and report name is “Burn up report” then URL will be something like

/PCollection/PProject/_layouts/tfsredirect.aspx?IsReport=1&ReportName=Project+dashboards/Burn+up+report

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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

Blog at WordPress.com.

%d bloggers like this: