Koolreports or other visualization for website

UPDATE - I'm looking for this to be a reporting dashboard. Should have menu on the left: Sales Customers Campaigns Then some of the widgets will be: Sales by Month / Week - compare them year over year with bar graphs - click on month to see source of sales (product groups drill down) Visitors by Month / week (same comparable) Create controllers and views for Kool reports to work with mysql tables. I have several tables that I would like to have visualized by graphs and charts. I have successfully installed Koolreports but I need help with creating the dynamic reports. I am open to other types of visualization tools, just need to be open source. I will provide the queries, but mostly sales data and geographic data will need to be visualized. Each business has locations, product categories, product subcategories, inventory. We will also need to show results of customer data: sales data, geophaphic data, attendance data. The reports must work within and embedded in a PHP application where user info is stored in a session. The session user id must be passed into the queries to get the proper information from mysql.