Import BO 6 report to Excel

Hi corinereyes,

Does "BO" refer to Business Objects (Crystal reports)? If so, I think you did answer your own question.

Other reporting tools don't contain any data, they just query a data source, so pointing excel to the report document won't do much good. With BO (Crystal) you can export to Excel, though.

If you want to work with the data directly in Excel, then you would need to link to the specific database type (SQL, Oracle, etc.) via the Data -> Import External Data -> New Database Query menu.

Hello Paul,

I' am referring to Business Objects. Thanks for your info, i just found out that you can "Save As" BO reports into an excel file (.xls) but i finding a way to automate it, so if you query from other database to BO and everytime i refresh the report in BO it will automatically update the data in Excel.

Thanks again for replying to my question.