Hi and Happy New Year,
I have designed a number of simple BIRT reports but I need some help. I am using Eclipse Platform Version 3.6.2. Our BIRT programs are executed on an iServer. I am exporting output to Excel in MS Office 2010. I am trying to create a BIRT report that outputs a number of validation error data rows. Each data row has a validation ID and an entity ID as well as other data fields. There will be many distinct entity IDs for each validation ID. I would like to create a report that will export to Excel with a list of all entity IDs and other data fields for each validation ID with each validation ID on a different worksheet tab in the Excel file. When I export this to Excel I want the label of the worksheet tab to be the value of the validation ID. I have provided a sample of what output might look like.
I know that I can create a table called All Validations – first sample output and then I can create another table that will have a group by validation ID – sample output images 2 and 3 below – and I can set the page breaks to break on the grouping. I would like to know how to set the validation ID (which is the group value) to be the label on the page that will export to Excel with this name (i.e validation ID) on the tab.
The attached file has the sample output.
Thank you for your help with this.