Share
Report
1,942Hi All,
I am building a fetchxml based custom report and using a dataset query as one of the parameter, unfortunately it is having 24000 records and i know that fetch accepts only 5000 per request.
Any ideas how to handle this situation? I have to shown all these 24000 records as parameter for the report.
<fetch version="1.0" distinct="true" no-lock="true" returntotalrecordcount="true" >
<entity name="account" >
<attribute name="name" />
<attribute name="address1_city" />
<order attribute="name" descending="false" />
<attribute name="primarycontactid" />
<attribute name="telephone1" />
<filter type="and" >
<condition attribute="statecode" operator="eq" value="0" />
</filter>
<attribute name="accountnumber" />
<attribute name="address1_postalcode" />
<attribute name="address1_line1" />
<attribute name="address1_stateorprovince" />
<attribute name="new_alternatename" />
<attribute name="defaultpricelevelid" />
<attribute name="msdyn_serviceterritory" />
<attribute name="new_travelbillingpolicy" />
<attribute name="parentaccountid" />
<attribute name="new_isparentaccount" />
<attribute name="accountid" />
</entity>
</fetch>
*This post is locked for comments
All responses (
Answers (
