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

Notifications

Announcements

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)
  • 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

  • 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

  • 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.

  • Rajasekhar@MS Profile Picture
    5,569 on at

    Hi

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

    Regards

    Rajasekhar.Y

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans