Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Error on Reporting

Posted on by Microsoft Employee

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

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Error on Reporting

    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
    Rajasekhar@MS 5,567 on at
    RE: Error on Reporting

    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
    Community Member Microsoft Employee on at
    RE: Error on Reporting

    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
    Rajasekhar@MS 5,567 on at
    RE: Error on Reporting

    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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans