Difference between revisions of "Freeside:1.7:Documentation:Accounting:CrystalReports"
From Freeside
| Line 7: | Line 7: | ||
* Grant the new PostgreSQL user read-only access to the freeside tables | * Grant the new PostgreSQL user read-only access to the freeside tables | ||
| − | < | + | <code>freeside/bin/pg-readonly ''freeside_username'' reports</code> |
* Allow the new PostgreSQL user access from the host which will be running Crystal Reports. | * Allow the new PostgreSQL user access from the host which will be running Crystal Reports. | ||
Revision as of 18:43, 28 December 2006
Configuring Crystal Reports to access Freeside
Configure the Freeside backend
- Add a PostgreSQL user
createuser reports
- Grant the new PostgreSQL user read-only access to the freeside tables
freeside/bin/pg-readonly freeside_username reports
- Allow the new PostgreSQL user access from the host which will be running Crystal Reports.
Configure the Crysal Reports client
- On the machine running Crystal Reports, download and install the current version of the PostgreSQL ODBC driver from http://www.postgresql.org/ftp/odbc/versions/msi/
- Use the PostgreSQL ANSI driver
- Use the username (i.e.
reports) and password you configured on the backend.
