Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Excel Output tab names from Group value in table
Migrateduser
<p>Hi and Happy New Year,</p><p>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.</p><p> </p><p>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.</p><p> </p><p>The attached file has the sample output.</p><p> </p><p>Thank you for your help with this.</p><p>
</p>
Find more posts tagged with
Comments
There are no comments yet