EXCEL/WORD formatting.

building reports desktopintelligence
1

I was wondering whether there is some way to save (or to export) a BO report as EXCEL format and/or WORD format. I guess there should be some easy way to do it different than using the rtf format … Any suggestion about this?

JAD (BOB member since 2004-07-23)

2

Business Objects v6 offers the functionality to Save As MS Excel.

Otherwise you could do a manual Select All, Copy All from the menu Edit.

Andreas :de: (BOB member since 2002-06-20)

3

Hi,
You can save the report as excel by going thorough the Menu FIle-save-save as excel file.

Rajasekar :india: (BOB member since 2004-07-16)

4

I don’t see what is wrong with using the save as RTF option if you want word documents?

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

5

You can also export to excel through the data manager. This however only exports the raw data in the cube and not the formating of the report. You may need your supervisor to add this functionality to your user id.

Don’t forget the limit of 65536 rows in Excel.

jmmorton :uk: (BOB member since 2004-07-05)

6

Thanks for the answers.
The cuestion is that currently I have BO v.5 so I don’t have available the feature of saving as .xls file.
The option of select all, copy all and paste doesn’t seem to work at least for me because it doesn’t copy the data but instead just an equation. However this could be solved saving the file as rtf and later on copying from there. With this way the problem is that I would got the data but not the format.

However was I’m looking for is some way to get both data and format saved in an .xls file. Maybe it is not possible in BO v.5?

Regarding WORD. I have tried the .rtf format and it works more or less but the problem is that when I open the file in word, the tables don’t look very nice and the format is sometimes awful. That is why I was wondering whether there is some other way of doing it.

Thanks to all again.

JAD (BOB member since 2004-07-23)

7

Be sure that you do NOT have the report in structure mode. Your Copy All / Paste will bring data over to Excel.

Correct. This was a much requested feature, and was added in V6. A workaround is to do a Copy All / Paste into Excel, then apply your formatting manually in Excel. If you do the Excel formatting without moving any cells, adding or deleting any rows or columns, or anything like that, you could save this Excel sheet as a template of sorts and always copy paste back into the formatted template. Of course this only works if the number of rows / columns is fixed.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

8

JAD,
There is a work around if you want to convert a report to excel format: just save it as html and then opent the *.htm file from excel. You will find the *.htm file under a folder named as the report is.
Other possibility: you can find a document convert in BOB, in the downloads forum.

I hope this helps. :slight_smile:

timacle :es: (BOB member since 2004-07-27)