Problem Note 63500: SAS® Visual Analytics and SAS® Report Viewer export a different number of rows to Microsoft Excel
When exporting data from SAS Visual Analytics, you can specify how many rows to export. If you do not specify the number of rows, the number of rows exported to Excel might vary between SAS Visual Analytics and SAS Report Viewer.
The difference is that when the request for data is submitted and the number of rows is not explicitly defined, SAS Visual Analytics does not specify a maximum. However, SAS Report Viewer does specify a maximum based on the number of rows that are being displayed in the web client. If there is so much data that the web client has limited the number of rows displayed, then the export action from SAS Visual Analytics exports as much as the server allows, which might be more rows than are displayed in the web client.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
The hot fix changes the SAS Report Viewer behavior to match SAS Visual Analytics.
Operating System and Release Information
SAS System | SAS Report Viewer | Linux for x64 | 8.3 | 8.4 | Viya | Viya |
Microsoft® Windows® for x64 | 8.3 | 8.4 | Viya | Viya |
SAS System | SAS Visual Analytics | Microsoft® Windows® for x64 | 8.3 | 8.4 | Viya | Viya |
Linux for x64 | 8.3 | 8.4 | Viya | Viya |
Cloud Foundry | 8.3 | 8.4 | Viya | Viya |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-07-16 11:40:40 |
Date Created: | 2019-01-16 14:07:30 |