Apache OpenOffice Community Forum

I have created a database having the following tables.

The following to define a product
Product, Colour, Size

The following to enter order, production and despatch on daily basis
Order, OrdersLine, Production, ProdLine, Despatch, DespLine

I have made the forms accordingly and being able to enter the data for daily orders, production and despatch in respective forms.

I need to create a report (which I am doing in excel, by manually deleting previous day's figures and entering today's figures), am enclosing a snapshot of the report from excel.

Can someone suggest how to create a report in a similar format.

Thanks in advance