Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Remove Entries while printing Post Reply Post New Topic
Author Message
aclake7
Newbie
Newbie


Joined: 01 Dec 2016
Location: United States
Online Status: Offline
Posts: 1
Quote aclake7 Replybullet Topic: Remove Entries while printing
    Posted: 05 Dec 2016 at 8:19am
Hello, I am rather new to using crystal reports and have mostly just used googling to figure out basic things. However I have a rather specific issue now that I am working on and hopefully the users here can provide some insight.

So, I have a report that prints all documents that affect a particular AR account. What I would like to do is to implement something that removes entries that are matching totals under the same document while printing. In case that is confusing I have attached a picture, the highlighted area shows two documents (an invoice and a supplier receipt) that are for the same purchase order/purchase receipt and the totals cancel each other out as they should. As I said previously, I would like to have the entries removed if possible so we can see documents that are not fully matched.

screen capture software

Edited by aclake7 - 05 Dec 2016 at 8:21am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 05 Dec 2016 at 9:27am
Do do just want to hide document information (no details) if the total is zero? If so then I would group by the document number. Hide the details.  Have a running totals for the debits and credits.  In the group footer have information you want then suppress the group if the debits - credits = 0
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.