Seal Report Forum
»
Report Edition
»
Data Source Creation
»
Can't create joins automatically with ODBC driver
Rank: Newbie
Groups: Registered
Joined: 11/12/2018(UTC) Posts: 2 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. 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
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 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.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/12/2018(UTC) Posts: 2 Location: Uden
|
Thanks for your Reply.
Which drivers/methods does the auto create join function support?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
|
MsSql Server and Oracle for sure...but I do not know for the other databases.
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
Can't create joins automatically with ODBC driver
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.