I am trying to generate a BIRT report based on the following (simplified) SQL tables:
Product (ProductCode, ProductDescription, RRP) - this table has products which are sold and the attributes of the product.StockOnHand (ProductCode, WarehouseName, QtyOnHand) - this table indicates how much of each product is on hand, in each warehouse.
Now I'd like to generate a report where each row shows each product and its attributes, as well as the stock on hand in various warehouses. But I don't know ahead of time which warehouses to show the stock on hand for, as this will be passed as a report parameter.
So the columns of the report would look something like the following: ProductCode,ProductDescription,RRP,Warehouse1StockOnHand,Warehouse2StockOnHand,...,WarehouseNStockOnHand
I'm not clear on the best way to generate a dynamic set of columns. I've come across one solution which is based on building the report in Java code - see https://wiki.eclipse.org/Java_-Build_Dynamic_Table(BIRT).
I am wondering if there is a simpler solution which does not involve writing custom Java code?
