Home » Developer & Programmer » Reports & Discoverer » srw.message
srw.message [message #89540] Mon, 10 May 2004 23:04 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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..
How to display message in Reports 6i in Oralce? [message #90175 is a reply to message #89544] Fri, 26 November 2004 23:52 Go to previous messageGo to next message
Narsi
Messages: 5
Registered: July 2002
Junior Member
Hi

How to display messsages in Reports at runtime. Plz Help thr my mail id..

Are using the coomit in Triggers???

Plz Help me....

With regards
Narsi
Re: How to display message in Reports 6i in Oralce? [message #90176 is a reply to message #90175] Sat, 27 November 2004 21:29 Go to previous message
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;
Previous Topic: Setting Constants in Discoverer Admin
Next Topic: Feeding parameter to another parameter select
Goto Forum:
  


Current Time: Wed Feb 21 18:29:25 CST 2024