Creating a report from a shopping cart

We have a client who would like to create two reports from there website sales:
1. Order Report (Individual orders by due date including (item name, qty, customer name, and pick up or delivery date)
2. Production report. Giving qty total of each specific product by due date (item name, qty of each item and the due date for the item (e.g. on August 28 they need 55 Red Velvet cupcakes made for either pick up or delivery)

We would like to know if or how this can be done. There store has already been created, we now need to set up these reports. I'd be happy to include any files if needed.

Any direction would be greatly appreciated.

Thanks,
Jackie

this type of report is really nothing more than a recordset used to populate a dynamic table on the page.

it is a matter of creating a recordset to return the appropriate data from the stores table, and using a dynamic table to display the results.

Both of these reports would need to used a joined query to return related information from the Orders and Order Details table.


SQLYog and Navicat are 2 good MySQL GUI tools that have good Visual Query designeres to help quickly create complex queries that include JOINS and row counts and groupings for the types of results you are looking for.

You can design the query in a GUI Tool, then copy the SQL into a dreamweaver recordset, and add Dynamic Table (insert -> Data Objects -> Dynamic Data -> Dynamic Table) to display the result on your page