Compressing excel file for Export in Report Server

[M_nwadibia]

Hello,

I have a file size limit in our email configuration and my file keep growing.

Is there an option to compress large excel files in Report Server or RDL so that emailing can be easier using RDL authoring tool?

The report in question has about 9 columns only but has over 400k records and size 25MB. The mailing limit is 22MB.

Thank You

[M_nwadibia]

I understand we can use Python to convert the .xlsx to xlsb or PowerShell Programs before using standard subscription to distribute report. Is this possible?

[d_gosbell · Accepted solution]

The Excel files should already have compression applied. I do not believe there are any settings to increase the amount of compression. You might need to look at using a different transport mechanism such as putting the files in a file share.