| Oracle Reports Triggers [message #88608] |
Fri, 06 December 2002 14:06  |
Robin Browne
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
Hi,
I'm trying to call different queries based on parameters that are entered. I thought this could be done using the Report Triggers, however, I'm not familiar with their usage. Any suggestions as to how this can be done?
Thanks,
- Robin
|
|
|
|
| Re: Oracle Reports Triggers [message #88639 is a reply to message #88608] |
Mon, 30 December 2002 19:57  |
Mark
Messages: 284
Registered: July 1998
|
Senior Member |
|
|
Robin,
Let me know if you have not gotten the answer to your question. It is a little vague and that might be why you have not gotten a response.
Triggers can be used to "turn-on" or "turn-off" a query by setting a variable to True or False based on logic in the trigger. Then that variable can be added to the where clause of a query you want to toggle, ie AND variable = 'True'.
You have to deal with the format of the output, but frames can have print conditions as well.
Is this the direction you are trying to go?
Mark
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
