Excel report too big | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Excel report too big

Hi all, Most of our reports are delivered to Users via Subscritions. And as part of the subscription we export the report to Excel and email it across. The issue is that most of the excel files delivered to users are between 1-5MB in size. And when you open up the report you might see only 50-100 lines of data. Has anybody come across this issue? Regards,
How many columns are you exporting? As an alternative to export from Reports, try this also
Madhivanan Failing to plan is Planning to fail