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

how to print mail labels from a database (each label should be a new record)

edited September 2014 in General
Hello

Reportbuilder v15.04


I just cant figure out how to print mail labels from a database so that each
label contains a different data record but formatted as labels.

I have it working to print 65 labels for one record but need it to print 65
different records per A4 page

eg. 65 records on an a4 sheet ( but with 65 different customer record
ata )


thanks

Kamran

Comments

  • edited September 2014
    Hi Kamran,

    Is your report connected to your dataset (via the Report.DataPipeline
    property or by selecting Report | Data... from the main menu)?

    Though the pipeline and fields are visible and accessible from the
    report in the designer, the pipeline that is to be traversed needs to be
    connected to the report to view all data.

    If you are connected to the pipeline and still get this behavior, it is
    likely a dataset issue. Check your query and possibly connect a DBGrid
    to your dataset to see if you get the same behavior.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2014
    Hello

    Yes its connected to the pipeline but it prints 1 page of the same data per
    page.
    it does traverse to the second page and prints the second customer data on
    the second page.
    My problem is that it prints:
    65 labels of smith - page 1
    65 labels of mr jones - page 2
    65 labels of mr anderson - page 3

    I need to print 65 different customer records on the same page.
    e.g on the same page i need mr smith in col1, row 1, mr jones in col2 row 1,
    mr anderson in col1, row1 etc.

    Hope that clarifies what I am trying to do.

    Kind regards

    Kam

  • edited September 2014
    Hi Kam,

    Perhaps more information about how your report is designed will help me
    understand what is happening.

    Do you have any groups or subreports in your report?

    If you are getting 65 identical iterations of the same label, it is
    likely that your DetailBand.PrintCount property is set to 65.

    Best Regards,

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