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.

Comments

  • edited 1:27AM
    The column header was merged across 2 cells. When I took "merge cells" off, the header and the column line up, but still getting a blank column next to it.
  • edited 1:27AM
    austingrd wrote: »
    Any luck found here so far Delta? A screenshot would be nice. By the way below is the link for the manual just to double check things.

    http://www.fast-report.com/documentation/U...rt_to_excel.htm

    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.
  • gordkgordk St.Catherines On. Canada.
    edited 1:27AM
    read the user manual chapter on report export and report design refrences.
    and you will see that your design is causing some of your problems.
    ie space between memos causes blank cells.
  • edited 1:27AM
    gordk wrote: »
    read the user manual chapter on report export and report design refrences.
    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.
  • edited February 2013
    Think about it, into which column should the "Confidential" text go?
    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.
  • edited 1:27AM
    Thanks.

    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]
  • edited 1:27AM
    Delta7428 wrote: »
    Thanks.

    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]
    If it is so important to your manager then ask your manager to spend some money on something like Mike Shkolnik's export suite.
    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.
  • edited 1:27AM
    technisoft wrote: »
    technisoft wrote: »
    Thanks.

    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]
    If it is so important to your manager then ask your manager to spend some money on something like Mike Shkolnik's export suite.
    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.


  • edited 1:27AM
    technisoft wrote: »
    technisoft wrote: »
    Thanks.

    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]
    If it is so important to your manager then ask your manager to spend some money on something like Mike Shkolnik's export suite.
    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.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.