Home » Developer & Programmer » Reports & Discoverer » Multiple reports in single report (was Migrated forms property)
Multiple reports in single report (was Migrated forms property) [message #208755] |
Tue, 12 December 2006 02:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
scj2992
Messages: 3 Registered: December 2006
|
Junior Member |
|
|
Hi,
We had migrated a legacy application from Forms 4.5, Reports 2.5 to Forms and reports 6i. One major problem that we face is, when the reports are sent for printing in the new version, it prints out in random order. The reason for this is, because in 6i, there are multiple reports servers that are created for each report that is fired, making it a parallel process. So which ever report gets generated, irrespective of the order in which it was sent, gets fired to the printer. In 4.5 version there was a single reports server which used to process reports in the order in which they were sent. I think it is a property of the Oracle runtime and cannot be changed.
We want to have it printed in the order it is sent for printing just as it was in 4.5.
Appreciate any help.
Thanks
Jose
Upd-Mod: Change title.
[Updated on: Wed, 13 December 2006 17:18] by Moderator Report message to a moderator
|
|
|
|
Re: Migrated forms property [message #209044 is a reply to message #208987] |
Wed, 13 December 2006 01:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
scj2992
Messages: 3 Registered: December 2006
|
Junior Member |
|
|
Hi David,
Thanks for the reply.
The Reports are called from forms using the run_product built-in. There are four reports that will be sent at a time using the same in ASYNCHRONOUS mode.
Example:
RUN_PRODUCT ( REPORTS, 'rep1', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
RUN_PRODUCT ( REPORTS, 'rep2', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
RUN_PRODUCT ( REPORTS, 'rep3', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
RUN_PRODUCT ( REPORTS, 'rep4', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
The problem is that they are processed in parallel and is sent to the printer in any order they are finished- say rep1, rep3, rep4, rep2, while we want it to come out as rep1, rep2, rep3 and rep4.
There is no explicit call to the Reports Server as such since we use the run_product built in. Is there a way to limit the reports to run on a single reports server?
Appreciate your response.
Regards.
Jose.
|
|
|
|
Re: Migrated forms property [message #209502 is a reply to message #209212] |
Fri, 15 December 2006 04:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
scj2992
Messages: 3 Registered: December 2006
|
Junior Member |
|
|
Hi,
It will not be possible to place them into a single report. The Code I had pasted below was just a sample. There are nine such reports which can be called in any order.
Thanks.
Jose
|
|
|
Re: Migrated forms property [message #209654 is a reply to message #209502] |
Sat, 16 December 2006 07:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
ab_trivedi
Messages: 460 Registered: August 2006 Location: Pune, India
|
Senior Member |
|
|
Hi Jose,
what i can take out from you question is that you are using
Quote: | RUN_PRODUCT ( REPORTS, 'rep1', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
RUN_PRODUCT ( REPORTS, 'rep2', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
RUN_PRODUCT ( REPORTS, 'rep3', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
RUN_PRODUCT ( REPORTS, 'rep4', ASYNCHRONOUS, BATCH, FILESYSTEM, 'REP_PARAM', NULL );
|
But when it start printing it is not sequential is this the problem?
Bye
|
|
|
Goto Forum:
Current Time: Fri Sep 06 21:26:34 CDT 2024
|