Hi, I get this error when trying to run Customer Detail Aging. Is it because there is too much data in the system and needs to be filtered? Or something else?
*This post is locked for comments
Hi, I get this error when trying to run Customer Detail Aging. Is it because there is too much data in the system and needs to be filtered? Or something else?
*This post is locked for comments
hi
this is a funny error presented by MS. the sql report engine does not manage the memory very well. it's easy to get that error.
so what can you do: only send the really needed data from nav to the sql report.
that means: do not filter data in the report but in the dataitems
use labels instead of text fields
do not send the same information twice or more.
be aware of the structure of the dataitems.
AND: use only few small or better no images in the report.
the usage of (large) images is the most reason of that error.
the less data the report gets the better it is.
cheers
Hi
refer to the below link for the details.
ppe.blogs.msdn.com/.../rdlc-report-and-performance-in-microsoft-dynamics-nav.aspx
Regards
Rajasekhar.Y
Hi, I pasted the screen shot but seems to have disappeared, below is the error:
An error occurred during local report processing.
An unexpected error occurred in report processing.
Exception of type "System out of memory exception" was thrown.
Hi
Could you let us know / show us the error you are receiving
Regards
Rajasekhar.Y
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156