Today I needed a digression to give my brain a rest.  So I went looking for a decent blog post, and ran across this note, from something I was doing in March 2011.  The question that needs answered is how do I print only files that don't have a specific tracking item.

 

More specifically the report needs to pull all files where the Settlement Status is Pending and it’s a cash sale, where that file doesn’t have a tracking item called “Bank Owned”.

To do this, set the report criteria to grab Status = Pending and Cash Sale is selected.

Setup a Group on FirmFile

Put all the output fields necessary in the Group Footer FirmFile.

Create a formula If {trackitems.what} = "Bank Owned" , return an 1, else 0.

Create a running total of that, which gets reset on group FirmFile that sums.

Finally put a suppress formula on the footer If runningTotal > 0 Then True, Else False.

That will prevent the line from printing if a match is found for the track item formula. So only if no tracking exists, the detail line prints. (the detail that's in the Group Footer FirmFile)

The result is the output fields in the Group footer will only print if the track items is not found in the list of track items for the file.