Show parameter field value in margin text box [message #430700] |
Wed, 11 November 2009 17:22 |
|
Hello All,
Am using the parameter form , where am using parameter date field
(:pdate).
After press the enter ,i wants to show in margin with text and parameter value in the following
Report for to_char(:pdate,'yyyy').
Please support me in this..
normally for summary and formula column i used to do &summ_nam_col.
But for displaying the parameter variable its not showing ..
Thanks in advance..
|
|
|
|
|
|
|
Re: Show parameter field value in margin text box [message #430824 is a reply to message #430799] |
Thu, 12 November 2009 07:28 |
|
Thanks Ram.
I did the validation trigger .The following code i written inside the validation trigger
function PDATE1ValidTrigger return boolean is
V2 VARCHAR2(4);
begin
V2 := TO_CHAR(:PDATE1,'YYYY');
return (TRUE);
end;
I struck here now.If you dont mind can you provide screen shot please.
|
|
|
|
|
|
|
|
|
|
Re: Show parameter field value in margin text box [message #430983 is a reply to message #430700] |
Fri, 13 November 2009 09:19 |
|
I have got it ..since one of my friend has helped me the same to get it done..
Thanks for all your time bro ram..
i Just write down what my friend has told
1. Create a parameter P_DATE under User Parameter section and make the DataType as Character.
2. Add the coding in Report Trigger->After Parameter Form
function AfterPForm return boolean is
begin
SELECT TO_CHAR(TO_DATE(:P_DATE),'YYYY') INTO :P_DATE FROM DUAL;
return (TRUE);
end;
3. Take a Field in Report layout form and choose Field Source as P_Date. Then run the report.
|
|
|
|
|
|
|
|