BusinessObjects Board

Exporting Problem

Hi, i have a report with 2 Data Providers. my user need to export this report into excel file. if i am using BO’s export format it exports the data provider wise. so the data in excel file is different form what i am showing in the report. how to export the Report to excel with out changing the format. Please help me …

Sasikumar.M :india: (BOB member since 2003-08-01)

Have a Look here Reporter FAQ


Sridharan :india: (BOB member since 2002-11-08)

Or alternatively save as HTML document and open that through Excel.


dezza :poland: (BOB member since 2003-06-10)

If you have version 6 then Save as XLS comes as standard and preserves formatting.

Nick Daniels :uk: (BOB member since 2002-08-15)

Have you tried the export script from the BOB Downloads section?

Have you tried going to the menu bar, click on Edit>Select All. Go to Excel and hit Ctrl V. This should copy the data as you see it on the report.

Jim (BOB member since 2003-02-14)

That should be Edit–>Copy All… :smiley:

norty303 :uk: (BOB member since 2003-03-19)