Difference between revisions of "Freeside:1.7:Documentation:Accounting:CrystalReports"

From Freeside
Jump to: navigation, search
 
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
<codefreeside/bin/pg-readonly ''freeside_username'' reports</code>
+
<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

  • Use the PostgreSQL ANSI driver
  • Use the username (i.e. reports) and password you configured on the backend.