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

How to achieve the following?

edited March 2005 in General
We need to print out permits 6 / a4 page. 2 across and 3 down.

Each permit will have standard text. eg date of issue, expiry date.
Each permit will have an individual registration number printed on it.
Each permit will have a image(logo) printed on it.
The data for the registrations will be supplied as a text file in the format

HJ67YH
UI88UY
VH77RT
WE567Y etc

How do I read each registration number from the text file and insert into
each permit.

eg

Issue date 14/thJAN (LOGO)
Issue date 14thJAN (LOGO)
Expiry date 30thFEB
Expiry date 30th FEB
Reg HJ67YH
REG UI88UY



Issue date 14/thJAN (LOGO)
Issue date 14thJAN (LOGO)
Expiry date 30thFEB
Expiry date 30th FEB
Reg VH77RT
REG WE567Y



Also I want to stop printing at the last Reg number. IE if the last page has
only 1 registration only print 1 permit and leave the rest blank.


Cheers

SteveW

Comments

  • edited March 2005
    Hi Steve,

    Take a look at the TextPipeline. This pipeline allows you to traverse the
    data located in a text file as if it were a table and output it to your
    report. See the TppTextPipeline topic in the ReportBuilder help file for
    more information as well as take a look at the No DataBase Report demos
    located in the \RBuilder\Demos\1. Reports\... directory (dm0131 - dm0140).

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2005
    Thanks again for the help.


  • edited March 2005
    I have used avery labels L7166 which gives me 2 rows and 3 columns.

    When printing at the default settings the bottom 2 rows creep up the page.
    What are the settings to cure this please.

    Cheers

    SteveW
  • edited March 2005
    Hi Steve,

    What do you have inside your labels?

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2005
    The main form contains 8 edit boxes.
    The report assigns the text in these edit boxes to variables on the before
    print.

    ppvariable1.Text := edit1.Text;
    ppvariable2.Text := edit2.Text;
    ppvariable3.Text := edit3.Text;
    ppvariable4.Text := edit4.Text;
    ppvariable5.Text := edit5.Text;
    ppvariable8.Text := edit8.Text;
    ppvariable9.Text := edit9.Text;
    ppvariable10.Text := edit10.Text;

    There is an image on the report pointing to a jpg file.
    There is a pptextpipeline which points to a txt file as follows

    lgh765
    KLTT%R
    WENJKK
    JIHT77

    I have remove headers and footers.
    I have set autostop to false.




  • edited March 2005
    Hi Steve,

    This is not a known issue. Please send a small example of this shifting
    issue in .zip format to support@digital-metaphors.com and I'll take a look
    at it for you.

    --
    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.