1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Report Builder - creating mailing lables

Discussion in 'SQL PL/SQL' started by Buckyman, Nov 30, 2011.

  1. Buckyman

    Buckyman Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    I have some SQL that works fine for generating my customer list. The report is displayed in an openoffice writer document. I am trying to print on label stock 2 columns wide. The problem is that the addresses are repeated in adjacent columns. I have attached 2 jpg's to help explain.
    Thanks
     

    Attached Files:

  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    It appears the form you have set up duplicates the addresses -- you need to modify the form to print the addresses once, not twice. This is not a SQL issue, it's an openoffice problem.
    .
     
  3. Buckyman

    Buckyman Active Member

    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    80
    Quite right :)
    Any openoffice experts in here?
    I'll ask over at user.services.openoffice.org