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