Multiple Excel sheet Generation in Pentaho Report Designer

Here we have the data for multiple customers and we need to split the data in multiple sheets for each customer, we need to follow some steps

1. Create a sample report in Pentaho Report Designer and add fields into the layout
2. Click on Create Group and add customer filed to Selected fields from available fields.
   
3. Now Group created on Customer
4. Select this Group and Click on Style
5. Under Style section Go to excel
   
6. Edit sheetname property and add customer field
7. Go to page-behaviour under Style section
8. Set pagebreak-before property as ‘TRUE’
   
9. Save the report, Export the report into Excel and Check

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

10. Now generated excel document have data for each customer in multiple sheets.

Thank You,
Raju
Helical IT Solutions Pvt Ltd

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download