Multiple impression problem

[degraxa]

Hello,

I have a report with a field which is filled by sending parameter (Add_parameter) when I want to print my report from a oracle form.

RUN_PRODUCT(REPORTS, 'myreport', SYNCHRONOUS, RUNTIME, FILESYSTEM, list_param_1);

In a loop:

I send the parameter "111" and I print the report.
I send the parameter "112" and I print the report.
I send the parameter "113" and I print the report.
I send the parameter "114" and I print the report.
... and so on.

It works fine until I have a large number of report to print. By instance, If i want to print 100 reports, It seem's I have some memory problem on my printer.

What I would like to do is to send as parameter "111" (first step) and "212" (last step) and only one "RUN_PRODUCT" call. But i don't know how to do it...

 

[nagornyi]

Place your entire report into repeating frame fed by the following new query, that you create in the data model

SELECT ROWNUM +:p_from-1 parameter 
FROM all_objects
WHERE ROWNUM <= :p_to - :p_from + 1

Then make a link of the "query to query" type between this query and the report's query, so that parameter be seen in the report's query and could be used as parameter. Refer to it as arameter in the report's query.
Now you just need to supply _from and _to parameters for your new report, and it will internally generate reports for all the values in between.