Suppressing field in the repeated records??

[vlad2]

I Created report based on two tbls(Invoice,Payment),I need to show Invoice and all payments of the invoice each payment has an invoiceID.In the last Column i need to display Total of Invoice from Invoice table.

If three payments were made for this Invoice I have three records and TotalInvoice is duplicating on each record.
The problem is --- When I want to calculate Grandtotal of invoice, i get incorrect results.

I want to display just InvoiceTotal one time independenly how many payments i have.How I can Suppress it.

Thank you .......

 

[dgillz]

Suppression is not the answer. Suppressed records will still evaluate in any sub or grand totalling you may be doing, which, in my case at least, is basically every single report.

Write two reports, one for invoices and one for payments, bioth grouped by invoiceID. The insert one inside the other with a linked subreport. You will need to create shared variables to total the 2 amounts.

please post again if you have any questions. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[vlad2]

Thanks for idea.
is there any other way to accomplish this?, I'm not familiar with Shared Var..

I modified this report
I put all Invoice info in a group header, and payment's info in detail section. So.. now i have invoice total displaing just one time. But I can't get a correct GrandTotal of all invoices,How i can get grand total?

Thanks in advance..

 

[balves]

Yikes. Way too complicated.

I'm assuming you can join the 2 tables.

Group by Invoice Id. Put the Invoice Id in the group header. You can put the Invoice Total in the group header or group footer. Put the payments in the detail.

You can create sub-totals or grand totals in a lot of different ways. You can add to the grand total only when the group changes. This is what you want.

 

[vlad2]

Thanks a lot ,it works!!! I resolved this problem following balves's idea...