I have 5 excel files. All of them have different columns with a common column say Common in all of them.
This common has like 3 different values A,B,C.
I want my report to have like Excel 1 at the top, then Excel 2 below and so on till it reaches final excel file. All these need to be grouped by values A,B,C.
So ideally i would want a report file generated (excel file hopefully) with 3 sheets A,B,C having the data of the 5 excel files segregated into each.
I generated the report using Table with a single detail row and then adding a grid of 5 rows in that table with each row having table with its own excel file. The main Table used the common value as grouping and then each excel file table had their own grouping with a filter condition to be equal to the main table grouping.
One question for people familiar with BIRT Report. When i run the BIRT report locally, it is able to create the groups into each separate excel sheet.
But the moment i upload it to server, it simply pushes all data into a single excel sheet itself.
Any quick fixes?
Could you post some example screenshots of what you see versus what you expect, or want to obtain? Ideally a workflow with dummy data for others to try out would be best.
(Incidentally, any reason you are sticking with BIRT rather than the new KNIME Reporting Extension?)