Question Status

Unanswered
Dhruva Darshan U asked a question on 10 Sep 2013 8:13 AM

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

Reply
Aaron Richards responded on 13 Sep 2013 2:09 PM

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
Support Escalation Engineer
Microsoft Dynamics CRM

 

Reply
Dhruva Darshan U responded on 20 Sep 2013 5:08 AM

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

Reply
Aaron Richards responded on 30 Sep 2013 11:22 AM

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
Support Escalation Engineer
Microsoft Dynamics CRM

 

Reply