Hey everyone, I have an issue where i am sending out files with 30,000+ lines and they are reaching the 11mb, 12mb in size. This is becoming and issue for us, as we are only allowed to email up to 10mb in size. I have tried reducing all spaces in the data, removing any graphics etc from the report , but still the excel file is over 11mb. One thing i did find was that, if i export it to excel, then open the file and save as a different file name the file size drops 50% !! I was wondering if anyone has been able to zip/compress the exported file before it gets emailed? It would be a great feature for MS to include in the next service pack.. Take advantage of the built in Zip support in Windows.. Look forward to hearing any suggestions that the community may have, Thanks Scotty

Hi there-Unfortunately you'll have to create a custom delivery extension for your report server. You can look at the PrinterDeleiveryExample in the RS samples folder (located wherever you installed RS) to give you an idea of what you'll need to do.If you are using .Net 2.0, then you can use the System.IO.Compression and System.Net.Mail libraries as part of your delivery extension. I unfortunately have a client that hasn't migrated to .Net 2.0 and I had to use .Net 1.1. I used two open source libraries to accomplish the task: DotNetOpenMail and SharpZipLib. I decided to use DotNetOpenMail, because you can create an attachment from an array of bytes, which you can't do with the System.Web.Mail library in .Net 1.1. So for my custom delivery extension, I zipped my report to a memory stream and then attached that stream's byte array to the e-mail.Here are some links to get you started: DotNetOpenMail - http://dotnetopenmail.sourceforge.netSharpZipLib - http://www.icsharpcode.net/OpenSource/SharpZipLibHope that gives you a starting point to a solution. If you have any questions, please respond back here.Regards,Scott

Scotty - Did you ever have any luck with this? I too am in the same boat...

Scott, I don't suppose you have any source code available for your solution? I need to produce an identical extension and any help would be very much appreciated. Regards, Mark.