Time format when saving RDLC report to Excel (NAV 2009 R2)

ACaignie

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

Aquir

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!

Aquir

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!

ACaignie

Unfortunately I had to update the RDLC reports as no other solutions seems to be possible.
I changed the format in the report itself