I keep getting 'Syntax error on command line' when I try to bypass the report parameter form with a custom form writtten for web deployment. Calling a report via the dissables the reports built in parameter form, so this is allegedly the only way to do it.See code below:
(btn_ok on_click)
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_str VARCHAR(20);
BEGIN
/* Check that there is a value to pass to the report*/

if (:block2.unit_dd is null) then /*No value, prompt Homer for unit*/
Message('Please select a unit.',ACKNOWLEDGE);
/*Dumb app, needs this twice to show a dialog box*/
Message('Please select a unit.',ACKNOWLEDGE);
else
/*Make a parameter string*/
rep_str := 'p_unit := ' ||:block2.unit_dd;
/*Set the report up*/
repid:=FIND_REPORT_OBJECT('UNIT_REPORT');
/*try setting all report parameters to see if it solves 'error in command line' error
These are all set in the properties grid for the attached report*/
set_report_object_property(repid,REPORT_EXECUTION_MODE,RUNTIME);
set_report_object_property(repid,REPORT_COMM_MODE,SYNCHRONOUS);
set_report_object_property(repid,REPORT_DESTYPE,PREVIEW);
set_report_object_property(repid,REPORT_DESFORMAT,'HTML');
/*Set the only one that changes at run time*/
set_report_object_property(repid,REPORT_OTHER,rep_str);
/*Run the report*/
v_rep:=RUN_REPORT_OBJECT(repid);/*I keep getting 'Syntax Error on command line'*/
EXIT_FORM;
end if;
END;
Except for the REPORT_OTHER parameter, the others are set in the form's report object proprties.