Dears
when try to generate below report
Sales & Marketing ==> Reports ==> Statistics ==> Customer ==> Customer/item Statistics
not generate and give attached error message
*This post is locked for comments
hello, I have the same error message but I'm sure that my report does not exceed the number of lines as I'm filtering only for a day, in fact edit the class and I could see the report has 51 lines. What I can do to correct this? Why it happens if the report does not have many lines?
Im using Dynamics Ax 2012 R2,
Sales and marketing > Reports > Statistics > Customer > Customer/item statistics.
Thanks in advance
The method called preRunValidate in Class smmReportsController is responsible for this message being shown (on this particular report). You cannot run the Customer/item statistics report if it is going to print more than 25,000 lines. To get past the error, you should change the reduce the number of lines that you've asked the report to display. e.g. by reducing the date period or reducing the number of customers included.
However, there may be times where this is not appropriate :-)
So, you could increase the Error threshold in the method I mentioned (but it would also apply for a handful of other reports that use this Class). Or, you could modify it so the rowCount for this is report is set to something lower than 25,000 when the error check is made.
Hi,
Thank you for your response. I have tried your solution but still we experience the same issue. I had selected "Do not timeout report" on server level as well as on reports level, but the issue still remains same.
Please suggest.
Hi Tahir,
This is related to a timeout setting of the reporting server. If the preparation of data or processing takes too much time, AX assumes it should cancel proceeding execution of the report. You can change these settings. Have a look at the next page for the details: technet.microsoft.com/.../jj969577.aspx
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 2 Most Valuable Professional
Guy Terry 2 Moderator
Rahul Shah 2
