Generate Report

Is it possible to generate report using Heidi SQL
I need urgent reply.
TQ

You mean a printable report of data rows?

Not directly. But here's how I do it all of the time:
Use right click on a query result, click "Export grid rows". Then select "HTML output" and finetune other wanted options. Press "OK" and the file HeidiSQL then produces is what can be called a report. Well, not exactly, but I'm not sure if the word "report" is such exactly defined. You can also just copy all to clipboard and then paste into MS Word or OpenOffice Writer or whatever. Works nice.

ohh thank you for the reply. i will test out this

i tested it just now and it works. amazing!!
first i open the table. next i right click on selected row of data. then i choose 'export grid rows'. then under 'output target' i select the file location to save this file. then under 'output format' i select html table. next, click ok. finally i open the file where i saved it and tested using Notepad++. Done!!

i have one more question.
if i want it to be automated using php by enable it to filter by date is it possible?

yes. you have to write a php programm that accesses your database, using the same authentication data as you are using in heidisql, and then the same sql query as in heidisql; and then your program has to process the data and output them as csv to the browser. look here for specifying header()s to get a downloadable .csv file instead of displayed data.

yes it works. thank you :)