Data different on print from preview

[nyzja]

Hello! I have a report with about 15 rows of data from a crosstab query. The preview looks fine but when I print, I get only the last line of the data printed 15 times (in 15 rows). If I export the report into Excel or RTF, I get the same result as the printout. But if I do a direct print, the report data is fine. So in my ReportHeader_Format section, I tried to add myRS.movefirst but I get an error saying "Operation is not supported for this type of object."

Please advise. Thanks!

 

[THWatson]

nyzja
Is the report driven by parameters from a form? If so, it could be that the form is being closed when the report goes into Preview mode and prior to the printing.

Tom

 

[nyzja]

Thanks for the response, Tom!

No, all I have is a simple button that opens the report in preview mode, no parameters or any other filters.