SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 66185: Subtotals unexpectedly appear in exported Microsoft Excel files when you export data from cross table report objects in SAS® Report Viewer

DetailsHotfixAboutRate It

When you export data from cross table report objects in SAS Report Viewer, the exported file might contain Subtotals even when the original cross table in SAS Visual Analytics did not contain them.

The following image shows how the cross table appears when it is exported from SAS® Visual Analytics Designer:

designer export

The following image shows how the same cross table appears when it is exported from SAS Report Viewer. In this case, subtotals are unexpectedly added into the exported file.

viewer export

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual AnalyticsMicrosoft® Windows® for x647.58.59.4 TS1M6Viya
Linux for x647.58.59.4 TS1M6Viya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.