drill down reports
From: Horace Rashid Knights <hknight1_at_nycap.rr.com>
Date: Mon, 16 Nov 1998 22:18:31 GMT
Message-ID: <3650A5F2.D697423D_at_nycap.rr.com>
we are tring to make dynamic drill down report with/in a form. the "associatenum", a column name, would be passed from the form to the report
but we keep getting a compile error that says the SRW.run_report is not declared. SRW.run_report is supposed to be a pre-defined
call procedure.
The Syntax is:
Date: Mon, 16 Nov 1998 22:18:31 GMT
Message-ID: <3650A5F2.D697423D_at_nycap.rr.com>
we are tring to make dynamic drill down report with/in a form. the "associatenum", a column name, would be passed from the form to the report
but we keep getting a compile error that says the SRW.run_report is not declared. SRW.run_report is supposed to be a pre-defined
call procedure.
The Syntax is:
any suggestions?????
The Syntax is:
Declare
vreturn varchar2(100) := SRW.run_report('REPORT15
P_LAST="'||:ASSOCIATES.Assocnum ||'"');
begin
if vreturn is not null then
message('your an ass hole: '|| vreturn);
synchronize;
end if ;
end;
Received on Mon Nov 16 1998 - 23:18:31 CET