Getting multiple sheets in same excel output using BIRT reporting tool(opensource version)

Question

I need to get multi tabbed output in the final report output in excel fromat. I'm using birt 4.2.0. Any help????

Rappee

Answer 1

From what I've gathered, messing around BIRT, only way to get multi sheet (I assume this is what you consider under term multi tabbed output) in excel format, is possible using custom emitters for xls.

For more info, check out these sites:

• Replacing default birt emitters
• How to create multiple sheets in excel

Kaikaia

was a bit late to thank you. Btw I'm using one of the custom emitters. I'm using modified NativeXLS emitter and it seems pretty good. Thanks again. – Rappee

Answer 2

     options = new EXCELRenderOption(outputFormat: "xls")
     options.setEmitterID("uk.co.spudsoft.birt.emitters.excel.XlsEmitter" )

This creating 40 record per sheet for me . i think no options except the emitter so please try it , but my problem is how list them in a single sheet all of the records.

Rafter

did you find any solution? – Kwarteng

Answer 3

Cause Migration of uk.co.spudsoft.birt.emitters.excel from version 4.4.2 to 4.7.0 is caused this issue. In the updated version, pagination is enabled by default. Hence, all the table containing more than 40 rows are divided into multiple sheets, each sheet containing 40 rows.

Resolving The Problem To fix this issue in IBM Rational Software Architect Designer / IBM Rational Software Architect Designer for WebSphere Version 9.6x and 9.7.x. follow below steps:

Switch to 'Report Design' perspective Select the entire table enter image description here

Go to ‘Properties Editor – Table’ -> Properties -> ‘Page Break’ Change the 'Page Break Interval' field to ‘0’(zero) to get all rows of the document in a single sheet. The default value is 40 i.e., 40 rows grouped to one sheet.

enter image description here

Pneumatometer