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
rede  
#1 Posted : Thursday, January 25, 2024 11:35:08 PM(UTC)
rede

Rank: Newbie

Groups: Registered
Joined: 1/25/2024(UTC)
Posts: 1
United States

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
epf  
#2 Posted : Friday, January 26, 2024 6:55:08 AM(UTC)
epf

Rank: Administration

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

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.
thanks 1 user thanked epf for this useful post.
rede on 1/26/2024(UTC)
rede  
#3 Posted : Friday, January 26, 2024 2:46:48 PM(UTC)
rede

Rank: Newbie

Groups: Registered
Joined: 1/25/2024(UTC)
Posts: 1
United States

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?

rede  
#4 Posted : Friday, January 26, 2024 2:55:34 PM(UTC)
rede

Rank: Newbie

Groups: Registered
Joined: 1/25/2024(UTC)
Posts: 1
United States

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.
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.