Send to excel report
Belias
Member Posts: 2,998
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
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
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
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
0
Comments
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions