{"id":540,"date":"2013-04-08T14:32:04","date_gmt":"2013-04-08T19:32:04","guid":{"rendered":"https:\/\/danvanfleet.com\/?p=540"},"modified":"2013-04-08T15:47:58","modified_gmt":"2013-04-08T20:47:58","slug":"proform-crystal-report-print-if-no-tracking-item","status":"publish","type":"post","link":"https:\/\/danvanfleet.com\/index.php\/proform-crystal-report-print-if-no-tracking-item\/","title":{"rendered":"ProForm Crystal Report, Print if No Tracking item"},"content":{"rendered":"<p>Today I needed a digression to give my brain a rest.&nbsp; So I went looking for a decent blog post, and ran across this note, from something I was doing in March 2011.&nbsp; The question that needs answered is how do I print only files that <strong>don&#8217;t<\/strong> have a specific tracking item.<\/p>\n<p><!--more--><\/p>\n<p>&nbsp; <\/p>\n<p>More specifically the report needs to pull all files where the Settlement Status is Pending and it\u2019s a cash sale, where that file doesn\u2019t have a tracking item called \u201cBank Owned\u201d. <\/p>\n<p>To do this, set the report criteria to grab Status = Pending and Cash Sale is selected. <\/p>\n<p>Setup a Group on FirmFile <\/p>\n<p>Put all the output fields necessary in the Group Footer FirmFile. <\/p>\n<p>Create a formula If {trackitems.what} = &#8220;Bank Owned&#8221; , return an 1, else 0.  <\/p>\n<p>Create a running total of that, which gets reset on group FirmFile that sums. <\/p>\n<p>Finally put a suppress formula on the footer If runningTotal &gt; 0 Then True, Else False. <\/p>\n<p>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&#8217;s in the Group Footer FirmFile) <\/p>\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today I needed a digression to give my brain a rest.&nbsp; So I went looking for a decent blog post, and ran across this note, from something I was doing in March 2011.&nbsp; The question that needs answered is how do I print only files that don&#8217;t have a specific tracking item.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23,5],"tags":[21,27],"class_list":["post-540","post","type-post","status-publish","format-standard","hentry","category-softpro-2","category-using-computers","tag-proform","tag-reports","entry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wyVb-8I","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/comments?post=540"}],"version-history":[{"count":1,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/540\/revisions"}],"predecessor-version":[{"id":541,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/540\/revisions\/541"}],"wp:attachment":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/media?parent=540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/categories?post=540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/tags?post=540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}