Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

multiple permits

edited October 2007 in General
I have records stored in mysql tables. I need to print permits 6 per page.
How do I step through so I get top left permit1 top right permit2 etc

Cheers

stevew

Comments

  • edited October 2007
    Hi Steve,

    For future reference, please use your real name in the "from" field when
    posting to these newsgroups.

    If you would like to print your records horizontally, you can set your
    report to contain two columns and then set the DetailBand.ColumnTraversal to
    ctLeftToRight. This will give you a report that looks like the following...

    Record 1 Record 2
    Record3 Record 4... etc.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2007
    Got that working thanks.

    The material is A4 I am printing landscape. 3 permits across & 2 down. I
    also print within the 'kiss cut' strips.

    The material has 'kiss cut' strips across the page as follows:


    ______________________________________________
    ______________________________________________7mm



    85mm

    ______________________________________________

    12mm
    ______________________________________________

    12mm
    ______________________________________________



    85mm


    ______________________________________________
    ______________________________________________7mm

    The problem I have is the second row layout borders are reversed ie the top
    band is 12 mm where as the top band on the first row is 7mm. Is there a way
    to move the objects on the second row or have the second row flip the data
    180 deg so the permits will all line up?

    Cheers

    SteveW

  • edited October 2007
    Hi Steve,

    Please forgive me, I'm a bit unclear about what you are trying to
    accomplish. It may be that I am missunderstanding your definition of bands,
    rows, and permits.

    I assume permits are record values retrieved from your database table and
    you have a three column report with a single DBText component inside the
    detail band set to traverse LeftToRight.

    Are the first three records (1st row) printing in the 7mm section of paper
    and the second three records printing in the 85mm section? Where exactly
    would you like the record values to print? It is possible to resize the
    detail band at runtime to accomidate different printing positions or simply
    move the drawcommands manually in the OnDrawCommandCreate event to a
    specific place on a page.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2007
    I have a report that has various fields.
    I print as follows:

    Please peel off:

    PERMIT NO 123
    REG XYX
    COLOUR


    Please peel off. Owner MR Digital


    The top and bottom strips peel off to expose an adhesive so the permit can
    afix to the widscreen.

    I have set 3 columns
    I have set transverse left to right.

    When I run the report I get 6 permits. 2 down with 3 across

    The second row is the problem because the first band on the material is 12mm
    then 85mm then 7mm (ie the reverse of the top half).

    To correct this manually I would set the paper height in half print the job.
    ie 3 permits. Turn the paper around 180 deg then print again.

    In software print the first row then flip the fields 180 and start bottom
    righ to left

    I hope this makes sense. If not I could scan a finished sheet and email.

    Cheers

    SteveW

  • edited October 2007
    Hi Steve,

    If you are using static height detail bands, you can simply resize the
    detail band so enough space will be added to position the next row of
    records in the correct spot. If you are using dynamic height, you can try
    placing a region or shape to take up this space. If you need to print the
    second row upside down, you can try using counting the records generated and
    simply change the angle property of each text component in the detail band
    to 180 before printing the second row of data.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.