topic Re: VA Report: limit number of rows exported to Excel in SAS Visual Analytics

VA Report: limit number of rows exported to Excel

MariaD — Tue, 23 Nov 2021 14:06:36 GMT

Hi Folks,

There is any way to limit the number of rows the user can download to Excel from VA Report? We have SAS 9.4M7 and VA 7.51.

Regards.

Re: VA Report: limit number of rows exported to Excel

Madelyn_SAS — Tue, 01 Feb 2022 18:49:56 GMT

I don't see any properties that can be used to place a limit on the number of rows exported in release 7.51.

This does appear to be available in 8.5.

Re: VA Report: limit number of rows exported to Excel

acordes — Tue, 01 Feb 2022 21:50:48 GMT

with admin rights you can set higher row limits.

have in mind that the column numbers affect as well.

to get all rows exported try applying filters to export less than the threshold, like sales figures from january to march,...