MOD: moved from APEX
1 person found this helpful
Try the following (I'm not sure if I understand your request well):
1. User Parameter, eg P_TAG:
Datatype = Character
Width = 10
Initial Value = TAG (or empty)
2. Text Boilerplate (in Parameter Form), eg TB_TAG:
- content: &P_TAG
function AfterPForm return boolean is
:P_TAG = 'YOUR TAG'; -- here comes your query
thanks very much for guidance
my scenario is: just show TAG on Parameter Form when it appears in front of user ( it means SQL statement to select TAG should run before Parameter Form appear ), so user can notice that for which Unit of Company he/she is going to generate the report.
TAG is in table Company_Profile.
Where Is_Active = 'Y';
I can add column comp_header for Report's Header ( if possible ) from here instead of using another SQL statement just for Heading.
thanks a lot to help, it really works
I wrote last part ( No. 3 ) using BeforeParameterForm Trigger instead After Form trigger.