Issues with PostgreSQL Connection in Crystal Reports

[Sudharsan4]

Dear All,

I have successfully established a connection between Crystal Reports (version 2020) and PostgreSQL (version 16.6) using the ODBC server (version 16.6). After connecting to PostgreSQL, the schemas are listed; however, within the schema, tables, stored procedures, and other objects (excluding functions) are not appearing in Crystal Reports.

Additionally, when selecting a function, the database fields are not being correctly bound in the database fields list. I would appreciate any guidance or assistance in resolving these issues.

Thank you in advance for your support.

[DonWilliams]

When CR connects it queries the DB Server for all of the PS, Views, Tables etc.

It can run out of space to load all of the info.

To add filtering right click on the Connection and select Options:

Uncheck all but one of the Data Explorer Options and see if you can see them now. If try adding filtering in the Like% options to see if that helps.

FYI, 16 is not currently supported:

PostgreSQL	PostgreSQL (21)	9.6	ODBC		PostgreSQL 9.6 ODBC	End of Support
JDBC		PostgreSQL 42.1 JDBC	End of Support
10	ODBC		PostgreSQL 10 ODBC	End of Support
JDBC		PostgreSQL 42.2 JDBC	End of Support
11	ODBC	New	PostgreSQL 11 ODBC	End of Support
JDBC	New	PostgreSQL 42.2 JDBC	End of Support
12	ODBC	BI 4.3 SP01+	PostgreSQL 12 ODBC	Direct
JDBC	BI 4.3 SP01+	PostgreSQL 42.2 JDBC	Direct
13	ODBC	BI 4.3 SP02+	PostgreSQL 13 ODBC	Direct
JDBC	BI 4.3 SP02+	PostgreSQL 42.2 JDBC	Direct
14	ODBC	BI 4.3 SP03+	PostgreSQL 13 ODBC	Direct
JDBC	BI 4.3 SP03+	PostgreSQL 42.3 JDBC	Direct
15	ODBC	BI 4.3 SP04+	PostgreSQL 13 ODBC	Direct
JDBC	BI 4.3 SP04+	PostgreSQL 42.3 JDBC	Direct