• Replies 4 replies
  • Subscribers 338 subscribers
  • Views 32 views
  • Users 0 members are here
Related

Custom report problem re: breaking on customer_no

Chris Jensen
$organization

I am writing a custom Infomaker report that prints Volunteer reward coupons, eight to a sheet (two accross by four down).

That would work well in Infomaker as a Label or 2-up report, but I need the report to break to a new page when the customer_no changes, and apparently it is only possible to create row groups (with accompanying breaks) in Tabular Infomaker reports. Am I correct, or is it possible to break on customer_no somehow in a IM label report?

Any suggestions appreciated!

Thank you.

Parents
  • $organization

    Hi Chris,

    Well, I think that the way to do this is to create a group based on the customer_no and then in the General tab for the group, tick the New Page on Group Break check box.  That would force a new page for every customer_no so maybe not that helpful if you're trying to get the report to print 8 customers to a page?  Or were you anticipating exporting the report to Excel and doing a mail merge from there?

    Martin

Reply
  • $organization

    Hi Chris,

    Well, I think that the way to do this is to create a group based on the customer_no and then in the General tab for the group, tick the New Page on Group Break check box.  That would force a new page for every customer_no so maybe not that helpful if you're trying to get the report to print 8 customers to a page?  Or were you anticipating exporting the report to Excel and doing a mail merge from there?

    Martin

Children
  • $organization in reply to Martin Keen (Past Member)

    Thanks for your reply! Yes, grouping by customer_no would be easy to do with a tabular report, but what I'm wondering about is breaking on customer_no in a Label or n-Up report. I fear there's on way, but thought I'd ask, just in case someone had figured it out.

     

    Thanks again.

  • $organization in reply to Chris Jensen

    On an N-Up or Label report, there is no way to add a pagination based on the data.  All of the page and label properties are set up for the entire report/datawindow and can’t be manipulated by an expression dynamically.

     

    You could possibly do this using a regular tabular report, but you’d be on your own to make sure the margins and sizing are appropriate for labels.  You can have multiple data rows in the same detail band row by dragging the column out twice from the Column Specifications pane.  Check out the datawindow d_bio_address_new in the standard reports library as an example.  Doing this, you could create a group level above the detail based on customer_no and have the labels repeat as needed until the change in customer_no occurs in the dataset.  Keep in mind that the grouping is based on the sort of the dataset.

     

    ______________________________________

    Ryan Creps

    Network Developer |Tessitura Network, Inc

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen
    Sent: Wednesday, June 10, 2009 10:37 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] Custom report problem re: breaking on customer_no

     

    Thanks for your reply! Yes, grouping by customer_no would be easy to do with a tabular report, but what I'm wondering about is breaking on customer_no in a Label or n-Up report. I fear there's on way, but thought I'd ask, just in case someone had figured it out.

     

    Thanks again.

    From: Martin Keen <bounce-martinkeen7852@tessituranetwork.com>
    Sent: 6/9/2009 6:35:38 PM

    Hi Chris,

    Well, I think that the way to do this is to create a group based on the customer_no and then in the General tab for the group, tick the New Page on Group Break check box.  That would force a new page for every customer_no so maybe not that helpful if you're trying to get the report to print 8 customers to a page?  Or were you anticipating exporting the report to Excel and doing a mail merge from there?

    Martin




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

    No virus found in this incoming message.
    Checked by AVG - www.avg.com
    Version: 8.5.339 / Virus Database: 270.12.53/2156 - Release Date: 06/10/09 05:52:00

  • $organization in reply to Ryan Creps (Past Staff Member)

    Thanks for your reply.

    Unknown said:
    On an N-Up or Label report, there is no way to add a pagination based on the data. 

    I was afraid of that!

    Your idea re: a sort of 2-up tabular report is interesting. I'm definitely going to try it! Thanks again.