PDA

View Full Version : How to supress printing on zero invoice



Tod Brannen
2-Nov-2005, 01:03 PM
Greetings,
I have created a bill using Crystal XI and it works fine. The problem is
it prints a bill for each person if they have charges, even if they have
offsetting payments. How do I stop the zero balances from printing?

Thanks,

Tod Brannen

corey
15-Nov-2005, 07:54 PM
Hi Tod,

It depends on how you have the report structured, in the record
selection you could add a criteria that states that the the total must
be <> 0. Alternately you could use the section suppress under the
section expert to hide these.

Hope this helps
Corey

Tod Brannen wrote:
> Greetings,
> I have created a bill using Crystal XI and it works fine. The problem is
> it prints a bill for each person if they have charges, even if they have
> offsetting payments. How do I stop the zero balances from printing?
>
> Thanks,
>
> Tod Brannen
>
>

Free Agent
15-Nov-2005, 11:39 PM
Hi Corey,
In this case the invoice will have an even number of records. Each set
of records will total to zero, for example a charge of $5 and a payment of
$5. Then after printing these the total is zero. I can't suppress records
before I know if the total is going to be zero, or can I???
If you know how to suppress the records and the total and everything, please
let me know.

Thanks,

Tod Brannen

"corey" <corey@informaticadotcomdotau> wrote in message
news:pJyf2gk6FHA.2168@dacmail.dataaccess.com...
> Hi Tod,
>
> It depends on how you have the report structured, in the record
> selection you could add a criteria that states that the the total must
> be <> 0. Alternately you could use the section suppress under the
> section expert to hide these.
>
> Hope this helps
> Corey
>
> Tod Brannen wrote:
> > Greetings,
> > I have created a bill using Crystal XI and it works fine. The
problem is
> > it prints a bill for each person if they have charges, even if they have
> > offsetting payments. How do I stop the zero balances from printing?
> >
> > Thanks,
> >
> > Tod Brannen
> >
> >

corey
16-Nov-2005, 05:31 PM
Tod,

I assume that you have your report grouped (by customer) and that you
print a separate invoice for each customer. In the bottom of the group
you will have a summary, if you have, then you can then suppress each
section (group header, Data and group footer) if the total of the
summary = 0.

Corey


Free Agent wrote:
> Hi Corey,
> In this case the invoice will have an even number of records. Each set
> of records will total to zero, for example a charge of $5 and a payment of
> $5. Then after printing these the total is zero. I can't suppress records
> before I know if the total is going to be zero, or can I???
> If you know how to suppress the records and the total and everything, please
> let me know.
>
> Thanks,
>
> Tod Brannen
>
> "corey" <corey@informaticadotcomdotau> wrote in message
> news:pJyf2gk6FHA.2168@dacmail.dataaccess.com...
>
>>Hi Tod,
>>
>>It depends on how you have the report structured, in the record
>>selection you could add a criteria that states that the the total must
>>be <> 0. Alternately you could use the section suppress under the
>>section expert to hide these.
>>
>>Hope this helps
>>Corey
>>
>>Tod Brannen wrote:
>>
>>>Greetings,
>>> I have created a bill using Crystal XI and it works fine. The
>
> problem is
>
>>>it prints a bill for each person if they have charges, even if they have
>>>offsetting payments. How do I stop the zero balances from printing?
>>>
>>>Thanks,
>>>
>>>Tod Brannen
>>>
>>>
>
>
>