Home > Software engineering >  Is there a possibility to add OMR codes to Oracle Reports
Is there a possibility to add OMR codes to Oracle Reports

Time:02-15

Is there any way to add OMR codes for letter inserters onto an Oracle Report?

Dirty tricks or not, any ideas are welcome. So far I was thinking of either drawing the lines and hiding/showing them depending on the page. Either that or creating 16 different images (8 combinations for start and end) -> Explanation: The top 2 represent start and stop, the bottom represents a binary sequence going from bottom to top.

Here is the desired result:

Image showing OMR codes on paper

CodePudding user response:

When I was developing such a report (boy, it was ... 15 years ago, I don't remember details any more), I created separate lines. Each of them had its own Format trigger which returned TRUE (if that line had to be displayed) or FALSE (if not), based on a function result.

If I remember well,

  • the 1st line was always displayed

  • the 2nd line represented beginning of "data set" (e.g. 3 papers had to be put into the same envelope, so the 1st of these 3 pages had that line displayed)

  • the 3rd line represented end of "data set" (as above; that line was displayed on the 3rd page of that set, which means that these 3 papers were put into the same envelope)

  • the next 3 lines were "counters" (binary, of course):

    • no lines = 0
    • only the 1st line = 1
    • only the 2nd line = 2
    • the 1st and the 2nd line = 3 etc.

    You're having more "counter" lines than I did, but it doesn't matter, the principle is the same.

It worked on both Neopost and Pitney-Bowes machines.


P.S. Did you hug your backup today? I just did - found the report that dates back in August 2007. Here's a screenshot which illustrates what I was trying to describe:

enter image description here

  • Related