Report on Production Orders giving full details

Dear Experts

My client want to have a report in which they can see cost details production order wise. To make it clear All production orders (for all products) for a given period (better if dates can be given and the cost components can be drilled down) should come in rows and all cost components should come in columns. Sample is given below:

Production order Material Qty produced Cost comp1 Cost comp2 Cost comp3 Cost comp4 Cost comp5..............

300005 ABC 1000 20000 5000 6000 7000 8000

300006 XYZ 1000 30000 4000 5000 6000 7000

300007 ABC 1000 20000 5000 6000 7000 8000

.

.

.

.

This all they want on single hit. Through order summarisation reports I can see order wise for a product at one time but not orders and products altogether. Actually this way they want to see how the costs have been used for production.

With thanks in anticipation and high regards

Rajneesh Saxena