option to increase number of rows from Export

[ArpanGhosh1]

Hi Experts, 

Currenlty when i try to export the underline data from a report object in excel, i could get only 50,000 rows.

Is any configuration change, by virtue of which we can increase the number of exported rows.

I am using SAS VA 7.1

Regards

Arpan

[RW9]

I have no idea I am afraid as I don't use VA.  However I would ask for what purpose do you intend to export >50k rows to Excel?  Nobody will ever look at that data.  If your doing a transfer of data, I would strongly suggest that you use a proper data transfer format - CSV, XML, etc.  Unless you absolutely have to use Excel, don't.

[ArpanGhosh1]

We need it it excel only.

Is there any option avaible? 

[ShivamKS]

You can try adjusting the va.SortResultServerLimit property in SAS SMC. This however might affect resuts only in List Tables.

[ArpanGhosh1]

I guess we need to restart LASR serevr after the modification