CODEWITHSUNDEEP
dynamics-crm-2011
Nick
Nick

Reputation: 31

Dynamics CRM - advanced find row count is different when exported to excel

In Microsoft Dynamics 2011: I did a very basic advanced find and the number of records returned was 13,449. I exported this to excel and the number of rows in the spreadsheet was 13,486. For the life of me I can't see any reason why it should be exporting 37 more records than were in the advanced find results.

I tried exporting the raw fetch to try running it in isolation, but there is a 5000 row limit so I couldn't. Dynamics seems to page through the records once it hits 5000. Has anyone else had this issue or be able to help please?

Upvotes: 0

Views: 1023

Answers (1)

C Y
C Y

Reputation: 180

  1. Most likely the data changes during the time you are exporting and 37 more records match the query criteria. Refresh the result in Advanced Find and check the number.
  2. If possible, run the query in SQL and check the result.
  3. If the view contains any multiple line text field, I suggest you check if any of these values take more than one rows in Excel. Normally CRM export feature puts all the text in one line, but you may check that just in case.
  4. If Advanced Find is your only tool and you really need to find the issue, do a research on the exported data, find the column that has the most distributed values. E.g. a currency field "CurrentValue" that contains 1000 distinct values out of your 13000+ records. Use the distinct values to retrieve sub data set so you can easily compare the result from Advanced Find and the Excel sheet, e.g. add a condition that "CurrentValue" is between 0 and 100. Once you find the 37 records that not shown in your Advanced Find, you can then look into the record data and find out the cause.

Upvotes: 1

Related Questions