I am trying to be able to run a couple different files from one database and having a little trouble working it out without doing silly workarounds. Basically what I have is a loan coupon book, printing say 10-15 records of the same name, then switching to a new name, printing 10-15 more, and so on and so forth. I then have a second layout to print envelopes for these sets, so I need one envelope for book 1, one for book 2, etc. I have tried the "CHANGED" expression, but it expressly states that it treats as false the first record, so while I can print the rest of the envelopes ok, I couldn't do the first one.

I have tried this as a layout expression, but with no luck:
IF(RECORD_NR()=1,Print,(IF(CHANGED([Account Number]),Print,Skip)))

Basically I want to say:
If record number is 1, print
else if account number changed, print
else skip

Any thoughts or help? Thanks!


--edit--
As a side note, yes I know I could add an extra record at the beginning, but that's not the proper way to work it out, imho

--edit--

Your expression looks fine to me, but I tried it and it seems PSM behaves a bit odd when you use CHANGED in the "if true" or "if false" branch of an IF. I have no idea why..

Try creating two separate expressions instead. First define the following layout condition:


PSM should automatically create a new variable called "Changed". For this variable, use the following expression:

I actually fiddled some more and turned things around and got this to work:


Doesn't make sense to me why this works and my original doesn't, but it is simple and doesn't require any additional variables to be introduced. Hopefully someone else might find it useful as well.