>i hv to seperate 20 record into 2 and each of the report will print out 10 of it, this part i finish. i call the report twice and do this. but a problems came out that, each time i call the report , the report will start print the first page first, that is correct , but then it will continue to print ...print and print ..non-stop.......
>every time , i need to close the preview , then the next report will come out, but the same problem, printing non-stop, only the first page is correct~!
>what's my problem?!pls give me some hints about this! THX
If you know that you're going to preview, don't use a filter to establish the data set for the report; the use of a FOR clause on the REPORT command line in particular is known to have problems in this situation - the first pass through the data enforces the filter, and the filter is lost when the data is rewound in preparation for a second pass over thesame information.
You'd be better off selecting the data into a cursor and reporting against the cursor, so that you don't need the filtering FOR clause.