QODBC Driver for QuickBooks Enterprise Solutions by FLEXquartersCrystal Reports Setup
How to set up ODBC access in Crystal Reports.
Creating a report with QuickBooks Data
Create a New Report via Wizard or Manual Methods:
Expand the “Create New Connection” Folder:
Expand the ODBC (RDO) Folder to bring up the following screen:
Select “QuickBooksData.dsn” and Click “Next”, then click “Finish” on this screen:
A list of QuickBooks tables now appears ready for selection:
Select several tables for your report (for sp_reports or manual SQL statements, see below):
Link your tables: (For linking information see the Data Layouts)
The table fields are now available for selection in your report. Run reports as normal from this point.
Creating a report with SQL or an existing QuickBooks Report
For sp_reports (see the Data Layouts) or manual SQL statements, Highlight “Add Command” and move the right panel.
The following window will appear. Type or paste your SQL statement or sp_report command as shown, then click “OK”
Your SQL statement is now entered; (to edit, just right click on “Command”). Click “OK”
The fields as specified in your SQL statement, are now available for selection in your report.
What to expect when using the QODBC Driver with Crystal Reports
Copyright © 2005 FLEXquarters.com LLC All rights reserved