News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM forum Time Discrepancy after...

Microsoft Dynamics CRM forum

Unanswered

Time Discrepancy after Exporting from Report Wizard in CRM 2011

(0) Share

Report

Report

Posted on by Charan Raju C R

3,155 Moderator

Hi,

We are facing an issue in 'Export to Excel' function in Report Wizard. We have created one simple report using OOB Report Wizard(not SSRS), which contains few DateTime fields like CreatedOn. The DateTime values showing in CRM & Report Viewer is with respect to logged-in user's timezone(UTC+8) as expected. But after exporting report to excel, it is showing the time with 8 Hrs delay(UTC). We are expecting these DateTime values to be same as in CRM even after exporting it to excel.

Is this a bug from CRM? Can anyone help to fix this issue, please?

Thanks,

Categories:

Reporting and BI

All responses Img

All responses (2)

Answers Img

Answers (0)

Charan Raju C R 3,155 Moderator on at

Like (0)

Report

RE: Time Discrepancy after Exporting from Report Wizard in CRM 2011

Thanks for your reply. I tried by converting cell to text, still showing the incorrect Date&Time. One of the CRM 2011 org with UR8 doesn't have this issue. But it is there in an org with UR18. Seems this issue got introduced in the versions after UR8.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Time Discrepancy after Exporting from Report Wizard in CRM 2011

Looks like a bug. Can you please convert the cell to text and see.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2

Martin Dráb 228,177 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans