Options

Send to excel report

BeliasBelias Member Posts: 2,998
edited 2010-11-03 in NAV Three Tier
hi everyone, i am developing a report that can be printed in 2 different layouts, depending on if the user chooses the standard one, or the "excel friendly" one. this is what i've done so far:
i've higlighted in red the table for the excel layout. the other part of the report is the standard layout.
this have been done in order to have all the data striped on a single line.
I know i can use excel buffer to achieve the same result, hyperlink feature. Moreover, the excel buffer is deadly slow, compared to the save as excel.

the final result in excel is this

you can see that it needs some arrangement like:

1. Delete the first 2 blank rows
2. Remove the wrap text on the whole sheet
3. double click the columns in order to autosize them

this is a small step for a developer, but a big step for a low end user :mrgreen:
I am asking if someone of you knows if there's a way to trick the wrap text and the white spaces...(the autosize will come automatically after removing the wrap).
Thanks in advance
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog

Comments

  • Options
    BeliasBelias Member Posts: 2,998
    Wrap text tricked by removing the Cangrow property!! \:D/
    I should have thought about it before #-o
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
Sign In or Register to comment.