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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Issue while run report.
Small and medium business | Business Central, N...
Answered

Issue while run report.

(0) ShareShare
ReportReport
Posted on by WhiteOwl SPanchal 105

Hello All,

I am facing the issue while run custom report into Business Central but when invoices are more then 200 then it gave error as an error occurred while trying to display the report. and if i click on print button then it show me blank page.

pastedimage1579790767932v1.png

Thanks.

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • WhiteOwl SPanchal Profile Picture
    WhiteOwl SPanchal 105 on at

    Hello Gusti,

    Thanks for solution i have done same thing which you suggested and now report is working for all the invoices. But one issue i am facing after adding integer DataItem is first page showing me blank data.

    pastedimage1580287472858v1.png

    So, Can you please suggest me solution and tell me if i am doing wrong.

    Thanks

  • Anks27 Profile Picture
    Anks27 1,085 on at

    Correct, we got it but if we are not using temp table then to avoid this loop issue where we can put?? now we are sure that this is causing issue because of image only, we used below code under "onInit trigger" but still it's not working and same blank page is coming for bulky invoice. (we are using Business central online version 15.2.39060.0)

    companyinfo.get();

    comapnyinfo.calcfield(Picture)

  • Verified answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,608 on at

    If you put it on header it will loop as X time of your total invoice .Try to Put it on Integer data item set to loop only one time.

    pastedimage1580174689093v1.png

  • WhiteOwl SPanchal Profile Picture
    WhiteOwl SPanchal 105 on at

    Thanks for the response Gusti.

    yes, it only have company logo and i have added into header dataitem.

    I am only facing the issue when i run report without any filters mean (for all the records). otherwise it working perfectly for 70 or 90 invoice.

    Let me know if you have any idea.

    Thanks

  • Verified answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,608 on at

    Does your report have any images ? if images being loop for every record it may cause memory issue . If it just Logo image , put it on integer data item and loop it just once

  • WhiteOwl SPanchal Profile Picture
    WhiteOwl SPanchal 105 on at

    Hello Gusti thanks for the reply,

    I have checked all the fields are available into tables and issue only raised when data have more than 200 pages.

    Thanks

  • Suggested answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,608 on at

    Check if it's the same case as here : 

    https://madearipermadi.com/2019/11/19/error-an-error-occurred-while-trying-to-display-the-report-when-running-report-in-business-central/

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…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,476

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 789 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 719 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans