Using Reporting Services in SharePoint Integrated Mode with PPS 2010 with SQL Server “Denali” CTP3http://blogs.msdn.com/b/performancepoint/archive/2011/08/18/using-reporting-services-in-sharepoint-integrated-mode-with-pps-2010-with-sql-server-denali-ctp3.aspxThe SQL Server team has made a small change to the location of the web service that PPS calls in order to render SQL Server Reporting Services reports when running in SharePoint Integrated mode.&#160; In this blog post, I’m going to go over how to worken-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Using Reporting Services in SharePoint Integrated Mode with PPS 2010 with SQL Server “Denali” CTP3http://blogs.msdn.com/b/performancepoint/archive/2011/08/18/using-reporting-services-in-sharepoint-integrated-mode-with-pps-2010-with-sql-server-denali-ctp3.aspx#10311791Wed, 30 May 2012 11:12:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:10311791Prasad<p>I got an error as &quot;Access Denied&quot; for the logged windows user, while trying to preview the report. Do you have any idea about it?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10311791" width="1" height="1">re: Using Reporting Services in SharePoint Integrated Mode with PPS 2010 with SQL Server “Denali” CTP3http://blogs.msdn.com/b/performancepoint/archive/2011/08/18/using-reporting-services-in-sharepoint-integrated-mode-with-pps-2010-with-sql-server-denali-ctp3.aspx#10235423Wed, 09 Nov 2011 16:29:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:10235423John B<p>There seems to be a bug when using SQL Server 2008 R2 and PP 2010.. When you use a report that is deployed to a site collection, the designer adds the site collection path in twice as below, which fails the report creation. Any insight?</p> <p>I enter</p> <p>http://&lt;sharepointserver&gt;/Sites/Bi/reports/&lt;ReportSubDirectory&gt;/&lt;ReportFileName&gt;.rdl</p> <p>designer attempts to access</p> <p>http://&lt;sharepointserver&gt;/Sites/Bi/Sites/Bi/reports/&lt;ReportSubDirectory&gt;/&lt;ReportFileName&gt;.rdl</p> <p>more info here</p> <p><a rel="nofollow" target="_new" href="http://social.msdn.microsoft.com/Forums/en-SG/sharepoint2010general/thread/1fdbcc68-12f0-4b08-814f-0ecf6800b811?prof=required">social.msdn.microsoft.com/.../1fdbcc68-12f0-4b08-814f-0ecf6800b811</a></p> <p>Sorry for the off topic comment, but this seems to be the best place I can find to report the issue (if there is somewhere else, I&#39;d be glad to go there!)</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10235423" width="1" height="1">