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

Reply via email to