If your report has a table (or several) in its dataenvironment, the report will run on that table, and not on any table or cursor you opened before running the report.
This is a frequent problem; on principle, I eliminate anything from a report's dataenvironment (tables will automatically be placed there if you use the report wizard).
HTH,
Hilmar.
>hi,
>
>I create a report with two different conditions in the program.
>In the form, there is a selection of Yes/No. If yes then will run the case 1 else will go to case 2.
>I used sql statement to put the data into a cursor.
>
>For the first time I ran the program, it will display the correct data for both case 1 and 2 but when I run another time without exit the form, both conditions(case 1 or 2) display the same data.
>
>What should be the problem? I checked the program with a wait window, it running the correct codes but the data report displayed are the same.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
