Address block spanning multiple pages

[rbrohman]

Hi,

I've seen forms of this question answered a few times on this forum, but have tried to implement the same methods as suggested in those threads without any success. I'm thinking that my problem may be a combination of issues?

The report I'm trying to draw from looks like this (truncated a bunch):



EMPLADDR
Employee Address Listing
PAY009

(03183)Company Name Here 1/29/08 14:30 Page 2


DEPT EMPL
NO. NO. N A M E / A D D R E S S

19 55 Smith, John
Street 1
City, Province A1B 2C3


21 79 Marks, Adam
Street 1
City, Province A1B 2C3


40 139 Bell, Ryan
Street 1
City, Province A1B 2C3




Employee Address Listing Ver 01.01 Page: 2of23
EMPLADDR
Employee Address Listing
PAY009

(03183) Company name here 1/29/08 14:30 Page 3


DEPT EMPL
NO. NO. N A M E / A D D R E S S PHONE NO

Street 1
City, Province A1B 2C3


61 171 Apple, John
Street 1
City, Province A1B 2C3


61 172 Pear, Matt
Street 1
Street 2
City, Province A1B 2C3


...



Ryan Bell's name is at the end of page 2, while his address details start on page 3. In between are the page footer and header. This page wrapping occurs a number of times throughout the report for different employees.

I have defined the header and footer templates, but am still unable to pickup the address information from page 3. I'm wondering if the issue is something incorrect with the header/footer, or if it's something on the append template I've missed.

Screenshots of my templates:

http://www.screencast.com/t/ZjBhYjdjMTI (detail)

http://www.screencast.com/t/OTk2MjU0Y2Ut (append)

http://www.screencast.com/t/NGVlZDYyZ (append field properties)

http://www.screencast.com/t/ZTNkNDQwMGM (header)

http://www.screencast.com/t/ODFkMGMyZ (footer)

Sorry, I couldn't figure out how to get these embedded in the post...



I'm new to Monarch, using Pro v10.5; any help greatly appreciated.

Thanks,

Ryan

[OllyInMunich]

Hello Ryan,

You should be OK with a multiline detail template (or at least a mutliline address block field using the Advanced Field properties tab to "end on blank lines"), and a Page Header template. You shouldn't need the Append and the Footer templates you've got. But your Page Header template will have to include as many blank lines above it as you need to make it start just below the last line of data you want to capture.

One approach that might help is to Prep the data using Monarch Utility (or a script) to replace 3 consecutive blank lines with just 2 - in case you have a rather irregular page breaking rule in the report.

Best wishes,

Olly

[Data Kruncher]

Hi Ryan, and welcome to the Monarch forum.

You should be able to accomplish this with only detail and page header templates.

Instead of selecting to end your address field on "Blank field values", choose "None of the above".

Now in your page header sample include the 11 rows from Employee Address Listing to the blank row after "N A M E / A D D R E S S".

Then you'll be able to run your "Address" field through Monarch's Address Block (http://excelwithmonarch.com/uncategorized/monarchs-address-block-wizard) feature in the Table window.

HTH,
Kruncher

[Data Kruncher]

Olly beat me to the Submit Reply button. :)

[rbrohman]

Thank you both for the quick replies. I will give that a try.

Is the correct way to setup a "multi-line" template to highlight all the applicable lines before selecting new template? Or do I need to also define multi-line fields to prevent all the header lines from getting picked up by detail template?

To be sure I'm clear - I should remove the footer template, and just have those lines included with the header?

Thanks again,

Ryan

[Data Kruncher]

You can select the sample lines either before creating a new template (actually this is required for new templates), or if you're editing a template, you can mark new lines below in your report, and then click the first icon, "Replace Sample Text".

Yes, you should remove the template you've defined as a footer; you shouldn't need it.

I used the word "employee" to trap the page header template.

[rbrohman]

Following your advice, I've finally had that "eureka!" moment. :)

My model is now working perfectly. Thanks!

Ryan

[Data Kruncher]

Terrific, thanks for the update.

Now if you could do something about my hearing ABBA's "Waterloo" in my head... :rolleyes:

[Chickenman]

Terrific, thanks for the update.

Now if you could do something about my hearing ABBA's "Waterloo" in my head... :rolleyes:

Try replacing it with John Sebastian's "Nashville Cats" :eek:

CM

[Nick Osdale-Popa]

Terrific, thanks for the update.

Now if you could do something about my hearing ABBA's "Waterloo" in my head... :rolleyes:


Try replacing it with John Sebastian's "Nashville Cats" :eek:

CM

Those are called earwigs... songs stuck in your head.
Two ways of curing them, 1) as Chickenman suggested, is to try a different song. "It's A Small World" is a good one. 2) Find the lyrics of the song and SING or listen to the whole thing through. This goes hand in hand with option 1. The trick is to find a song you can sing all the way through. The brain gets stuck in an "endless loop", so to speak, and the only way to fix it is to satisfy the loop.

[Data Kruncher]

I think that I'll go with The Lovin's Spoonful's "Do You Believe In Magic" over Mickey & Co.'s "Small World" this morning (you must've been there again recently :D), but if I had to go with city names, it might be something from Chicago or, being a Monarch forum, Boston. ;)