preview data in label

[darwish]

hello

i have a table that have about 5000 records.
also i have a report that include a label which is linked to this table.

the problem i have is that when i have heavy data in the table like 5000 record and above, the label is not taking data from first to last record from the table, it is taking from record 1200
reaching record 5000 then it takes record 1 to 1199. therefore when label is previewed, we are viewing data on label from 1200 to 5000 then
from 1 to 11900 and not from 1 to 5000

on the other hand, when i don't have heavy data in the table, everything is working good and the label is getting its data from first to last record successfully.

Is there anything i can do?



thank you for your support

[rpeare]

if your definition of 'heavy data' is a lot of data the number of records shouldn't make any difference. If you are trying to display the 'label' I'm assuming you mean you have a FK (foreign key) in your 'main' table that links to a PK (Primary key) in another table which holds your label. If you run a query linking these two items you should get an expected result. If you are then attempting to build a report that shows these 'labels' but you are having issues with that that's another matter and is likely an incorrect sorting/grouping or putting the label in the wrong sorting/grouping error.