67

I have noticed something odd with CRM 2011. When I export a report to excel all of the cell's come in as "General", even date's, numbers, and currency. This means that I cannot perform calculations on them without converting them first. This was not an issue in CRM 4.0. I know that the data types changed in CRM 2011 to .NET data types, but I don't see why the reports are acting different.

Use-case:

Create a new report for Opportunities using the wizard. For the columns, use Topic and Est. Revenue.

Run the Report, and export to Excel.

Open the saved report, and all of the cell's are formatted as 'General'. If you try to add any of the Est. Revenue column, the result will be #Value!.



I know you can get around this by manually changing the cell type, but I am looking to have it in the correct format once it is exported. Is this an open issue, or does something need to be specified in the report itself?

Category:
STATUS DETAILS
Under Review