Home » Developer & Programmer » Reports & Discoverer » Oracle Reports Triggers
Oracle Reports Triggers [message #88608] Fri, 06 December 2002 14:06 Go to next message
Robin Browne
Messages: 1
Registered: December 2002
Junior Member

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?


- Robin
Re: Oracle Reports Triggers [message #88639 is a reply to message #88608] Mon, 30 December 2002 19:57 Go to previous message
Messages: 284
Registered: July 1998
Senior Member

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?

Previous Topic: Printing the report content more than once
Next Topic: Row Number
Goto Forum:

Current Time: Mon May 16 20:49:07 CDT 2022