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????

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

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.