Seal Report Forum
»
Report Edition
»
Reports
»
Report parametrization and using a query as part of a parameter
Rank: Newbie
Groups: Registered
Joined: 2/20/2019(UTC) Posts: 2 
|
Hello all, I'd like to know if the specific method to acquire and use a parameter from restrictions as given here: https://sealreport.org/f...=posts&t=278#post630 is still considered current, as although it might be fine for one or two parameters, it would get cumbersome with more complex reports. Also, it might require additional validation in order to prevent SQL injection attacks. Furthermore, I'd like to know if it's possible to use a previous query (Say, for example, obtain all the transaction types that actually happened in a given month in order to then proceed to query for sales, provider payments, etc.) to populate an enum. Thanks in advance! Edited by user Wednesday, February 20, 2019 8:38:57 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
No, no real update for this needs...
Note that you may also use Report Tasks combined with stored procedure to built up temp tables in your database (if you can).
Enumerated list can be dynamic and based on a query (use the 'Select SQL Statement' in the Enum definition).
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
Report parametrization and using a query as part of a parameter
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.
