Issue while run report.

(0) Share

Report

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.

Thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
WhiteOwl SPanchal 105 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WhiteOwl SPanchal 105 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

I Gusti Made Ari 3,608 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Anks27 1,085 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
WhiteOwl SPanchal 105 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Thanks

Was this reply helpful? Yes No