Report Export to Excel issue

• Nemo - 4828

  SSC Eights!

  Points: 992

  More actions

  September 21, 2009 at 9:57 am

  #385398

  Hi members,

  I'm exporting a report to Excel.My report has 10 fields.But when i export it to Excel i dont get the same number of cells.

  Some of the fields occupy 2 cells.Say column B occupies cells B and C . Instead i want the fields to occupy 1 cell each.

  Please suggest..

  Thanks,

  Nemo

• MWise

  SSCarpal Tunnel

  Points: 4074

  More actions

  September 22, 2009 at 2:20 pm

  #1057129

  This is a good resource for dealing with Excel export issues: http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx.

  I've fixed a lot of issues by making sure all of my text boxes line up. I've also had to move some things like a label legend into an embedded image so that it wouldn't merge the fields in the table below it.

  It's very aggravating about the lack of control over the Excel export. Usually I get better results when complex reports are exported to PDF. When I do "reports" that are to be used primarily as data exports I make sure that they are very simple tables without merged fields, title boxes and headers and footers.

• Nemo - 4828

  SSC Eights!

  Points: 992

  More actions

  September 23, 2009 at 6:49 am

  #1057450

  That works....

  Thanks Mhlewis .