Formatting of Save As HTML report in Excel

jetins9810
jetins9810 Member Posts: 55
edited 2005-10-03 in NAV/Navision Classic Client
Dear all,

i have a report that Run in Navision very good, but when i save this report As HTML and open it in Excel it's format not looking good the format of Report become so bad no one can understand it. Pl. give me any idea so that i got my report in right format in Excel after saving it as HTML.

Thanks :roll: in advance
With Thanks & Regards
Jetinder Saini...........
CorporateServe Solutions Pvt. Ltd......India

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Have you tried to simplify the column layout?

    It seems to me that excel add's a column every time the controls on the header and the lines do not line up. The more simple the report, the better HTML result.

    If you want to specificly make an excel interface, it is better to export the data via the Excel Buffer table.
    Marije Brummel | Freelance Business Central Specialist
  • Shenpen
    Shenpen Member Posts: 386
    To make Excel-compatible reports:

    1) Align headers and data to each other
    2) Put no space between columns
    3) No empty lines

    So it would look in a designer like a table - no spaces nowhere, just a "grid".
    Do It Yourself is they key. Standard code might work - your code surely works.

Categories