Extra or merged columns in excel export

• tjaybelt

  SSCrazy

  Points: 2604

  More actions

  November 18, 2004 at 2:08 pm

  #109616

  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

• WILLIAM MITCHELL

  SSChampion

  Points: 13759

  More actions

  November 19, 2004 at 8:18 am

  #530843

  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.