Report execution error ( Rendering Output for the report failed due to stream too long.)

(3) Share

Report

Posted on by One And Only Naveen

458

Hi,

I have created a Report in AL where i am merging data from two query objects into one temp table, and using that as my report data item.

I have multiple companies in my envoirement,

The problem is this report fails to execute with below error. can someone guide me how can i optimize my code to perform well as number of lines going to keep increase in data. and i want this report to perform no matter what. (execution failing at current stage where number of rows are not more than 8,000 rows.)

Report_Purchase_R...

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (4)

Verified answer

One And Only Naveen 458 on at

Like (0)

Report

After try & error i Found that I was passing Company Picture as data item to RDL Layout and then using it into my report,

Once I removed it Report started working as expected but I am now stock without company Logo on Report, can some one suggest me some work around for this.

Was this reply helpful? Yes No
Verified answer

Alexander Drogin 262 on at

Like (1)

Report

First of all, the company logo is included in every row of the report. Most likely you want to see the logo in the header, but not every report line. The first improvement is to add company information as a parent dataitem for the temp table and remove all related fields from the details.

And even besides the logo, I would challenge the number of columns. Are they all really needed? It would be physically impossible to fit all this information in a page. All the fields in the table amount up to approximately 2.5 KB. For 8000 rows, the data size would be around 21 MB. Most likely, not all the lines will have maximum possible length, so the actual volume will be lower. Still it's a big amount, and probably can be significantly reduced simply by removing unnecessary fields.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,748 Super User 2025 Season 2 on at

Like (1)

Report

Alexander is right, you only need to generate the Company Logo once, and you don’t need to put it in a loop.

Also, is there detailed error information when you click Copy Details?

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

One And Only Naveen 458 on at

Like (1)

Report

@YUN ZHU & @Alexander Drogin

Thank you for response & support,

I have removed it from column and can you please guide me on how to get logo once on header.

I know i am asking a lot but it would be great.

@YUN ZHU I follow your blogs as well get lot of knowledge and concept cleared from you blogs.

Was this reply helpful? Yes No
Khushbu Rajvi. 20,647 Super User 2025 Season 2 on at

Like (2)

Report

Agree with the previous responses, Company logo does not require repeated generation.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,647 Super User 2025 Season 2 on at

Like (2)

Report

Does it mean you want to see the header only on the first page? Hope this helps.http://khushburajvisdynamic365.blogspot.com/2025/01/dynamic-d365-business-central-header-on.html

Does it mean you want to print the logo only in the first-page header and not on all page headers? https://community.dynamics.com/blogs/post/?postid=390fd188-fbda-4bc5-90c8-2ae1aabbc3bd

https://community.dynamics.com/forums/thread/details/?threadid=45d999f9-46de-4358-ae83-fa089907f737

Was this reply helpful? Yes No
One And Only Naveen 458 on at

Like (0)

Report

Hello Mentor's

To get Company Picture and other one time data i applied below method,

Than you for your guidance, I hope this is the correct & efficient way.

Do let me know of your inputs.

dataitem(CMP; Integer)

{

DataItemTableView = sorting(Number) where(Number = const(1));

column(Cmp_Name_RDL; Cmp_Name_RDL) { }

column(From_date_RDL; From_date_RDL) { }

column(To_Date_RDL; To_Date_RDL) { }

column(BU_Filter_RDL; BU_Filter_RDL) { }

column(Vendor_Filter_RLD; Vendor_Filter_RLD) { }

column(Logo; Company.Picture) { }

trigger OnPreDataItem()

begin

Company.get;

Company.CalcFields(Picture);

Cmp_Name_RDL := CompanyProperty.DisplayName();

From_date_RDL := From_Date;

To_Date_RDL := To_Date;

BU_Filter_RDL := Global_Dimension;

Vendor_Filter_RLD := Vendor_Filter;

end;

}

dataitem(Integer; Temp_Purchase_Reg_Table)

{

UseTemporary = true;

DataItemTableView = sorting(Row_No);

column(DocumentType; Document_Type) { }

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (1)

Report

You can check standard sales report how it is being done, and copy the same logic from there.

Was this reply helpful? Yes No