Excel Export
When I export my report to Excel, on a couple of the columns the column header is pushed to the next column with a blank column underneath it.
The column width and the header width are the same size in the report design.
The column width and the header width are the same size in the report design.
Comments
thanks for reply austin,
In the process of doing a couple screen shots for you, the report footer caught my eye.
Removing the footer took care of "this isse" - columns and headings are exporting correctly ... no extra column.
Is it not possible to do the export including a report title (header) and footer that does not line up and sized according to column width?
Although I have stripped it out of this report, the final report design includes a logo and 3 line header, plus a footer. It is desired to have all of these elements on the Excel export.
and you will see that your design is causing some of your problems.
ie space between memos causes blank cells.
I know it was design issue.
Discovered that and fixed. I asked a follow up question in my last post.
Thanks.
Does it belong into the Election column, or the Base column, or the gap between them?
I think that if the placing is not obvious, by means of precise alignment, FR just inserts a new colum (or row) which is probably a sensible solution.
I did not attach a screen shot of the 3 line header including logo I asked about in the post that I included the attachments, but I think it is not possible to make each memo box in the header at least, line up with columns in the detail.
I thought there might be a way to isolate the header/footer and export them without having to line it to detail columns.
Seems not.
My manager is insisting the header at least, need to be included WYSIWG in the Excel spreadsheet - and thinks developer/report writer does not know what she's doing .. trying to convince him otherwise [img]style_emoticons/<#EMO_DIR#>/wacko.gif" style="vertical-align:middle" emoid=":wacko:" border="0" alt="wacko.gif" /> Thanks again.[/img]
With it you get a very clean looking spreadsheet with no extra columns, the columns having the right data type, and the page header/footer information can be put into the a Export.header/footer field.
However, the user will have to decide whether he wants a the report as FR report or Excel export beforehand.
Thanks Mike. I will check it out.