Seal Report Forum
»
General
»
General Discussions/Other
»
Report from SQL Select to proprietary DB via ODBC connection string, Execute returns no data
Rank: Newbie
Groups: Registered
Joined: 1/25/2024(UTC) Posts: 1  Thanks: 2 times
|
Hello everyone, I am new to Seal Report. I am trying out the tutorial however, when Execute no data is returned and I don't see any error. This is with Report from a SQL Select method. Running SealReport 7.2.0.0 on Windows. Database is proprietary from Intersystems, connected to SealReport using ODBC driver. With the Data Source and Report method, I am getting a table not found error. Any help is much appreciated. Thanks P.S. Sharing screens here, my post is being detected as SPAM. https://drive.google.com...Um0YP6613qd4?usp=sharing
|
|
|
|
|
|
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, I think I guess the error by looking at the screenshots:
Your view named "Model" it still linked to the model "Model" instead of "Model2" (SQL), thus the query sent to generate the report is got from "Model".
Just change the model in the view.
I hope it helps.
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/25/2024(UTC) Posts: 1 Thanks: 2 times
|
@epf Thank you for your help. Indeed that was my issue with the Report from SQL Select.
I did not do step 10 correctly.
Do you have any clue as to why I am getting the error in 5-DataSourceReport-ExecuteError-TableNotFound.png for the Report from Data Source?
What are pros and cons of using Report from SQL Select versus Report from Data Source?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/25/2024(UTC) Posts: 1 Thanks: 2 times
|
I've resolved the issue with Report from Data Source.
When adding table from catalog, the default checkboxes are not enough in my case.
|
|
|
|
|
|
Seal Report Forum
»
General
»
General Discussions/Other
»
Report from SQL Select to proprietary DB via ODBC connection string, Execute returns no data
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.
