Hi, I'am creating a new report, which is a combination of 'form_letter & tabular' style.
I have also created a Report Parameter with 2 inputs, that is 'to_date' & 'from_date'.
The value that will be entered in 'to_date' & 'from_date' in the parameter_form, must get displayed in the report.
So for this, I created a field for 'to_date' & added code for it in pl/sql editor.
code is as below:
function F_TO_DATEFormatTrigger return boolean is
f_to_date date;
begin
f_to_date := :PF_P_TO_DATE; // ASSIGNING VALUE TO FIELD ( f_to_date) FROM INPUT OF REPORT PARAMETER (PF_P_TO_DATE) .
return (f_to_date);
end;
BUT I'M GETTING ERROR " REP-0730 THE FOLLOWING BIND VARIABLE IS NOT DEFINED: PF_P_TO_DATE.
I tried to decode the error, but I think the problem is different. (The above code works only if "PF_P_TO_DATE" was a part of query statement, that is one of the columns in database, but PF_P_TO_DATE is a parameter). So can anybody please help me with how can I take the value from parameter input & display it on the field of the report?
Thank You.