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
stalin4d
Messages: 215
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 #605123 is a reply to message #605103] Tue, 07 January 2014 08:43 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 347
Registered: August 2002
Senior Member
send me the print screen of the report which you want to print.
Re: Report Printing Sequence Change? [message #605134 is a reply to message #605123] Tue, 07 January 2014 09:10 Go to previous messageGo to next message
Littlefoot
Messages: 19770
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 messageGo to next message
stalin4d
Messages: 215
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Littlefoot wrote on Tue, 07 January 2014 20:40
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.


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 37 times)
Re: Report Printing Sequence Change? [message #605186 is a reply to message #605184] Tue, 07 January 2014 15:03 Go to previous messageGo to next message
Littlefoot
Messages: 19770
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 #605188 is a reply to message #605186] Tue, 07 January 2014 15:24 Go to previous messageGo to next message
stalin4d
Messages: 215
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
I have already built the report! do i need to put both the reports in the main section and
put 2 queryies in the data model?

[Updated on: Wed, 08 January 2014 04:29]

Report message to a moderator

Re: Report Printing Sequence Change? [message #605238 is a reply to message #605188] Wed, 08 January 2014 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think that you don't need two queries (in Data Model); one is enough. However, you'll need two repeating frames, and both of them will have the same source group (i.e. the one that belongs to that, single, query).
Re: Report Printing Sequence Change? [message #605277 is a reply to message #605238] Wed, 08 January 2014 06:46 Go to previous messageGo to next message
stalin4d
Messages: 215
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

Re: Report Printing Sequence Change? [message #605332 is a reply to message #605277] Wed, 08 January 2014 14:00 Go to previous messageGo to next message
Littlefoot
Messages: 19770
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That would mean that you need to do the "if not ..." part of my previous message. The way it is now, Reports first displays all data that belongs to the first repeating frame, and then all data that belongs to the second repeating frame.

You want to display one record from the first repeating frame and corresponding data from the second repeating frame.

Therefore, let the first repeating frame enclose all objects that belong to the second repeating frame (I mean everything that belongs to the second data set, everything!, including all frames, all fields, text ... everything.
Re: Report Printing Sequence Change? [message #605446 is a reply to message #605332] Thu, 09 January 2014 07:48 Go to previous message
stalin4d
Messages: 215
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Yes im trying this method, i saw a sample its working. thanks a lot.
Previous Topic: barcode print in oracle report 6i
Next Topic: Problem while generating the report
Goto Forum:
  


Current Time: Sun Nov 23 21:18:01 CST 2014

Total time taken to generate the page: 0.13196 seconds