Supressing detail lines when printing a report 3

[cud5]

I am printing an AR Trial balance. I would like to suppress lines that have no invoice number(IDINVC) or if the invoice number is a duplicate of the invoice number on the previous line.

I am assuming that if they aren't printed they won't be in the totals, is that correct?

Can anyone help me on the formula I would need to use.

Thanks

 

[Madawc]

Right-click on the section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.

If you don't need those invoices for some other purpose, it would be quciker to reject them in your Record Selection.

As for totals, a summary total will show anything selected, whether or not it prints. A running total can be given its own rules, which need not be the same as those for printing. The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

The section suppression formula would look like:

isnull({table.IDINVC}) or
{table.IDINVC} = previous({table.IDINVC})

Do not check the box next to the suppression formula area.

You would have to exclude records in a running total by using the opposite of the suppression formula in the evaluation area of the running total, e.g.:

not isnull({table.IDINVC}) and
(
onfirstrecord or
{table.IDINVC} <> previous({table.IDINVC})
)

-LB

 

[cud5]

Thank you LG this was very helpful and gave me the tips I needed to fix my report.