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

Label not printing

edited May 2009 in Subreports
Hello,

I have a problem with printing labels. The structure of the data/report is
as follows:

-Order
-Order detail

What I want is to print out a label with address data for every order
detail. How do I accomplish this?

Kind regards,

jerri

Comments

  • edited May 2009
    Hi Jerri,

    I'm going to need more information about how your report is designed. Is
    your subreport connected to the detail dataset? Where is the label
    information located inside the report? Which components are you using?
    Which dataset is the address data located?

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Hi Nico,

    Sorry for the incomplete description.

    The table structure is as follows:

    Orders, general order data
    Order Detail Base, general data for all articles
    Order Detail Specifics, specific data for that specific article

    The Report structure is as follows:

    -Title band,
    -Detail band,
    -Summary band.

    Title Band:
    In the Title Band the address is shown as follows:

    Company
    Address
    Zipcode City

    These dbdatafields are connected to the Order DlataSet.

    Detail Band:
    In the Detail Band I have placed 12 SubReports, each representing an
    articletype.

    A SubReport has fields that are connected to:
    1-the Order DetailBase Dataset, i.e. fields like quantity, description
    2-but also connected to the Order Detail Specifics table i.e. fields like
    light sensitivity.


    What I am looking for is a way to print a label with address data for each
    available article in this order.

    Hope this clarifies it better.

    Kind regards,

    Jerri


  • edited May 2009
    Hi Jerri,

    The title band will only print once for a report. Try creating a group
    based on the master data and place the address information inside the group
    header. This way each time the address changes, a new group header will be
    printed with the next address info.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Hello Nico,

    I appreciate your help. However, I have the feeling there is a
    misunderstanding:

    Yes, this is correct the title band will only print once but this is exactly
    as it should be.
    I have NO problem with this.

    What I would like to achive is to print an address label for EACH available
    ARTICLE in this order, containing the address as represented on the title
    band, to a Zebra labelprinter. So if I have to install 5 articles at a
    customers site I want 5 labels with the address of the customer.

    Kind Regards,

    Jerri


  • edited May 2009
    Hi Jerri,

    Are your datasets linked? If so, you should simply be able to place the
    address information inside the subreports. Even though the subreport is not
    connected to that datapipeline, it will access the current data. I assume
    when you say "Article" you are referring to each subreport in your detail
    band.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Hi Nico,

    Yes, the DataSets are linked. I cannot place the address information in the
    subreport
    because that subreport is printed to a normal printer. I want the address
    data to be
    printed to a specific Label Printer [Zebra 420].


    Yes this is correct.

    Kind Regards,

    Jerri

  • edited May 2009
    Hi Jerri,

    You might try placing the address info in a section subreport inside each
    existing subreport. By definition, the section subreport will take its own
    page and can be configured to use its own printer settings. Set NewPrintJob
    to True and ParentPrinterSetup to False.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Hi Nico,

    I seem to not be able to find the property to adjust printing to another
    printer. Am I right in thinking this has to be done in RAP code? If so where
    can I find an example how to do this?

    Kind Regards,

    Jerri
  • edited May 2009
    Hi Jerri,

    The properties are TppSubreport.NewPrintJob and
    TppSubreport.ParentPrinterSetup as I mentioned in my previous post.

    There is no need however to use any RAP code as you can adjust these
    properties from the designer by right clicking over the subreport object.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Also, you can access the Report.PrinterSetup property in RAP from the
    subreport's tab to change the printer, or use the Page Setup dialog in the
    designer. (File | Page Setup).

    Note that all of these properties are also available in the built-in
    inspector attached to the Report Tree.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2009
    Thanks Nico, works perfect now.

    Kind regards,

    Jerri

  • edited May 2009
    Hello Nico,

    I do have 2 additional questions:

    1-
    In each subreport I now have included a section subreport. This section
    contains the address data of an order so that for every article needed a
    label is printed with the address. The section subreport has its properties
    set to Visible=true, NewPrintJob=true and ParentPrinterSetup=false.

    I would expect that if the workorder is previewed and the user hits the
    print button that the section report is automatically printed as well. This
    is not the case. Is there perhaps an additional property I have to set?

    2-
    When previewing the workorder I do not need to see the section subreport
    with the address label int he preview. I do however want it to be printed.
    How can one achieve this?

    Kind Regards,

    Jerri


    actually like
  • edited May 2009
    Hi Jerri,

    1. I'm unclear about what is happening here. If the subreport is visible
    and contains data, it will print. If you create an empty report and place a
    subreport inside it with the same properties set and print the report, the
    subreport will print.

    2. This is the same concept as our other discussion in the RAP newsgroup.
    See the email I sent earlier. I highly suggest you upgrade to version 10.09
    before proceeding.

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