Monthly Archives: September 2010

In Search Of … Great SharePoint PM and Solutions Architect

I lead a SharePoint practice for Computer Generated Solutions (CGS). We’re based in New York City at World Financial Center (just next door to WTC). I am looking to hire two full time people to help me lead my group – SharePoint project manager and a SharePoint solutions architect.

Both roles are full time and cannot be done remotely. There’s not a lot of travel. Travel, such as it is, generally takes place in NY, NJ and CT.

If you’re interested in finding out more, fire off an email to pgalvin@cgsinc.com. I’d love to hear from you.

Our website doesn’t do a good job explaining my practice (I’m working on that). By all means, check it out, but I’ll give you the real scoop if we talk by phone.

</end>

Subscribe to my blog.

Follow me on Twitter at http://www.twitter.com/pagalvin

Performance Point 2010 and Report Server URL

1 Reply

I was struggling yesterday with Performance Point and wanted to share a quick tip that might save someone a few hours frustration.

We had created an SSRS report and deployed it to SharePoint. We deployed it to SharePoint and we could run it just fine by navigating to the reports library and clicking on the report. We could also add it to a web part page using the SSRS report viewer web part. All good stuff.

When we tried to add it to a dashboard using Dashboard Designer, however, we hit a wall. Dashboard Designer would tell us “Unable to find report specified by URL. Please verify that both server URL and Report URL are correct.” This is what I was seeing:

Bing found me this promising article, “Fun displaying SSRS (integrated) reports using PerformancePoint SQL Server Report viewer”). It felt like good information, but I wasn’t able to solve the problem with what it showed.

I downloaded fiddler onto the workstation to see what was happening under the covers and although that was also unproductive, it was very interesting. I suggest that you try that out some time just to see what happens. It’s pretty illuminating.

Finally, my colleague Kiran Chauhan pointed me to central administration to look at Report Server’s settings. Oddly enough, that’s located under “General Settings.” I had earlier searched for it as a managed service. I still have learn my way around SP 2010 🙂

Central admin immediately showed me the problem:

And really, here:

The key bit was the "_PROD_SERVER” appended tot he ReportServer URL. Once I saw that, it was a simple matter to pop over to Dashboard Designer and use the correct URL, as shown: