Home on the web ~ Dan Van Fleet

Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Home on the web ~ Dan Van Fleet - Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

ProForm Crystal Report, Print if No Tracking item

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.

Help support the site when shopping on Amazon, click through any ad to get to Amazon, ignore that product, then buy whatever you're there for. Thanks for helping out.

Your email address will not be published. Required fields are marked *

*

css.php