Problem exporting to Excel

• marty.seed

  SSCrazy

  Points: 2441

  More actions

  November 9, 2009 at 7:53 am

  #227804

  I have created a large tablix report 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???

• becklery

  Hall of Fame

  Points: 3315

  More actions

  November 14, 2009 at 5:16 am

  #1079357

  Hi.

  In my opinion, you can have a try of RAQ Report. With it, you can export your report to several sheets of an Excel file. Then, your problem is solved.

  For specific operations, you can download a free edition and refer to detailed user manual.

  Regards,

  becklery.

  RAQ Report: Web-based Excel-like Java reporting tool[/url]