| Refering to Report fields [message #115001] |
Wed, 06 April 2005 14:19  |
jv68
Messages: 8
Registered: March 2005
Location: Charlotte
|
Junior Member |
|
|
HI friends,
Is there a way to refer to report fields in the query. Or is there a alternate.
Thanks
Joe.
|
|
|
|
| Re: Refering to Report fields [message #115011 is a reply to message #115001] |
Wed, 06 April 2005 15:34  |
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
|
Senior Member |
|
|
yes there is a way and it is very useful.
In a PL/SQL program unit, you refer to fields by preceding them with a colon. So say your field is C_INVOICE_AMOUNT, you can write something like this:
IF :C_INVOICE_AMOUNT < 100 THEN
DO SOMETHING
ELSE
DO SOMETHING IF THE INVOICE AMOUNT IS GREATER THAN 100
END IF;
You can also refer to any "object" in the datamodel in this fashion, including formula columns, summary columns, placeholders, etc. I do not believe you can reference groups or data links though.
HTH,
Steve
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
