Kari, If the report is less than 65,000 rows then you can use the following add-in to do it. It provides one click functionality for exporting to xls, pdf, txt. We use at our place without any issues. I havent coded a workaround for >65,000 but you should be fine otherwise…
avaksi 
(BOB member since 2002-08-22)