Post reply

Report Export to Excel issue

  • 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

  • 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.

  • September 23, 2009 at 6:49 am

    #1057450

    That works....

    Thanks Mhlewis .

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply