create report console to see totals by numbers and graphs

Need to make a console that allows the user to pick a time period to show the results of sales based on the hour the sale was made each day. Attached to this query is a table that contains all orders and their size. We want to be able to see how many orders per hour happen along with the amount of money taken in per each hour. The console should allow the user to pick a time period to be reported on and the company or spawn name or agent initials The data results should be printable but also the console should show the summary info in a graph format. the user should be able to pick an agent initials from a combo box and have the console display his number of sales and totals on the screen. The results needs to be printable.