I have a problem in running a oracle report created with Report Builder 6.0.8.13.1.

I have created two reports, a "master-report"
and a "slave-report"

The master-report selects some values from a table
and invokes the slave-report via the SRW.RUN_REPORT for each selected value, and
passes the selected values to the slave-report.

The master-report starts running just fine and starts the slave-report succesfully.

After the slave-report has been invoked succesfully approx. 1000 times, the execution halts with the error message:
REP-1428: Error while running SRW.RUN_REPORT

That what I found on metalink about ur problem
Subject: REP-1428 - USING SRW.RUN_REPORT
Doc ID: 1060595.6 Type: PROBLEM
Modified Date: 18-APR-2007 Status: PUBLISHED


"Checked for relevance on 18-Apr-2007"


PROBLEM DESCRIPTION:
====================

You are attemtpting to run an Oracle Report from another Report using the
built-in funtion SRW.RUN_REPORT, and receive the following error:

REP-1428 - <Program unit name>: Error while running <procedure name>.



SOLUTION DESCRIPTION:
====================

1. Hardcode the string value as '||string||'.

2. Pass the parameter from the master as a concatination of '||string||

/********************************************************************************
********************/

Subject: REP-1428 WHEN RUNNING A REPORT FROM A REPORT USING SRW.RUN_REPORT
Doc ID: 1060520.6 Type: PROBLEM
Modified Date: 04-FEB-2008 Status: ARCHIVED


PROBLEM DESCRIPTION:
====================

You are using srw.run_report in an 'after report trigger,' and you are
receiving the following error message:

REP-01428 "<Program unit name>: Error while running <procedure name>".

For example:

srw.run_report('report=c:\xxx\xxx\test.rdf destype=printer batch=yes');


Search Words: REP-1428

SOLUTION STATEMENT:
===================

Try the following:

srw.run_report('report=c:\xxx\xxx\test.rdf destype=printer background=yes');

You can modify the statement by deleting the batch reference and adding the
background parameter. This resolves the REP-1428 error and allows the report
to run.

/********************************************************************************
***************/

Subject: GETTING A REP-01428 WHEN RUNNING REPORT FROM BUTTON USING SRW.RUN_REPORT
Doc ID: 1029218.6 Type: PROBLEM
Modified Date: 26-FEB-2007 Status: ARCHIVED


Checked for relevance on 26-Feb-2007

PROBLEM DESCRIPTION:
====================

A REP-01428 occurs when trying to run a report from a report using a button
on the screen/previewer and specifying paramform = yes.

REP-01428: '<Program unit name>':Error while running <procedure name>.

Search Words: REP-1428

SOLUTION DESCRIPTION:
=====================

Remove the spaces between the report and any other parameters.

For example: report=reportnm paramform=yes instead of
report = reportnm paramform = yes

./********************************************************************************
**********************************************/

Subject: Examples of Passing Parameters via SRW.RUN_REPORT
Doc ID: 1018129.102 Type: PROBLEM
Modified Date: 07-JUN-2007 Status: PUBLISHED


"Checked for relevance on 07-Jun-2007"


PROBLEM DESCRIPTION:
====================

You are doing one of the following using SRW.RUN_REPORT.

1. Running drill-down reports (i.e., calling a report from a button's
Action Trigger).

2. Running multiple reports from a single "driver" report.

You are passing a few parameters from the driver report to other reports.

The second Report output is empty, since parameters are not correctly being
passed to the second report.



SOLUTION DESCRIPTION:
=====================

Assumptions
-----------
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(_1));

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='||''''||_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(_1)||'''');


NOTE: To_char is required in reports V2.5 when data type is either number
or date.

يسلمو كتير
بس بدي اجربهم واخبرك