PERIODIC REPORT GENERATOR

  1) This tool was developed in microsoft access to generate a period by period tabular and graphical output directly in excel as shown below, or as part of a batch file process, saved unto a specified directory in the configuration file.
 
  2) Another variation to the output that this tool generates. In this case, the total value of orders for each month in the year of 1997, as extracted from the Northwind.mdb database sample.
 
  3) Total number of orders by each customer in each month of the year 1997.            
 
  4) This is the tool without an output. You can see how the repetitive looping aggregated sql queries are created, and the input textfiles which go in to supply data for each loop within the query. This tool can generate more than 72 parallel sql queries at the same time.
 

 

Reports created, designed and presented by Olaseni Durojaiye