Welcome to MSDN Blogs Sign in | Join | Help

Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer

Disclaimer: the post below was written after 24+ hours traveling to India - I was pretty much (very much) out of my mind at the time...

I just spent more than a few minutes messing around with the “SQL Server Report” report viewer in PerformancePoint, and choosing correct values for the Report Server URL and Report URL properties when in SharePoint Integrated mode isn’t, uh…exactly intuitive.

First, a gripe - the Server mode option: You have two choices, “SharePoint Integrated” and “Report Center” modes. Report  Center mode? What in the world is that!? As far as I know, there is no way to get a SSRS report to show up in Report Center unless it is already saved in MOSS. So, “Report Center” mode means “SharePoint Integrated” mode to me. It would have been nice we used the same names for these choices (native and integrated)  as we do in the SSRS docs! Bleech!

Specifying the Report Server URL is straight forward.  Just drop in the location of your Report Server web service, like: http://someMachine/reportserver.

Plugging in the Report URL value is a bit more troublesome. I tried the standard strings like “/ReportLibraryName/ReportName”, etc. Each attempt failed with:

Unable to find report specified by URL. Please verify that both the Server URL and report URL are correct

I finally got sick of plugging in values, and just surfed to http://myMachine/reportserver and browsed to the report in question:

1. Hit the http://someMachine/reportserver vdir of your SSRS installation.

2. Drill down into the folder (in my case http://bi-vpc) that was created when you configured SSRS/MOSS integration and started saving reports. See the screen shot below.

3. Open the folder which represents your Report Center (in my case, “Reports”).

4. Click the link which represents your report library (“ReportsLibrary” for me).

5. Note the name of your report, and don’t forget the .RDL extension at the end!

Put parts 2-5 together, and you have the string you need to plug into Report URL (http://bi-vpc/reports/reportslibrary/CompanySales.rdl - see the screen shot below).

  Attachment: Slide1.JPG (57300 bytes)

Sheesh – could we have made this any more difficult?

Published Sunday, March 02, 2008 9:50 by russch
Attachment(s): Slide1.JPG

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# MSDN Blog Postings » Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer

Sunday, March 02, 2008 11:35 by MSDN Blog Postings » Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer

PingBack from http://msdnrss.thecoderblogs.com/2008/03/02/fun-displaying-ssrs-integrated-reports-using-performancepoint-sql-server-report-viewer/

# PerformancePoint Reports and new Management Reporter

Thursday, March 13, 2008 10:05 PM by Norm's PerformancePoint Server Blog

Somebody sent me an e-mail asking about differences between Business Manager Scorecard reports and PPS

# PerformancePoint Reports and new Management Reporter

Thursday, March 13, 2008 10:36 PM by Noticias externas

Somebody sent me an e-mail asking about differences between Business Manager Scorecard reports and PPS

# Have you tried this with a parameterized report?

Thursday, July 24, 2008 4:20 by Artich

Have you tried this with a report that accepts input parameters? I have a report with two parameters deployed to the ReportsLibray of the bi-vpc. When I went into PPS Dashboard Designer to configure the report, I received the same error you got "Unable to find report specified by URL. Please verify that both the Server URL and report URL are correct" but after a while the preview pane at te bottom was able to show the report viewer but the Dashboard designer would not populate the "Report Parameters" section with parameters I had in the Report. In contrast, when I deployed the same report to the Native Report instance, selected Report Center mode in the Dashboard Designer, the "Report Parameters" section will be populated with parameters I had in the report.

# Same issue as the Artich's post

Thursday, July 31, 2008 11:57 PM by Michael Shugarman

I have the same issue as above.  An SSRS report with input parameters works fin ein Report Center mode, but SharePoint Integrated give me the "Unable to find...." error and then I can see the report in the preview pane, but no parameters are availabel and the Edit button is grayed out.  

Anyone else seen or, better yet, resolved this issue?

# re: Same issue as the Artich's post

Monday, August 11, 2008 8:57 PM by Artich

OK. This doesn't make sense but it appears once I added a selectable list or "Available Values" for each parameter, PPS was able to display parameters properly. Also, the "Unable to find the .. specified url" error no longer appeared. I still don't get this but at least I can get it going for now.

# re: Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer

Friday, August 22, 2008 5:54 by Jitender

I have list of parameters and report shows all the parameters in two columns only. Can i increase it to 3 or more column.

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker