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