Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Time format when saving RDLC report to Excel (NAV 2009 R2)
ACaignie
Member Posts: 91
Hello,
I have a problem with an RDLC report that is incorrectly saved in Excel. On the report there are some time columns, which are displayed correctly on the report. However when the report is saved to Excel from the preview, the times are shown as #######, and the value of the field is a decimal number like -693592,666666667. In the report builder the format is set to 't'.
I know I can solve this by changing the field to a string and format it in NAV itself, but the problem is that this isn't the only report that needs to be changed. We have over 150 RDLC reports, many containing time information.
Does anyone know a solution?
Kind regards,
Andy
I have a problem with an RDLC report that is incorrectly saved in Excel. On the report there are some time columns, which are displayed correctly on the report. However when the report is saved to Excel from the preview, the times are shown as #######, and the value of the field is a decimal number like -693592,666666667. In the report builder the format is set to 't'.
I know I can solve this by changing the field to a string and format it in NAV itself, but the problem is that this isn't the only report that needs to be changed. We have over 150 RDLC reports, many containing time information.
Does anyone know a solution?
Kind regards,
Andy
0
Best Answer
-
Aquir
Member Posts: 23
Hi,
you have 2 options:
- upgrade to the latest NAV version. Unfortunately even 2015 have problems around RDLC+Excel regarding formats
- format the Date/Time in NAV and send as text to the RDLC report - should be avoided, I know...
Cheers!5
Answers
you have 2 options:
- upgrade to the latest NAV version. Unfortunately even 2015 have problems around RDLC+Excel regarding formats
- format the Date/Time in NAV and send as text to the RDLC report - should be avoided, I know...
Cheers!
I changed the format in the report itself