Creating Multiple Excel sheets

Engineer

Hi,
I created a birt report and it was working fine also. But i am facing 1 problem. In my query i have 1 coloumn name "CIRCLE" and i want to create different excel sheets with respect to different circle name.And i want generation of excel sheets in single running of report.

Please provide me solution for above mention problem.

Thanks & Regards
Ankit

mwilliams

Hi Ankit,<br />
<br />
Out of the box, BIRT does not have the ability to write to multiple sheets in Excel. You'd have to re-write the XLS emitter to be able to do that with BIRT.<br />
<br />
Actuate does have a product that is specialized for spreadsheets that does have this functionality that you could check out. It's called e.Spreadsheet. You can see the data sheets for it here:<br />
<br />
<a class='bbc_url' href='http://www.actuate.com/products/e-spreadsheet/'>e.Spreadsheet Reporting Tools from Actuate</a><br />
<br />
Actuate BIRT 11 will have new features for the XLS output. I don't see multiple sheets listed as of yet, but that may change. You can see some of the changes for A11 here:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/blog/2009-08-18/free-evaluation-program-for-actuate-11-milestones/'>Free Evaluation Program for Actuate 11 Milestones » Blog - BIRT Exchange</a><br />
<br />
Hope this helps.