Home » Developer & Programmer » Reports & Discoverer » Report Printing Sequence Change? (Oracle 10g Reports, Win XP)
Report Printing Sequence Change? [message #605103] |
Tue, 07 January 2014 06:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/152402.jpg) |
stalin4d
Messages: 226 Registered: May 2010 Location: Chennai, Tamil Nadu, Indi...
|
Senior Member |
|
|
I have created 2 reports, 1st report in the main section, second report in the trailer section,
both the report have 3 pages, so total six pages,
for example: main section pages 1,2,3
trailer section pages 4,5,6
well when i run the report its currently printing like 1,2,3,4,5,6
but i need to print like 1,4,2,5,3,6 vice versa!
how to achieve this ?
|
|
|
|
Re: Report Printing Sequence Change? [message #605134 is a reply to message #605123] |
Tue, 07 January 2014 09:10 ![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) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
As far as I can tell, Reports can't do that. If you want to print data in a specific order, you have to develop a report so that it reflects your needs.
The way it is now, you can only specify those pages in "Print" dialog, within its "Print range", you'd switch from "All" to "Pages" and put 1,4,2,5,3,6 in there. Then, hope that print driver is stupid enough so that it doesn't "understand" that it is, actually, 1,2,3,4,5,6 and spoils print order.
|
|
|
Re: Report Printing Sequence Change? [message #605184 is a reply to message #605134] |
Tue, 07 January 2014 14:52 ![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) |
![](/forum/images/custom_avatars/152402.jpg) |
stalin4d
Messages: 226 Registered: May 2010 Location: Chennai, Tamil Nadu, Indi...
|
Senior Member |
|
|
Littlefoot wrote on Tue, 07 January 2014 20:40As far as I can tell, Reports can't do that. If you want to print data in a specific order, you have to develop a report so that it reflects your needs.
The way it is now, you can only specify those pages in "Print" dialog, within its "Print range", you'd switch from "All" to "Pages" and put 1,4,2,5,3,6 in there. Then, hope that print driver is stupid enough so that it doesn't "understand" that it is, actually, 1,2,3,4,5,6 and spoils print order.
I have attached the pdf which is generated for an example,
well it has 32 pages (16 * 2 ).
16 for the letter and 16 for the data,
here 17th page should be displayed in 2nd page!
like 1,17, 2,18 and so on..........
because the continuity is like that only, not 1,2,3,.....32
-
Attachment: Letter1.pdf
(Size: 106.44KB, Downloaded 2658 times)
|
|
|
Re: Report Printing Sequence Change? [message #605186 is a reply to message #605184] |
Tue, 07 January 2014 15:03 ![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) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Aha, OK then. Here's how I'd do that (in a brand new report): - I'd put both "letter" and "data" into the Main section
- In Data Model, create 2 queries: one for "letter", one for "data"
- Let Wizard create layout. It will be ugly, but will put "letter" first and "data" next
- Run the report and verify whether layout looks OK. If so, fine - all you have to do is to make it pretty (because it already works). If not, then
- stretch "letter" repeating frame so that it contains both "letter" and "data" objects. In order to do that easily, group "data" objects first because you might have to adjust what's in the background for ages and experience numerous runtime errors.
- That, I believe, should do the job
|
|
|
|
|
Re: Report Printing Sequence Change? [message #605277 is a reply to message #605238] |
Wed, 08 January 2014 06:46 ![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) |
![](/forum/images/custom_avatars/152402.jpg) |
stalin4d
Messages: 226 Registered: May 2010 Location: Chennai, Tamil Nadu, Indi...
|
Senior Member |
|
|
Yes, like that only i have put as you mentioned,
single query and 2 repeating frames in main-section.
Properties for the Repeating frame 1:
Print object on : first page
Properties for the Repeating frame 2:
Print object on : first page
but its not working! again the same thing continues...
[Updated on: Wed, 08 January 2014 06:59] Report message to a moderator
|
|
|
|
|
Goto Forum:
Current Time: Tue Feb 11 17:24:15 CST 2025
|