Can we do Excel Grouping and Outline

[sajeevi]

Hi Team,

i have a group of data in my excel report and i want to group and outline that doc according to groups.I have use iReport and i have added some groups and get the data from DB and generate the Excel report by using Jasper Libraries. (i.e. JExcelApiExporter)

I want to do Grouping and Outline option to theExcel report.

this can be done by usingApache POI - Java API

 

sheet.groupRow(1, 16);sheet.setRowSumsBelow(false);

I want to know can this be done using jasperReport libraries. Since we have groups in jrxml file can we set this option by passing some parameters to JExcelApiExporter or some Other.

Please Help me to fixed this Problem. Its really pain ful to apply sheet .groupRow Since the report is Dynamically generated.

Thanks & best Regards,

Sajeevi

[Teodor Danciu]

Hi,

 

This Excel feature is not available in JR today.

Maybe you can contribute?

 

In any case, you should try post either a request for enhancement or a patch, on our project trackers.

 

Thank you,

Teodor

 

[jayamali]

Hi Team,

i have a group of data in my excel report and i want to group and outline that doc according to groups.I have use iReport and i have added some groups and get the data from DB and generate the Excel report by using Jasper Libraries. (i.e. JExcelApiExporter)

I want to do Grouping and Outline option to theExcel report.

 

this can be done by usingApache POI - Java API

sheet.groupRow(1, 16);sheet.setRowSumsBelow(false);

I want to know can this be done using jasperReport libraries. Since we have groups in jrxml file can we set this option by passing some parameters to JExcelApiExporter or some Other.

Please Help me to fixed this Problem. Its really pain ful to apply sheet .groupRow Since the report is Dynamically generated.

Thanks & best Regards,

[jayamali]

Can we solve this grouping and outlining in jasper excel reports.Can some one help to solve this using jasper reports