I have created a large tablix report in SSRS 2008 that shows our daily sales for the year by day. I need this to be able to render to Excel 2007 for our execs but every time I try to export it if fails. When I try to email it through subscription I get the following error:
Failure sending mail: Excel Rendering Extension: Number of columns exceeds the maximum possible columns per sheet in this format; Columns Requested: 552, Max Columns: 256Mail will not be resent.
Is there any way around this???