We are pleased to announce the release of our new product Smart Pivot Table . This reporting tool is the easiest solution for creating web based pivot table (crosstab) reports from your MySQL databases, without writing any code or conducting any database queries


Version 1.1 comes with an ability to select only the quarter, month or year part from the date information in your database records which enable you to create quarterly, monthly and annual reports from your DB which is a great feature if you are generating financial, performance evaluation or any kind of statistical reports .

Quarterly report generated by Smart Pivot Table


Other Features :

  • Seamlessly export generated Pivot tables to MS Excel worksheets
  • Easily change the appearance style of any pivot table
  • Automatically calculate numerical data including sum, average, min, max, and count
  • Choose only the year or month in the date data, depending on the information need
  • Hide / show columns
  • More


 Suggest new features in the next version of Smart Pivot Table

We believe in continuous improvement , so if you have an idea that you would like to see in the upcoming versions of Smart Pivot Table , or would you like to suggest how an existing feature might be improved, please send it to us , so we can add it in our road map (if it isn’t already there)