Crystal reports integration with postgres SQL.
Outline.
1.Download and configure ODBC for postgres. 2.Configure Crystal reports to use ODBC. 3.Start reporting.
Steps to configure ODBC.
1.Download 32-bit version ODBC from the below URL
2.Run the .msi file.
3.Follow the onscreen instruction and complete the installation.
1.Open ODBC data source administrator. 2.Under User DSN , Hit Add.
3.Select the postgres driver.
4.Hit finish.
5.Enter Database information, hit test and hit save.
Database name: ServiceDesk
Port :65432
User name: Postgres Password : Leave it blank SSL mode :Disable
64 - bit machine
In 64 - bit machines, 32 bit drivers won't be listed under ODBC manager. Please open up a run command box and execute the below
C:\Windows\SysWOW64\odbcad32.exe
And configure the driver.
Configure Crystal Reports :
1.Go to File, New -> New standard report.
2. Choose ODBC
3. Select data source and hit next.
4. Enter user Id and hit finish
Enable remote IP address access for PostgreSQL and Ipv6 access.
Please open pg_hba.conf under [ServiceDesk Plus - MSP_HOME]\pgsql\data using word pad. Then find for the below
# IPv6 local connections: #host all all ::1/128 trust
Change it to the below. That means remove # before host keyword..
# IPv6 local connections: host all all ::1/128 trust
Also, under enable Ipv4 access for the Ip addresses you want to give the privilege. An example given below
# IPv4 local connections: | | |
host | all | all | 127.0.0.1/32 | trust |
host | all | all | 192.168.24.111/32 | trust(Example) |
Save the document and restart the postgres server.