Јуче сам се борио са Перформанце Поинт и хтели да деле брз савет који могу спасити некога неколико сати фрустрације.

Створили смо један ССРС извештај и распоређен је на СхареПоинт.  Ми га распоређени у СхареПоинт и ми могли да покренете само навођењем казну у библиотеку извештаја и кликом на извештају.  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, међутим, 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 виолиниста 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. 

Коначно, 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, овде:

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, као што је приказано:

And in detail:

Боттом лине:

• Report Server URL comes directly from Central Administration
• Report URL: Fully qualified URL to the actual RDL file itself.

It’s so easy when it’s done correctly!

</крај>

Претплатите се на мој блог.

Следите ме на Туиттер на http://www.twitter.com/pagalvin