Exporting to CSV with groups

[Smithsc]

Hi,
I'm using CR2008 and I'm trying to export to CSV a report that has 1 detail section and multiple Group Footer #1 (a,b,c) sections. The problem is that only the detail section is being exported to the csv file.
When viewed on screen I can see all records but the export file is only showing the detail section.
Has anyone else had this problem?

 

[hilfy]

When you export to CSV, there are several options. In order to get all of the group footers you'll want to do this:

- Make sure that Export Group Sections is selected
- Play with the Isolate Group Sections checkbox - I think it needs to be checked, but I'm not absolutely certain.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[Smithsc]

Thanks for the help.
Unfortunately that didn't work. Tried it with Export Group Sections selected and Isolate Group Sections checked and not checked. No difference

Any other ideas?

 

[IanWaterman]

I dont think you can export to CSV with formating and grouping. Its a bit like the option to export to Excel (data only).

When exporting to CSV this is usually becuase you want to import into another database. Why do you want to keep formatting and grouping.

Ian

 

[Smithsc]

I don't mind about anu formatting. Each part of group 1 holds a subreport (sorry forgot to mention that earlier) and I need this info in the report.

 

[Smithsc]

Just found out that CR2008 doesn't export subreports to CSV files. Does anyony know if this has been addressed in CR2011?

 

[hilfy]

No, it has not. This is the way the CSV export is designed to work, so no one at SAP sees it as an "issue".

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com