Summary vs Detail when exporting to Excel

[system]

We have a summary report (ie no details just the groups and totals for each group). The report appears fine, but when we export the data to Excel, we get the detail rather than the summary. What’s up with that?
TIA
D

---

hueymoo (BOB member since 2005-02-25)

[system]

Hi,

you are probably exporting data from the data manager window - this way you export the data of dataprovider(s), it means the most detailed data as you get it from database.

If you use BO 6.x then get your grouped data (data in the tables) into Excel via File → Save As → XLS format.

Have a look also in BOB Reporter’s FAQ:

FAQ: Reporter

Saving / Exporting to MS Excel There are several ways to get Business Objects data into Excel. Which method works best probably depends on what you want to do with it once you get it there! Copy and paste a Table from Business Objects to Excel This will allow you to take a Business Objects Table into Excel. This keeps the data as displayed (objects, variables, filters, etc.) and will bring the data as it appears in Business Objects into Excel. It will not preserve formatting or for…

Marek

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Saving the report directly in excel format is available in BO from version 6.0 or higher.

If you have more than 1 tab. You have to use ‘Save As’ option individually for each tab.

---

BO_Chief (BOB member since 2004-06-06)