CRM 2015 – Report Wizard – Duplicating Datetime Columns




I was creating a report from the CRM 2015 Report Wizard and i just ran the Report where i saw that a date time column was appearing two times, one with the formatted value from my options, in the case English(Ireland) format (01/01/2016 03:00:00) and the next unformatted, something like 2016/01/01 03:00:00 AM.

After digging quite a bit i have discovered that the Body XML on the database had the column in there, and for me, no direct updates/deletes/creates in the database, so i tried to find the reason.

I have discovered from one of my search results that inside the folder (your drive)/Program FilesMicrosoft Dynamics CRMSetupServiceabilityLatestActions_OrgInstall the file (dbupdate_37910.sql) could solve the problem. 

I have opened the file where i saw: 

— CRMSE 37910 – Wizard reports when exported to excel should not duplicate the unformatted columns.

Having in mind that probably those files that start with "dbupdate_" will solve few issues similar to this one.

For me, i will give more attention to that folder from now on.

Before running the sql against each organization i advise you to perform a BACKUP on the database, it is better to prevent any possible damages when executing this kind of operations.

#DuplicateDatetimecolumns #ReportWizard

0 views0 comments

Recent Posts

See All