I have an SSRS report that I have embedded into a PPS dashboard. Everything works just fine and the report returns the right results and everything. The issue is when trying to export the report to Excel - a requirement of the users.

Here's how the report looks in PPS:

As you can see, it's in a matrix/table format. When I right click in the report and choose "Export to Excel", I get the following error:

I'm assuming this has something to do with the eay Excel Services is - or isn't - configured on my SharePoint server.

Is there somewhere I can check on this or some way to confirm that Excel Services is installed properly? Is Excel Services even the problem?

Any help would be appreciated!

Thanks!

It's been over a week...

Has anyone ever seen anything like this or dealt with something like this when exporting to Excel from PPS?