Seal Report Forum
»
General
»
General Discussions/Other
»
Creating a Restriction to Filter which VIEW to display
Rank: Newbie
Groups: Registered
Joined: 6/17/2019(UTC) Posts: 1  Location: brasilia Thanks: 3 times
Was thanked: 2 time(s) in 2 post(s)
|
I've looked at sample 51, and looked some old Posts here. I created the Views Enum, the script to search the restriction and redirect to the choosen view.
But i can't figure out how to create the restriction without having Seal to create a WHERE clause, and therefore a syntax error.
Can anybody help me?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
This will be changed in the incoming 5.0.
Before the 5.0:
Set the property 'Advanced/Use As Parameter' to true for your restriction. So your restriction will have no impact on the WHERE Clause.
After the 5.0 (coming this week):
Create a 'Report Input Values' from the collection shown in the root 'Views' node.
Warning: the 'Advanced/Use As Parameter' property has been removed from the 5.0, you have to rework your reports when upgrading from 4 to 5.
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/17/2019(UTC) Posts: 1 Location: brasilia Thanks: 3 times
Was thanked: 2 time(s) in 2 post(s)
|
Originally Posted by: epf  This will be changed in the incoming 5.0.
Before the 5.0:
Set the property 'Advanced/Use As Parameter' to true for your restriction. So your restriction will have no impact on the WHERE Clause.
After the 5.0 (coming this week):
Create a 'Report Input Values' from the collection shown in the root 'Views' node.
Warning: the 'Advanced/Use As Parameter' property has been removed from the 5.0, you have to rework your reports when upgrading from 4 to 5. Thanks epf, Worked Like a charm. Just to keep note: Seal is a great product, Powerful Simple and extremely useful for a DBA. We are very excited with the capabilities this software gave to our bussiness.
|
1 user thanked dhd for this useful post.
|
|
|
|
Seal Report Forum
»
General
»
General Discussions/Other
»
Creating a Restriction to Filter which VIEW to display
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.
