Re: how to link to crystal report
Enrique Sanchez Vela [EMAIL PROTECTED] wrote on 08/09/2005 12:46:44 AM: --- Elizabeth Bonifacio [EMAIL PROTECTED] wrote: Hi guys, I'm new in database development, and has been wondering if anyone can suggest a good reporting tool that will help me generate graphical report for my database queries using visual c++? Can I use excell to format my queries into graph? If all you need is to query the database and create an Excel SpreadSheet, I'd use perl plus the DBI and Spreadsheet::WriteExcel modules. regards, esv. Enrique Sanchez Vela email: [EMAIL PROTECTED] What may be even more simple for her than learning PERL+DBI in order to create Excel files would be to use Excel's native DB querying capability and go through the MyODBC driver to get his data. Then the data would already be in Excel and she can just point a chart object to the data. The problem is, there seems to be a lack of good, inexpensive graphing and charting libraries for the windows platform as compared to the linux platform. Things like Crystal Reports can run you several hundred dollars, depending on what options you want. The other response in this thread listed several good (but not all of then C-based) graphing, charting, and reporting tools. I am sure she can probably find all of the tools/libraries she may need if she searches in the open source community. It may take a little work to port some of them to Win32 but I think that may be a fair trade for the lower cost and more flexible licensing. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
how to link to crystal report
Hi guys, I'm new in database development, and has been wondering if anyone can suggest a good reporting tool that will help me generate graphical report for my database queries using visual c++? Can I use excell to format my queries into graph? My project involves the developement of syslog server in a windows xp environment using mysql 4.1 and visual C++ version 6.0. Aside from the graphical report, my syslog server should be receiving online logs from few network devices such as fortinet and tripwire using sysrose daemon. Can anyone please advice me on which table type will be most suitable for inserting and querying huge amount of syslog on a real time basis? Hoping for your advice. betcha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to link to crystal report
--- Elizabeth Bonifacio [EMAIL PROTECTED] wrote: Hi guys, I'm new in database development, and has been wondering if anyone can suggest a good reporting tool that will help me generate graphical report for my database queries using visual c++? Can I use excell to format my queries into graph? If all you need is to query the database and create an Excel SpreadSheet, I'd use perl plus the DBI and Spreadsheet::WriteExcel modules. regards, esv. Enrique Sanchez Vela email: [EMAIL PROTECTED] - It's often easier to fight for one's||We live in the outer space principles than to live up to them||Rev. Kay Greenleaf Adlai Stevenson|| __ Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to link to crystal report
Elizabeth Bonifacio wrote: Hi guys, I'm new in database development, and has been wondering if anyone can suggest a good reporting tool that will help me generate graphical report for my database queries using visual c++? Can I use excell to format my queries into graph? My project involves the developement of syslog server in a windows xp environment using mysql 4.1 and visual C++ version 6.0. Aside from the graphical report, my syslog server should be receiving online logs from few network devices such as fortinet and tripwire using sysrose daemon. Can anyone please advice me on which table type will be most suitable for inserting and querying huge amount of syslog on a real time basis? Hoping for your advice. betcha I don't know about C++ tools, but as for other tools, you can use: - JPGraph, a php graphing library. It produces very high quality, professional looking *graphs* ( not reports ). It's dual-licensed - open-source for open-source projects, and a commercial license for commercial projects http//www.aditus.nu/jpgraph/ - PDF::ReportWriter, my own Perl module, for high quality reports. I obviously recommend it :) It supports importing images from external sources, so you can, for example, use a combination of JPGraph and PDF::ReportWriter http://entropy.homelinux.org/axis_not_evil - Agata, a PHP-Gtk reporting application. It looks *very* nice, but I've never been able to get it working ( gtk-scintilla doesn't compile on my system ) http://www.agata.org.br/us/index.php - JasperReports, a java graphing library with GUI report designer. I haven't used it ( can't handle Java ), but it looks interesting http://jasperreports.sourceforge.net/ - Papyrus, a C reporting app. I used it for a while before rolling my own PDF::ReportWriter. http://papyrus.treshna.com/ -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]