Reports

[expired user #9561]'s profile image [expired user #9561] posted 8 years ago in General Permalink

Hello,

I have query and with the result i would like to put it in à report with Sum/ grafics/pictures/ and so on. Its something like quick report, is there something like this?

I am now doing this by exporting to excel and making it in there, but i need to remake every time.

Benito2313

ansgar's profile image ansgar posted 8 years ago Permalink

HeidiSQL cannot display graphs or diagrams out of results. But you can

  • install the MySQL ODBC driver
  • create a system or user dsn for your MySQL connection in your Windows control panel:
  • and connect your Excel sheet to that odbc dsn

I'm not so much an Excel expert so the last point is quite tricky. I recall there was some button in Excel for loading data from an external source.

Please login to leave a reply, or register at first.