Excel Reporting Services Error

Question

We have Team Foundation Server 2010 installed and connected to SharePoint Server 2007 and SQL Server 2008 R2.  Reporting Services is configured on the TFS App Tier.  I finally got SSO configured to I'm no longer getting those errors.  But when we point to the TFS Dashboards I get an error message indicating the refresh failed.  When I look at the logs, all it tells me is that the refresh failed...nothing more.

Here's the interesting thing.  The reports that are on the dashboard work fine if you view them in Visual Studio or if you open the spreadsheet.

Any ideas on what I should be looking for to correct this issue?

Answer 1

Hi Currcmpsvc, 

Thanks for your post. 

In order to resolve this issue, I want to confirm some information with you:

1        please share the detailed error log here.

2        Which process template used to create this team project?

3        Which special Excel report can’t be opened correctly? Or all the Excel reports which under this team project can be opened?

4        Where you tried to open the Dashboards? And which Dashboard you tried to open? 

5        Please try to open the Dashboards on TFS Server machine or other clients, what’s the result?

6        Try to rebuild warehouse and analysis Cube, then open again.(TFS Admin Console>>Reporting>>Start Rebuild).

And you also can provide the screenshot here.  

If you have any further research of this issue, please share your experience here.  

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Currcmpsvc, 

If misunderstood anything, please describe your question in more detail and we will be able to provide the better responses.

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us