>I issue a report form command with a for statement with three conditions and a preview along with it. The print preview box comes up correct and in the example I am running based on the conditions, and verifing this at the table level there is 25. The problem is that when I press the print button on the preview screen I get random valid numbers of records showing up. Why is it that the preview also shows up correctly, but I can get random counts on the printout? I thought as the processing of the conditions was done prior to displaying the preview box and the print was just to tell it to dump that result to the printer. I have no filters or anything on the tables themselves and no grids on the form. I simply set the index for the table and report form for...
At one point, there was a bug with the FOR clause of the REPORT command doing exactly what you are seeing. The better way to handle that kind of output is to pull the required records into a cursor first, and then use that cursor for the REPORT.