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.
Consultant, Wipfli LLP
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 RichardsSupport Escalation EngineerMicrosoft 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.
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.