I'm doing a project in which I need to produce a monthly order view.

The users will do a order for everyday of the month, and the system needs to create a view, a table view of all orders of the month, this table must have in the vertical first column the order number, one for each day, and in the horizontal row must have all the products that the user order... something like this image:

http://corporativovive.com/aldo/example.png

I was trying to do this with the DataTables module (http://drupal.org/project/datatables/) but I wasn't able to choose the product item field, I can only get the Line item field, and it contains everything, but not in the format I require, is it possible to do it??

Thanks a lot!!