trouble with report: Too many rows

IvanB

Hello! Can you help me. I created new report and run on preview. Total rows in the report 19000. I get error "Stream was too long". Why can't show 19000 rows?
Nav2016

Slawek_Guzek

Hi,

Check if you don't have anything like a picture or other BLOB data anywhere in your dataset.

Slawek

RockWithNAV

Picture, Blob, Loop, Clearance of variables check everything OR eventually debug you will find the real culprit.

vaprog

Why does does the thread caption read "...: Too many rows" when the error message says "Stream was too long"?

Did you jump to an unwarranted conclusion, or do you have more indication for this?

A quick google search let me believe, not enough memory is the reason for the error message. So, try to reduce the size of the data in the dataset. I believe, structuring (indenting) the data items and keeping fields as "outdented" as possible may help. For instance, it makes little sense to transmit a company logo with every row.

Slawek_Guzek

Hi,

Check if you don't have anything like a picture or other BLOB data anywhere in your dataset.

Slawek

RockWithNAV

Picture, Blob, Loop, Clearance of variables check everything OR eventually debug you will find the real culprit.

zaidtariq

Can you show me the dataset and layout?

vaprog

Why does does the thread caption read "...: Too many rows" when the error message says "Stream was too long"?

Did you jump to an unwarranted conclusion, or do you have more indication for this?

A quick google search let me believe, not enough memory is the reason for the error message. So, try to reduce the size of the data in the dataset. I believe, structuring (indenting) the data items and keeping fields as "outdented" as possible may help. For instance, it makes little sense to transmit a company logo with every row.

IvanB

Hi all! Very thanks all! The error was in blob fields.

souoik

waht the solution you applicat

Alce

I have the same problem, and in my report i have a blob filed. What is the solution of this case please?

Alce

I have the same problem, and in my report i have a blob filed. What is the solution of this case please?

Slawek_Guzek

@alce redesign the report structure and move section the BLOB field to a section that is not repeated. Then use the code inside the report to get the BLOB data to the control in place where you need it

The trick is to base the very first Data section on the Integer table, limit iterations to just one, and add all BLOBs as variables calculated in the code and exposed as columns in that sectoin.

Or investigate ForNav Reports - far, far better and cost-effective solution for creating and maintaining reports in NAV/BC