Dear BIRT Gurus,
I am come up with a quite simple yet difficult requirement to export the birt report in one excel sheet (xlsx). I have a dataset which contains data for more than 40 records while I am displaying it in the browser using a simple table in birt the data is splited in 40 records per page that is absolutely fine while browsing in the browser. I want to export the birt report data in excel sheet while I am doing this using birt report export dialogue by selecting export to XLSX that data is exported to multiple excel workbook sheets each sheet contains 40 records or so. Whereas, I want to export the data to one single sheet in excel.
Could you please help me to achieve this requirement.