MaterData row count

Hello,

I have a query that has about 345 rows, the masterdata band when printed only shows up to row 244. I have set the page for endless height and endless width. From what I can see there is nothing special about the 245th record so I don't think it is the query at all.

Any tips?

Can you post couple of screenshot so we can see what the problem is?

Sure,

I apologize for the censoring, it is the only way to compare records but it is also our customers personal info.

SQL Server:



ATE Tool:




as you can see the SQL server screenshot has more records

Some data looks duplicated.
Perhaps yo are using group by in sql?

Here is my example works fine

Pdf file attached

There are definitely no duplicates. It appears there are because of the censoring but they are actually different numbers. I have only had the problem when I have 250+ records being returned. I also have Endless Height and Endless Width check but still no luck.