Search code examples
oracle-databaseoraclereports

Is there a possibility to add OMR codes to Oracle Reports


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


Solution

  • 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