Formatting of Save As HTML report in Excel

jetins9810

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

Marije_Brummel

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.

Shenpen

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".