Printing labels AND individual sheets for each label

Posted by: infochuck on 4 August 2017, 2:54 pm EST

  • Posted 4 August 2017, 2:54 pm EST

    I have a label report (actually postcards, 2x2 on a landscape page)
    that works great using 2 columns and the directions in help.  Now
    I need to be able to print (and/or save) a single-page for each
    individual square (ie, each postcard) on the page - ie, a 'file
    copy'.  I can't simply print/save a second copy of each page,
    because I only want one quadrant. and not all four detail sections on
    the page.

    Here's the further kicker:  I need this all to be done via RPX
    files, so that it's user-creatabable with no code-slinging by the users
    (although injecting/inserting generic/template code at runtime is
    fine).  I've done all this via designers in a VB project, but even
    that required the datasource for the single-page report I kicked out to
    be set independently, which is not ideal.

    Now, I think I can also do this by NOT using AR's columns/label
    capabilities and just printing each record to a single report (or
    single page) that is postcard-sized, exporting to a JPG, keeping the
    individuals as file copies and merging four JPGs into one larger 8.5x11
    printable sheet for mailing.  But that sounds like a lot of work
    I'd rather not do ;)

    So, is there another way to take any user-designed RPX that consists of
    two columns and two rows and has only a detail section and print the
    individual section?  I see there's a .Detail.Print method (or
    something like that) but no docs for it, and it doesn't appear to do

    I'm open to strange solutions, like shifting around the printable area
    four times for each page and printing that small area in addition to
    the entire page, or just about anything at this point.  Thanks for
    any pointers!

  • Replied 4 August 2017, 2:54 pm EST

    Why not use a subreports approach? Use a main report with 2 columns. In the detail section of the main report you would load the correct 2x2 report into a subreport control. Then, using the FetchData event, the main report would move to the next row or column and you would populate the subreport control with the next 2x2 label report. Your users would only design the subreports and would never see the main report.
  • Replied 4 August 2017, 2:54 pm EST

    Wow!  Thanks for the quick reply.  Unfortunately, I'm afraid
    I don't really understand the proposed solution.  You say to
    "populate the subreport control with the next 2x2 label report", but I
    don't have a series of reports - just one SQL statement that generates
    a single dataset that needs printed one record per postcard, 4 cards
    per page: ie, "SELECT * FROM tblCustomers Where CustNum < 10"; there
    would be four detail records per page.

    You say I'd have a main report with two columns, and a subreport
    control in the detail section (the only section I need); I assume then
    that the subreport that gets laoded into the sub control only has one
    column?  Would both the sub and main reports have a datacontrol,
    with the same source (SQL above), or would just one have the DC? 
    Also, I fail to see how this would get me a single-record page or
    report for each detail record printed in the subreport; would the main
    report need a Page/Group/Report header of some sort to do that? 

    I'm sorry I'm so confused, but I'll keep hitting keys at random.
  • Replied 4 August 2017, 2:54 pm EST

    If I may say so, in this case it may be easier to just adjust the ColumnCount and NewPage properties for your Detail section. Something along the lines of the following in your ReportStart would do the trick. (don't forget to swap the keyword 'rpt' for 'Me' if you use script)

    <FONT face="Courier New">If StandardQuad Then
       Me.Detail.ColumnCount = 2
       Me.Detail.NewPage = ddNPNone
    Else '=FileCopy Then
       Me.Detail.ColumnCount = 1
       Me.Detail.NewPage = ddNPAfter
    End If</FONT>

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels