Extra or merged columns in excel export

  • When i create a report, i have a standard header in the PageHEader section.  It includes a couple of lines, an image, and some text controls in a rectangle.

    When the table is created below, it has columns of varying size.  If these columns don't match up with the above items, then some merged columns or extra columns appear.  It seems that excel looks top to bottom from left to right, and tries to make columns out of the different sizes.  I am not sure how to fix this, other than try to line everything up.  This means that my headers need to be altered for each report, based on the widths of the columns.

    Anyone have any ideas on how to remediate this?

     

    thanks

  • Don't use a page header at all.

    Instead, insert additional table header row(s) and merge the cells as needed for your text and image. Set the 'repeat on each page' = true.

    This would also allow you to display database fields at the top of each page, which the page header does not permit you to do.

    See if that helps.

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

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