Freeside:1.7:Documentation:Accounting:CrystalReports

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

<codefreeside/bin/pg-readonly freeside_username reports</code>

• 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.