Root Cause: Its been called to my attention that reports which are both Grouped and Pivoted will not export that way and we will adjust (I think by removing the pivoting) of the report.
The problem here is that the user doesn't have any option when exporting out the report if they want to include the report. In this case, they do not want the "un-pivoted" report exported out. They also don't want to remove the report from the dashboard because it does show correct in the UI. They are stuck with exporting it out and deleting it from the .ppt deck.
Fix:
- Allow for this report to be exported out to PPT like it is on the dashboard without removing the pivoting/grouping.
- I noticed there is a popup on dashboards that says "some reports cannot be exported, etc." We need to include this combination of a report on that list and exclude it from the reports being exported altogether.
- Give the user the ability to pick and choose which reports they want on the dashboard to be exported.