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).
Sheesh – could we have made this any more difficult?