This content has been marked as final. Show 3 replies
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'xtran_id='||:tran_id||' p_user='||:user||' paramform=no');
No need for '&'. You just need to leave a space between the single parameters contained in the string(you already did this).
set_report_object_property(repid, report_other,'p_1='||:employee.name||' '||'p_2='||:employee.hire_date);
If someone's answer is helpful or correct please mark it accordingly.
Dear AlexDiniasi ,
thanks for you reply.
here my code:
but didn't find / show the 2nd parameter on report p_username, how to debug? where am I wrong?
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'xtran_id='||:ws_sale_m.tran_id||' '||'p_username='||:dummy.user||' paramform=no');
Add the following line at DECLARE Section
then try the following line instead of u'r line
QT VARCHAR2(10) :='''';
Hope this works...
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no xtran_id='||QT||:ws_sale_m.tran_id||QT||' p_username='||QT||:dummy.user||QT);
If someone's response is helpful or correct, please mark it accordingly.*