Quick Books and Crystal Reports

[ericb1]

I've been asked to create some reports based off of QuickBooks 2005. Now when I go into the data connections of Crystal, I see a ton of different data sources listed, but I don't see Quicken or Quick Books. (a .qbw file)

I googled it and see different 3rd party solutions, including qodbc.com, which seems to be selling an ODBC connection for QuickBooks.

Has anyone ever connected to QuickBooks, and does Crystal really support this, etc. Any help is greatly appreciated, thanks!

 

[synapsevampire]

Crystal supports ODBC.

How to extract the data is quite a different story, you need to understand the table structures.

-k

 

[ericb1]

I don't understand. I know that Crystal supports ODBC, but QuickBooks doesn't? Is that why I need to purchase this QODBC driver? So that I can connect to the .QBW file under my list of ODBC sources in Crystal?

 

[synapsevampire]

Sort of, Quickbooks doesn't have an ODBC driver, so others saw an opportunity and wrote it.

-k

 

[dgillz]

The following link has info on a quickbooks ODBC driver:

http://www.qodbc.com/qodbc.htm?source=CRUN

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[MrBubbles]

I use the FlexQuarters QODBC driver and it works GREAT! The better news is, the next release of QuickBooks (Pro or Enterprise... I am not sure) is going to include this ODBC driver for free!

 

[IdoMillet]

There are specific instructions on using QODBC with Crystal Reports at:

http://www.qodbc.com/qodbccrystal.htm

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com