db and dev 10g ,
hi all , my report displays "sal and ename" columns of scott/tiger schema .
i've seen a lot of articles talking about this but i want you to help me to get it :
1- i want to run report by assigning a value to the "report other" property of the report object .
i've tried it like so , i wrote sal = 800 or ename = 'SCOTT' in that property "report other" . and it did not work .
2- and i want to how to do the same with "set_report_object('myrep',report_other,..........) ;
3- i did it before with a parameter list by creating a parameter in the report builder called "p_sal" and p_ename then
created a parameter list with :sal and :ename text_items as parameters then added the parameter list to
run_report_object('myreport',pl) and it did not work too .
please clarify these to me
v := run_report_object(ro) ;
when i press the button , FRM-41214 shows up in the form , and REP-52251 ,and i still can not run it .
do i miss something ?
by the way , when i typed this in the address bar :
http://rocky:8889/reports/rwservlet/showjobs?server=rocky , then clicked "x" button , then
i got this
<br>REP-300: invalid number where deptno = : ==> p_deptno finished with error
Hope you understand...
SET_REPORT_OBJECT_PROPERTY(ro,REPORT_OTHER, 'paramform=no p_deptno='||:dept.deptno);
newbi_egy wrote:It's not clear to me.
thanks to you all , and special thanks to hamid and george ,
i can now run report with one parameter with set_report_object built-in , but now i want to know how to do the task through "other report parameter" property of the report object .
how to do it with one parameter and two parameters ?Ahh! again i said to check my second link for your help. Here is an example
If the parameter value is not number then you have to put single quote both side of the value. Always keep single space before parameter.
REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no one_para='||:btn.one_value||' second_para='||:btn.another_value);
this is not what i am talking about .
when you click the property palette of the report object on the object navigator of forms builder , you see a property called "other reports parameters" .
i think it is for doing the same task ?