Variable Line count - map to main account

[emanc2k]

Hi guys. I have a report that has (multiple, 1-5+) sub accounts which map to one parent account at the bottom of the sub accounts with a blank line between each set of parent/sub accounts. I'm not sure how to go about monarching this to attach the child accounts to the parent accounts. See sample file below:

http://img.photobucket.com/albums/08...plemonarch.png

[Data Kruncher]

Hi emanc2k and welcome to the forum.

It looks like you'll be able to trap the parent data with a footer template.

As part of the footer template trap, use a Numeric trap followed by a blank trap then an Alpha trap , like NBA, in the proper columns of course to isolate the record properly.

Each of the child records will be single line detail records. Once the footer is properly defined, then in the Table window you'll see the parent name on each child record.

HTH,
Kruncher

[emanc2k]

Worked perfectly. Thanks! Is there a good link for common questions like these?

[Data Kruncher]

Glad to hear that you're on you way with your report now.

There are a couple of options for Monarch information:

• On the main forum page you'll find the Monarch KnowledgeBase & Archive, some (most?) of which is relevant, but hasn't been updated in some time.
• I built a custom Google search page for the Monarch forum which works a little better than the built-in vBulletin forum search.
• Finally, there's ExcelWithMonarch.com, which aims to be (one day) the most comprehensive source of Monarch information on the web. Currently a series of posts entitled "30 Days to Become a Better Monarch Modeler" is nearing completion.

HTH,
Kruncher