>is 'invoice' the parent record? are you using the table name or an alias?

There is only the (1) table "Invoice" no alias.

Please no one go to alot of trouble, I'll re-write the code to select into cursor and print from there. I was just curious as to why what seemed to be a simple call to a report could cause such a crash.

Thanks
Ricky