Report printing out of sequence

[WAVP375]

Simple report with Record Source select query. No filtering and no Order By on load. The query has all records in proper sequence. There are about 300 records to be printed. The report prints the first 50 or 60 records then skips to the middle of the file and prints to the end. The prints the records that were skipped . No where else to look.



Any help

Thanks

[ranman256]

The query sort has nothing to do with the report.
you must sort the way you want IN the report too.

[Micron]

Do you have any Grouping set up in the report? Do the results seem to be grouped in some way? Any sorting? There are Grouping/Sorting options that might be applied. No report events using any code (procedure)?

[WAVP375]

Thanks. I did noy know that the query sort did not matter. I have added Order by in the form load and it has solved the problem.

Thanks a lot