Rank: Newbie
Groups: Registered
Joined: 11/23/2019(UTC) Posts: 9  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.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  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...
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/23/2019(UTC) Posts: 9 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.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/23/2019(UTC) Posts: 9 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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 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_crYou may use the scripts to handle what you want, but you need C# skills.
|
|
|
|
|
|
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.
