Seal Report Forum
»
Report Edition
»
Reports
»
How do I use input values in SQL Models
Rank: Advanced Member
Groups: Registered
Joined: 5/18/2018(UTC)
Posts: 40
Thanks: 2 times
|
Is there a way to use variables set in the Input Values under General in SQL Models?
For instance, if I have input values set up in the collection as "year" and "month", should a SQL Model with
Select {CommonValue_year} as year, {CommonValue_month} as month
return a one record result with the entered values? If not, what are those called? Or do I need a script in the pre-load script to set the common values to the input values?
Thanks.
|
|
|
|
|
|
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 works (for Common Values not Input Values) In attachment is a sample to display the Common Value prompted to the user.  select common value.srex (5kb) downloaded 6 time(s).Edited by user Friday, December 17, 2021 1:39:29 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 5/18/2018(UTC)
Posts: 40
Thanks: 2 times
|
Where do you declare the common values?
When I go into my report sources 'common restrictions and values', there's no add or remove buttons.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
How do I use input values in SQL Models
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.
