Thread: [Solved] Page Break on Key Change
View Single Post
 
Old 05-11-2014, 05:53 PM
bufferemail bufferemail is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: May 2014
Posts: 4
bufferemail is on a distinguished road
Default Page Break on Key Change

I can't make sense of the syntax for IF fields and I've gotten to the point where the bulk of my output is correct but nothing happens when a key value changes between lines.

{QUOTE{IF{MERGESEQ}=1 "{SET Key1 ""}{SET Key2 ""}"}"IF{IF{={IF{MERGEFIELD ED}= {REF Key2} 1 0}*{IF{MERGEDFILED NUM}={REF Key1} 1 0}}=0"{IF{MERGESEQ}>1 ""}{MERGEDFIELD NUM}{SET Key1 {MERGEFIELD NUM}}"}{IF{MERGEFILED ED}<>{REF Key2} "{SET Key2 {MERGEFIELD ED}}"}{MERGEFIELD LAST}, {MERGEFIELD FIRST}"}


The data source is sorted first by ED, then by NUM.

I'd like the output to be like this so that when the entries with like EDs end and a new ED starts it would insert a page break, then the new ED value, then another page break.

--page break--
ED1
--page break--
NUM1
Last, First
Last, First

NUM2
Last, First

--pagebreak--
ED2
--pagebreak--
NUM3
Last, First
Last, First


Is my structure correct and if so where would I place the page break so that it appears when the ED changes?

Thank you in advance!
Reply With Quote