Home / C:\fakepath\Crystal report integration for postgresql

C:\fakepath\Crystal report integration for postgresql


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.


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

32 - bit machine.


 

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.




     RSS of this page