View Complete Post
Have an Excel services PivotTable in a PPS 2010 dashboard. When the user selects the "Export to Excel" option they receive this error.
I do not see any options in the webpart to show the old toolbar that used to show up in the Excel Services views. (It had an option to open the pivottable in Excel or export a "snapshot" to Excel)
How do users export Excel Services reports to Excel?
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: c189d209-c218-4606-aad4-2f280d5c6977
Date and Time: 9/20/2010 10:26:17 AM
With 2007, an Excel sheet could have two pivottables, and it was possible to link a PPS filter to both of those pivottables.
With 2010 it appears that you can only link a PPS filter to ONE pivottable. Can someone confirm this?
How to include the timestamp in the report name while saving it to excel.I have a report and I want to save it in Excel and by default it takes the report name, but I want to include the report execution time along with the report name as it will help me
in my testing. Can any one please help me with this.
Thanks for your help
Excel has a header. How can I export info from the rdl header directly into the excel header. Specifically, besides text, it would be desired to have the excel header reflect the pagination, i.e. page x of y.
It is desired to have the page breaks existing in the rdl file to correspond to the page breaks as they are arranged in the rdl file when export occurs to Excel
I have a requirement to export a large SSRS report into Excel. The report has more than 52 columns and around 70000 lines. The requirement is to export the report into a single excel(different sheets also would do ). Can you suggest some help in
Thanks in advance!
I am exporting a 12,000 row, 20 column report to Excel from SSRS 2008. Once opened in Excel, everything is fine. If I further filter the data through Excel (no external data connections) performance degrades. If I filter down to say 20
rows, it nearly completely bogs down my entire PC. I've emailed this spreadsheet to several others, who then experience the same issue.
If I export this same set of data from a different BI tool, such as Microstrategy, there are no performance issues what so ever.
I have a problem with a reporting services 2005 report.
The data source is OLEDB for OLAP 9. ÃÂ The report contains all the members of a parent child dimension. An example of the implementation is defined in the post following the forum msdn: Http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=138549&SiteID=1. ÃÂ ÃÂ ÃÂ The report works fine in web. The problem is when the report is exported as Excel, the groups disappeared and the entire dimension is ragged down.ÃÂ Normally toggled groups in reporting services are exported to Excel with the appearance '+' or '-' on the
I have created a main SSRS 2005 report from what it is possible to call some subreports. Is it possible export in PDF or Excel also the subreports when I require the export inside the main report?