Crystal Reports - Packing Slip

Works!

Since I haven't worked with "Linked Tables" before, here are the
mistakes I made:

1) Chose the wrong Linked Table, used the default.
2) Forgot to "Verify Database" in Crystal Reports XI
3) Didn't recognized that linked tables are preceded with
Table_Description, i.e., Customer_TermsCode.

Thank for the help, Nigel.

Regards,

--SF

--- In vantage@yahoogroups.com, "Nigel Kerley" <nigel.kerley@...> wrote:
>
> Yes. Then make sure the field "TermsCode" is listed in "Fields
> Picked" (tab: Report Table | Linked Tables | Description Fields).
>
>
>
> --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> >
> > Do you add the Ordernum link to the ShipDtl in Report Data
> Definitions?
> >
> > --SF
> >
> > --- In vantage@yahoogroups.com, "Nigel Kerley" <nigel.kerley@>
> wrote:
> > >
> > > We got the TermsCode to print by amending the data definition and
> > > adding in the OrderNum link to the ShipDtl table.
> > >
> > > I haven't found a way to add in the actual description but I keep
> > > meaning to an ODBC connection to the layout to lookup the
> Description
> > > from the DB itself. Just haven't gotten around to it yet.
> > >
> > > (We're on v8.03)
> > >
> > >
> > > Nigel.
> > >
> > >
> > > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@>
> wrote:
> > > >
> > > > Has anybody been able to print the "TERMS" from Sales Order
> Entry on a
> > > > Packing Slip?
> > > >
> > > > --SF
> > > >
> > >
> >
>
Has anybody been able to print the "TERMS" from Sales Order Entry on a
Packing Slip?

--SF
We got the TermsCode to print by amending the data definition and
adding in the OrderNum link to the ShipDtl table.

I haven't found a way to add in the actual description but I keep
meaning to an ODBC connection to the layout to lookup the Description
from the DB itself. Just haven't gotten around to it yet.

(We're on v8.03)


Nigel.


--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> Has anybody been able to print the "TERMS" from Sales Order Entry on a
> Packing Slip?
>
> --SF
>
Do you add the Ordernum link to the ShipDtl in Report Data Definitions?

--SF

--- In vantage@yahoogroups.com, "Nigel Kerley" <nigel.kerley@...> wrote:
>
> We got the TermsCode to print by amending the data definition and
> adding in the OrderNum link to the ShipDtl table.
>
> I haven't found a way to add in the actual description but I keep
> meaning to an ODBC connection to the layout to lookup the Description
> from the DB itself. Just haven't gotten around to it yet.
>
> (We're on v8.03)
>
>
> Nigel.
>
>
> --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> >
> > Has anybody been able to print the "TERMS" from Sales Order Entry on a
> > Packing Slip?
> >
> > --SF
> >
>
Yes. Then make sure the field "TermsCode" is listed in "Fields
Picked" (tab: Report Table | Linked Tables | Description Fields).



--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> Do you add the Ordernum link to the ShipDtl in Report Data
Definitions?
>
> --SF
>
> --- In vantage@yahoogroups.com, "Nigel Kerley" <nigel.kerley@>
wrote:
> >
> > We got the TermsCode to print by amending the data definition and
> > adding in the OrderNum link to the ShipDtl table.
> >
> > I haven't found a way to add in the actual description but I keep
> > meaning to an ODBC connection to the layout to lookup the
Description
> > from the DB itself. Just haven't gotten around to it yet.
> >
> > (We're on v8.03)
> >
> >
> > Nigel.
> >
> >
> > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@>
wrote:
> > >
> > > Has anybody been able to print the "TERMS" from Sales Order
Entry on a
> > > Packing Slip?
> > >
> > > --SF
> > >
> >
>