logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
dwergman25  
#1 Posted : Monday, November 12, 2018 12:21:56 PM(UTC)
dwergman25

Rank: Newbie

Groups: Registered
Joined: 11/12/2018(UTC)
Posts: 2
Netherlands
Location: Uden

Hello,

Maybe I'm using or understanding the "auto create joins" function wrong, but I can't get it to work. When I try to add tables from the catalog function. I make sure that the "Auto create joins" function is checked. However no joins are being loaded.

If i try to add joins via right mouseclick on Joins and use the "Add Joins from Catalog...". I get a pop up saying that Joins cannot be read from the database for 'Microsoft OleDB provider for ODBC drivers'... If possible, use another OleDB provider for your connection.


asd

Is it so that I can't use the ODBC driver for creating joins automatically? If so, what are my options? I'm using Seal Report Designer on the server where my PostgresSQL is located.

Thanks.

Edited by user Monday, November 12, 2018 12:24:21 PM(UTC)  | Reason: Not specified

epf  
#2 Posted : Monday, November 12, 2018 3:29:26 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
Yes, it looks like that joins cannot be read from a PostgresSQL driver...
Sorry, but we have no experience with PostgresSQL.
You have to add your joins manually.
dwergman25  
#3 Posted : Monday, November 12, 2018 4:05:08 PM(UTC)
dwergman25

Rank: Newbie

Groups: Registered
Joined: 11/12/2018(UTC)
Posts: 2
Netherlands
Location: Uden

Thanks for your Reply.

Which drivers/methods does the auto create join function support?
epf  
#4 Posted : Monday, November 12, 2018 4:45:51 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
MsSql Server and Oracle for sure...but I do not know for the other databases.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.