Re: Crystal Reporting of ALL Invoices

Webjogger ( (no email) )
Sat, 4 Apr 1998 09:35:20 -0500

It IS possible to make a crystal report showing all invoices ever created
and all the associated payments, paid or unpaid.

In case anyone ever needs to do it, the trick is to link the InvoiceItems
table to the Payments table using a left outer [=(+) *=] link. You can do
this by opening the Visual Linking Expert, clicking on the link line
between the two tables, selecting Options..., and modifying the SQL Join
Type to Left Outer.

This link lets you link two tables and show all of the data in the first
table even if it doesn't have any corresponding entry in the second table.

Webjogger Internet Services
> From: Dale E. Reed Jr. <>
> To:
> Subject: Re: Crystal Reporting of ALL Invoices
> Date: Monday, March 23, 1998 12:25 PM
> Webjogger wrote:
> >
> > Thanks, Dale, for the suggestion. I tried it, but the invoices I'm
> > still don't appear.
> But are those invoices paid? If there isn't a payment for them,
> they won't show.
> --
> Dale E. Reed Jr. (
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List