CRM online Fetch Report fails for a large query

This question is not answered

All,

We have report that is built in Fetch XML and report works fine a small input of dates, but if the date range is huge then report tries to load and fails after some time.

Is there a way that we can change do something to increase the query execution time, We know how to do it from dataset level but from report server level.

Any help is really appreciated.

Thanks,

Dhruva

Consultant, Wipfli LLP

All Replies
  • Hi Dhruva,

    Do you know how many records this should be returning? How long does it take for it to actually time out?

    Thank you for using Microsoft Dynamics CRM Communities,

    Dynamics CRM Support Blog

    Aaron Richards
    Sr. Support Engineer
    Microsoft Dynamics CRM

     

  • This report has 8 static rows and 4 columns. We have about 32 calculated expressions that goes into each cell.

    Calculations are summing based on few conditions. This summing will become huge if the date range is huge.

    It takes about 2-3 minutes before throwing the error.

    Thanks,

    Dhruva

  • Thanks Dhruva,

    It sounds like you are hitting a timeout. I would recommend creating a case with support along with a copy of your report for review and further investigation.

    Thank you for using Microsoft Dynamics CRM Communities,

    Dynamics CRM Support Blog

    Aaron Richards
    Sr. Support Engineer
    Microsoft Dynamics CRM