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