Hello All,

No matter which entity i'm in, if I do an advanced find and the results of
that find are more than 10,006 records, when I export that advanced find to
Microsoft Excel it only exports the 10,006. Is this some kind of limitation
of CRM or timeout function that can allow this not to happen?

I changed the general request timeout for CRM itself to potentially fix this
and other issues, however, it hasn't seem to help.

I can however use SQL Reporting Services through CRM and create a filterable
report that returns all the the records and allows me to export to the
maximum excel will allow for.

P.S. If you have over 30,000 customers, and want to create marketing
campaigns for them, it's a little difficult if you cannot even select them
all because over half of them are not returning in your query.

--
JK

Klemer,

Try the simple thing. Break the list into three or four parts (based on A-H
or some other criteria) and try again. This will at least let you know if it
is a limitiation on records or some other cirteria.

Jeff Loucks
888-474-2237
MVP


"TheKlemer" <klemetsrudj@homes.com> wrote in message
news:1BC7DF99-72ED-41B0-AAEC-7821BBCFF39F@microsoft.com...

Hi JK

There's a DWORD registry key called maxrecordsforexporttoexcel or something
like that, which you can create and set to whatever you want as your maximum.

Let's see if I can find this....
Try
http://www.microsoft.com/Businesssol...42d&sloc=en-us

and have a look at Brent's response, which I've repeated here in case the
link doesn't work:

"Run regedit and navigate to:
HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > MSCRM

"Add a new DWORD named maxrecordsforexporttoexcel. This enables to to get
past the 10K limit. "

Cheers,
Ieuan