Hide Records if data field exsist.

Hello all,

Im trying to hide all invoice transactions if the Payment Number or a Payment exist.

Data is like below

Inv Number | Description | Charge | Payment | Pay Number
1                 Settlement      50
1                  Payment                     50             1
2                 Settlement      100
3                 Settlement      70
3                  Payment                     70             2

All I need to be displaying here is invoice 2 line as payment still needs to be made to this.

any help is much appreciated

This is not something that is easy to do just by linking tables together and setting hide or suppress formulas on the report.

Do you need to include the data from paid invoices in any of the calculations on the report? If not, there is a way to do this using a Command (SQL Select statement) instead of linking tables together.

If you'll go to the Database menu for the report, select "Show SQL Query", and paste the query here, I can rewrite it for you to show you how to do this.

Also, see my blog post for more info about how to properly use a Command in a report: Best Practices When Using Commands with Crystal Reports

-Dell