SRW Package Usage

procedure U_1ButtonAction is
p number ;

begin
  select sum(payments) into p  from a;
SRW.MESSAGE(100, 'The Total Payments are='||p);
  srw.run_report('report=D:\ReportPractice\FinalTest.rdf');

end;

We can use SRW.RUN_REPORT in AFTER REPORT TRIGGER AS FOLLOWS
srw.run_report('module=modulename.rdf destype=screen paramform=yes maximize=yes');

u can use srw.run_report as followssrw.run_report('module=modulename.rdf destype=screen paramform=yes');

We can use SRW.RUN_REPORT in AFTER REPORT TRIGGER AS FOLLOWS
srw.run_report('module=modulename.rdf destype=screen paramform=yes maximize=yes');


you can use SRW.RUN_REPORT AS FOLLOWS
SRW.RUN_REPORT('MODULE = MODULE NAME.RDF DESTYPE=SCREEN,PARAMFORM=YES,MAXIMIZE=YES');

procedure U_1ButtonAction is
begin
srw.run_report('saledone.rdf paramform=yes
P_custname="'||:custname||'" P_salesrep="'||:salesrep||'"');
end;

Driver report : dept.rdf
Dept.rdf is running a second report called emp.rdf.

dept.rdf has an user parameter called p_1.
emp.rdf has an user parameter called p_2.

Depending upon the data types of the above user parameters, use the following
syntax.

Examples:
==========

a) p_1 and p_2 are number parameters:
srw.run_report('report=c:\orant\bin\emp.rdf batch=yes destype=file
desname=c:\temp\emp.html desformat=html p_2='||to_char(:p_1));

b) p_1 and p_2 are character parameters:

srw.run_report('report=c:\orant\bin\emp.rdf batch=yes destype=file
desname=c:\temp\emp.html desformat=html p_2='||''''||:p_1||'''');

c) p_1 and p_2 are date parameters:
srw.run_report('report=c:\orant\bin\emp.rdf batch=yes destype=file
desname=c:\temp\emp.html desformat=html p_2='||''''||to_char(:p_1)||'''');

-------------------------------------------------------------------------

srw.run_report('report=d:\ReportPractice\FinalTest.rdf batch=yes destype=file desname=d:\ReportPractice\FinalTestOutput.html desformat=html p_2='||''''||:p_1||'''');
srw.run_report('report=d:\ReportPractice\FinalTest.rdf batch=yes destype=file desname=d:\ReportPractice\FinalTestOutput.html desformat=html p_2='||''''||:ENAME||'''');
_____________________________________________________________________



srw.run_report('report=d:\ReportPractice\FinalTest.rdf batch=yes destype=file desname=d:\ReportPractice\'||:ename ||'.html desformat=html p_2='||''''||:ENAME||'''');
--p_2 is user parameter in FinalTest.rdf report and link with its as where Ename=:P_2
--:EName is regular Column passed to FinalTest.rdf report from the report who is calling srw.run_report function
--:Ename is also sent as parameter to set system paramter i.e; desname to become the name of the file having the query report in html format
-- note p_2 is of type character and Ename is also Character type.

--------------------------------------------------------------------------------------------------
srw.run_report('report=d:\ReportPractice\FinalTest.rdf  destype=screen  p_2='||''''||:ENAME||'''');