Seal Report Forum
»
Report Edition
»
Reports
»
individual restrictions for two fiels
Rank: Newbie
Groups: Registered
Joined: 3/18/2016(UTC) Posts: 7 
|
Hi,
I'm using this platform for reports, and I would need to use a single restriction affecting two database fields. It's possible? If so, how should I do?
For example, if a first field contains "1" and a second field contains "yes" then I show that record otherwise no.
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)
|
You can use a restriction and change the "Operator" property to [Value Only], this will inject only the Value selected by the user in the SQL.
Then you can rewrite the SQL in the restriction text like: (Quantity Or Discount) = [An Input Value 123] to affect 2 columns in your query...
Another way to do it is to change the "Custom SQL" property (e.g. going from 'Quantity to (Quantity OR Discount)).
In both cases, check the SQL generated and adjust it.
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
individual restrictions for two fiels
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.
