Exporting data to excel/csv

[systemsam]

I have around 50 reports that I need to allow users to export to excel (or csv). However, their request is to have just the raw data available to the report. They want to then be able to do their own grouping, sorting, etc. They have requested just the data that makes up the reports and column headings.

I've read a good bit on this and I have a couple questions:

1) It seems that you can hide bands with a line simular to this:
           net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader
However - not all my reports have the data in the detail band - and they have a different number of bands. etc. Is there any simply way to get the most "inner" band and ignore the others?

2) I've seen lots on excel exports - do CSV follow the same specs? Would it be easier to ingnore spacing, groups, etc here?

 

Thanks for the help!

Sam
 

[systemsam]

Any consultants willing to be paid to help with this?

Sam