/learn/b/announcements/posts/sugar-reports-from-confusion-to-clarity-filters-totals-and-common-pitfallsReporting is powerful&hellip; but it&rsquo;s not always intuitive. Reporting is one of the most valuable capabilities in Sugar. It&rsquo;s how you understand performance, track pipeline and activity, identify risks and opportunities, and make decisio...en-USTelligent Community 12https://sugarclub.sugarai.com/learn/b/announcements/posts/sugar-reports-from-confusion-to-clarity-filters-totals-and-common-pitfallsThu, 30 Apr 2026 13:29:24 GMT5c521d64-519d-47a6-9065-134618b211bf:8fafd346-a26e-497d-b184-8a7b1e34c3feAnamaria Vintila0<p data-start="82" data-end="214">To my knowledge, in standard Sugar reports, you can&rsquo;t automatically limit related records (such as Contacts) to one per Account.</p> <p data-start="216" data-end="415">One option is to create a <strong data-start="242" data-end="261">Primary Contact</strong> field in the Account record view layout and then filter by that field. This should result in only one Contact per Account (assuming the data is clean). You could also try enabling <strong data-start="445" data-end="470">Show Distinct Results</strong>, but this removes duplicate Accounts, not Contacts, and you may lose visibility into which Contact is shown.&nbsp;</p> <p data-start="216" data-end="415">&nbsp;[mention:4b225cc964ae4f00b2fd1795bae35b8f:08ca0da0e0174a809832476c74d4f174]&nbsp;&nbsp;</p><img src="https://sugarclub.sugarai.com/aggbug?PostID=4776&AppID=35&AppType=Weblog&ContentType=0" width="1" height="1">https://sugarclub.sugarai.com/learn/b/announcements/posts/sugar-reports-from-confusion-to-clarity-filters-totals-and-common-pitfallsWed, 29 Apr 2026 19:23:09 GMT5c521d64-519d-47a6-9065-134618b211bf:8fafd346-a26e-497d-b184-8a7b1e34c3feDawn Little0<p>When creating a report for a list of accounts with related contacts, can you print report to show only the main contact or your favorite contact? I want to list only one contact per account. Is this possible?</p><img src="https://sugarclub.sugarai.com/aggbug?PostID=4776&AppID=35&AppType=Weblog&ContentType=0" width="1" height="1">