distal-attribute
distal-attribute
distal-attribute
distal-attribute

Generate Report

User, date Message
Written by vanee
5 months ago
Category: General
5 posts since Tue, 29 Apr 14
Is it possible to generate report using Heidi SQL
I need urgent reply.
TQ
Written by ansgar
5 months ago
5023 posts since Fri, 07 Apr 06
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.
Written by vanee
4 months ago
5 posts since Tue, 29 Apr 14
ohh thank you for the reply. i will test out this smile
Written by vanee
4 months ago
5 posts since Tue, 29 Apr 14
i tested it just now and it works. amazing!! happy
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!!
Written by vanee
4 months ago
5 posts since Tue, 29 Apr 14
i have one more question.
if i want it to be automated using php by enable it to filter by date is it possible?
Written by jfalchMoney, Euro
4 months ago
407 posts since Sat, 17 Oct 09
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.
Written by vanee
4 months ago
5 posts since Tue, 29 Apr 14
yes it works. thank you :)
 

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