| srw.message [message #89540] |
Mon, 10 May 2004 23:04  |
fatimah
Messages: 9
Registered: February 2004
|
Junior Member |
|
|
First of all..tanks to jeslie n Maz..but i'm not quite sure how to use it...i tried to use the following code in after parameter form:
if :count_detail=0 then
return (FALSE);
else
return (TRUE);
end if;
end;
then an error comes out says:
REP-0749:After form trigger cannot reference a report column
maybe u can give me the correct coding samples...
rely need a help.. (-_-)
|
|
|
|
| Re: srw.message [message #89544 is a reply to message #89540] |
Tue, 11 May 2004 21:33  |
Afroz ahmed
Messages: 13
Registered: February 2003
|
Junior Member |
|
|
salam !
I think ur question is uncompleted . what is ur problem. the problem you can fix by using a formaula column.
thanks
salam
afroz ahmed
|
|
|
|
| Re: srw.message [message #89554 is a reply to message #89544] |
Wed, 12 May 2004 23:07 |
fatimah
Messages: 9
Registered: February 2004
|
Junior Member |
|
|
Wa'alaikumsalam...
Sorry 4 the incomplete question. Since i've created a monthly report, there might, for example, no records available for last months(April), so my idea is, i want to suppress the system message in the Report 6i.
In after parameter form trigger, i've put 1 validation for no records available. For that i've used the following coding:
if :count_detail=0 then
return (FALSE);
else
return (TRUE);
end if;
end;
In return, i've got the following error message:
REP-0749:After form trigger cannot reference a report column
hope it is clear now...n maybe u can give me the correct coding to suppress the system message in order to display message, 'no records available'.
n one more,
could anybody correct me if i'm wrong, i've tried a method to call report from form, for that i've used below code:
DECLARE
param_id ParamList;
param_name varchar(10):= 'tempdata';
begin
param_id := Get_Parameter_List(param_name);
if not id_null(param_id) then
Destroy_Parameter_List(param_id);
end if;
param_id := create_parameter_list(param_name);
add_parameter(param_id, 'BACKGROUND', text_parameter, 'No');
add_parameter(param_id, 'ORACLE_SHUTDOWN', text_parameter, 'Yes');
add_parameter(param_id, 'MAXIMIZE', text_parameter, 'Yes');
run_product(REPORTS, 'C:NewProjectFormscheckInrep.rep',synchronous,runtime,filesystem,param_id,null);
end;
but after i run the report (thro' form), the report background engine still come out...is there any mistake wit my code? Could anyone, as well, give me the right code to turn the report background engine off?
Please help me to solve my problem, i'm expecting ur reply..
thank you in advance..
|
|
|
|
|
|
| Re: How to display message in Reports 6i in Oralce? [message #90176 is a reply to message #90175] |
Sat, 27 November 2004 21:29 |
Vinod
Messages: 76
Registered: April 1999
|
Member |
|
|
Outputting Messages
-------------------
Warning
--------
WHEN <exception> THEN
SRW.MESSAGE(999,’Warning: report continues’);
WHEN <exception> THEN
SRW.MESSAGE(999,’Warning: report continues’);
Error
-------
WHEN <exception> THEN
SRW.MESSAGE(999,’Error: report terminated’);
WHEN <exception> THEN
SRW.MESSAGE(999,’Error: report terminated’);
RAISE SRW.PROGRAM_ABORT;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
