web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Error on Reporting

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Rajasekhar@MS Profile Picture
    5,569 on at

    Hi

    Could you let us know / show us the error you are receiving

    Regards

    Rajasekhar.Y

  • Community Member Profile Picture
    on at

    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.

  • Suggested answer
    Rajasekhar@MS Profile Picture
    5,569 on at

    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

  • Suggested answer
    keoma Profile Picture
    32,729 on at

    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

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans