Home » Developer & Programmer » Reports & Discoverer » Between Pages Trigger (Oracle Reports 6i)
Between Pages Trigger [message #486600] Fri, 17 December 2010 04:36 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
I have idea about Between Pages trigger.
But i don't know any practical example to do it.

please post the working example.
Re: Between Pages Trigger [message #486608 is a reply to message #486600] Fri, 17 December 2010 04:56 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Open Reports Builder's Online Help system, search for "Which report trigger to use" and read it.
Re: Between Pages Trigger [message #486710 is a reply to message #486600] Sun, 19 December 2010 06:16 Go to previous messageGo to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
I had already mentioned that, i know about between pages trigger.
But i don't have any practical scenario to work on it.

please post any working example.
Re: Between Pages Trigger [message #486733 is a reply to message #486710] Sun, 19 December 2010 13:16 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is a folder / inserter machine. It is used to fold papers and insert them into an envelope. In order to distinguish sets of papers that are to be put into the same envelope, it uses the OMR code (Optical Mark Recognition). It, for example, shows beginning of a set, end of a set, and counts papers (regardless of a set). Counter is binary and uses three lines:
||| = 7
 || = 6
| | = 5
etc. Folder machine has an optical sensor that reads OMR code. Machine stops if counter sequence fails (for example, reads papers 1, 2, 4 (3 is missing)).

In order to create the OMR code counter, create a report package that contains a variable - a counter. Set it (counter = counter + 1) and reset it (if counter > 7 then counter = 0) in BETWEEN PAGES trigger.
Re: Between Pages Trigger [message #490671 is a reply to message #486733] Wed, 26 January 2011 10:03 Go to previous messageGo to next message
banksilp
Messages: 6
Registered: January 2011
Location: 66
Junior Member
got it ..
thank you.
banksilp
Re: Between Pages Trigger [message #491049 is a reply to message #486600] Fri, 28 January 2011 12:02 Go to previous message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Hi Banksilp,

Could you please tell me how you did it.

Thanks,
Siva
Previous Topic: New Learner for Discoverer
Next Topic: Blank space between name and address
Goto Forum:
  


Current Time: Fri Apr 19 22:58:21 CDT 2024