Home » Developer & Programmer » Reports & Discoverer » Using srw.run_report in Reports 6i
Using srw.run_report in Reports 6i [message #36978] Tue, 08 January 2002 15:00 Go to next message
jks
Messages: 1
Registered: January 2002
Junior Member
Anyone out there know how to use srw.run_report in Reports 6i? I've got a driver report (testdrive.rdf) that calls out another report (testcall.rdf) from the BeforeReport trigger and saves it to file (testnew.rdf).

The testnew.rdf that generates, however, cannot be opened and gives 110 (unable to open...) & 1070 (error upon opening/saving file...) error codes.

Any suggestions are welcomed! Thanx much!

I'm using the following syntax in BeforeReport trigger:

begin
srw.run_report('batch=yes
report=h:trainingtestcall.rdf
destype=file
desformat=dflt
desname=h:trainingtestnew.rdf
background=yes');
return (TRUE);
EXCEPTION
when srw.run_report_failure then
srw.message(30, 'Psyche! Report Failed!');
raise srw.program_abort;
return (TRUE);
end;
Re: Using srw.run_report in Reports 6i [message #36980 is a reply to message #36978] Tue, 08 January 2002 17:33 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
in which format you want to generate output file?

try this..

begin
srw.run_report('batch=yes
report=h:trainingtestcall.rdf
destype=file
desformat=rtf
desname=h:trainingtestnew.rtf
background=yes');
return (TRUE);
EXCEPTION
when srw.run_report_failure then
srw.message(30, 'Psyche! Report Failed!');
raise srw.program_abort;
return (TRUE);
end;
Re: Using srw.run_report in Reports 6i [message #336813 is a reply to message #36980] Tue, 29 July 2008 01:59 Go to previous message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member

Hello All,

I am facing the same prob.

I used the same command as :
try this..

begin
srw.run_report('batch=yes
report=h:trainingtestcall.rdf
destype=file
desformat=rtf
desname=h:trainingtestnew.rtf
background=yes');
return (TRUE);
EXCEPTION
when srw.run_report_failure then
srw.message(30, 'Psyche! Report Failed!');
raise srw.program_abort;
return (TRUE);
end;


Where i put first my report name and later put new file name.
Have I done right? If so,

may I know what exactly will happen?

What I want is:
I have 2 reports, 1 is big & other is small.
I want the Small Report's o/p to be printed at the bottom of the Big Report as it (Big one) get finished..
So I used the same query as written above in my After_Report trigger( where I put Small Report's name first and 2nd as the different name) . But it is not showing the o/p of small report at the bottom.

Thanks and Regards,
Prachi G.
Previous Topic: Not sure if i am using lexical parameter properly
Next Topic: Maximize the report viewer window
Goto Forum:
  


Current Time: Wed May 15 14:24:56 CDT 2024