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
thsobota  
#1 Posted : Sunday, January 1, 2023 5:49:44 PM(UTC)
thsobota

Rank: Newbie

Groups: Registered
Joined: 11/23/2019(UTC)
Posts: 9
United States
Location: New York

I created a table in one model and I want to use that model as the source for another model.

I have been cutting and pasting the sql from the model into a new table that I create in the source that I created. This is tedious but it works.

It seems that I should be able to reference the columns in one model in a second model.
epf  
#2 Posted : Monday, January 2, 2023 10:32:23 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)
It looks weird to create a table source from the SQL generated by a model.
You may probably ease the process by programming tasks, but it is not clear what you want to achieve...
thsobota  
#3 Posted : Monday, January 2, 2023 11:36:21 AM(UTC)
thsobota

Rank: Newbie

Groups: Registered
Joined: 11/23/2019(UTC)
Posts: 9
United States
Location: New York

Thank you for the quick response. I think that what I am trying to do is trivial.

I created a model called 'sub-model'. It is a table that has columns C0, C1, C2 ...

I want to use the columns in 'sub-model' as input to my main model.

thsobota  
#4 Posted : Monday, January 2, 2023 6:21:25 PM(UTC)
thsobota

Rank: Newbie

Groups: Registered
Joined: 11/23/2019(UTC)
Posts: 9
United States
Location: New York

I found this on the "Reports" documentation web page on sealreport.org . This is what I want to do

"As a model can depend on other model generation
(e.g. you may use the ResultTable of another model
in one of the Load Scripts, but you want to be
sure that is has been executed), the Execution
set property allows to define when the model
is generated during the report execution."

I want to use the ResultTable of one model in another Model. I just don't understand how to use a load script.

The web page says that I need to use a "Load Script" I see a field for

-Pre Load Script
-Post Load Script
-Final Script

But I don't see a field for a "Load script".

I'm guessing that I am either looking in the wrong place or there is a simple script that I put in one of the fields listed above.

Is there and example of how to do this in the Northwind Sample reports?

Regards,
Tom


epf  
#5 Posted : Tuesday, January 3, 2023 7:58:10 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)
> I want to use the columns in 'sub-model' as input to my main model.
What do you mean ? What do you use in your sub-model for your main model ?

If you want to use your sub-model for its restrictions, perhaps you should use Common Restrictions:
https://sealreport.org/Sources#lineTables_cr

You may use the scripts to handle what you want, but you need C# skills.
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.