Figured it out. I was looking for the JobShip table that is included
when you select "Scheduled Shipments." Also, I found the CustID that
I need from the Calc_CustID in the JobHead.
So now I can print the PO# and CustID on the Traveler like I wanted
to do.
I know that one person hinted to the JobShip table, but add that
table to the main report, use the default links, and don't
check "Shipment Schedule" the page is blank. I fixed this by
removing the links from the JobShip table. Now if you don't
select "Shipment Schedule" it just won't print the PO# along with the
Shipment Schedule.
Thanks,
--SF
when you select "Scheduled Shipments." Also, I found the CustID that
I need from the Calc_CustID in the JobHead.
So now I can print the PO# and CustID on the Traveler like I wanted
to do.
I know that one person hinted to the JobShip table, but add that
table to the main report, use the default links, and don't
check "Shipment Schedule" the page is blank. I fixed this by
removing the links from the JobShip table. Now if you don't
select "Shipment Schedule" it just won't print the PO# along with the
Shipment Schedule.
Thanks,
--SF
--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> VB fields? VB fields on the Crystal Report Job Traveler?
>
> --- In vantage@yahoogroups.com, "Michael McWilliams"
> <mmcwilliams22@> wrote:
> >
> > What I do is Copy the OrderDtl VB fields by clicking a button in
> > JobEntry. Then I just added the JobHead VB fields to the
Traveler.
> > You can change the VB fields on the JobHed even if it is
> engineered.
> > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@>
> > wrote:
> > >
> > > Michael, do you print the PO# on the Traveler, if so, how?
> > >
> > > --SF
> > >
> > > --- In vantage@yahoogroups.com, "Michael McWilliams"
> > > <mmcwilliams22@> wrote:
> > > >
> > > > I have mine working this way:
> > > > FKV
> > > > View Name OrderHead
> > > > Parent View Name MakeToOrder
> > > >
> > > > Column Name MakeToOrder.OrderNum
> > > >
> > > >
> > > > Then I have a SubTable View
> > > > View Name OrderDetail
> > > > Parent View Name OrderHead
> > > > View Type Sub Table View
> > > >
> > > > Sub Table Name: OrderDtl
> > > >
> > > > Then for parent view and child view colums Add
> > > > Company
> > > > OrderNum
> > > > OrderLine
> > > >
> > > > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@>
> > > > wrote:
> > > > >
> > > > > Yes, after adding the foreign key, I have complete access
to
> > the
> > > > > OrderDtl. table in the Job Entry screen, isn't this what
> > you're
> > > > > trying to do?
> > > > >
> > > > > --SF
> > > > >
> > > > > --- In vantage@yahoogroups.com, "Scott Litzau"
> <scott.litzau@>
> > > > > wrote:
> > > > > >
> > > > > > I thought you were taking it from JobProd. I am trying to
> > > > connect
> > > > > OrderDtl
> > > > > > to JobHead.
> > > > > >
> > > > > > Thanks anyway,
> > > > > >
> > > > > > Scott
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: vantage@yahoogroups.com
> > [mailto:vantage@yahoogroups.com]
> > > > On
> > > > > Behalf Of
> > > > > > sanfranc415
> > > > > > Sent: Wednesday, April 18, 2007 11:18 AM
> > > > > > To: vantage@yahoogroups.com
> > > > > > Subject: [Vantage] Re: Printing PO# on Job Traveler.
> > > > > >
> > > > > >
> > > > > > I added a "Foreign Key" with the followwing:
> > > > > >
> > > > > > View Name: OrderPONumber
> > > > > > Parent View Name: JobProd
> > > > > > View Type: Foreign Key View
> > > > > >
> > > > > > Foreign Key View Info:
> > > > > > Column Name: JobProd.OrderNum
> > > > > > Like Column Value: OrderHed.OrderNum
> > > > > > Adapter Name: SalesOrderAdapter
> > > > > >
> > > > > > --SF
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, "Scott Litzau"
> > <scott.litzau@>
> > > > > > wrote:
> > > > > > >
> > > > > > > How did you get the PO Number on the Job Entry Screen.
I
> > have
> > > > > been
> > > > > > trying to
> > > > > > > get some VB fields (ShortChar01 and 02) from Order to
Job
> > but
> > > > > have
> > > > > > been
> > > > > > > unsuccessful.
> > > > > > >
> > > > > > > Scott
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: vantage@yahoogroups.com
> > > [mailto:vantage@yahoogroups.com]
> > > > On
> > > > > > Behalf Of
> > > > > > > sanfranc415
> > > > > > > Sent: Wednesday, April 18, 2007 9:32 AM
> > > > > > > To: vantage@yahoogroups.com
> > > > > > > Subject: [Vantage] Printing PO# on Job Traveler.
> > > > > > >
> > > > > > >
> > > > > > > Hello,
> > > > > > >
> > > > > > > I'm trying to add the PO# from the Sales Order table to
> > Job
> > > > > > Traveler.
> > > > > > > I've been able to link the PO# to show up on the Job
> Entry
> > > > screen,
> > > > > > > but can't seem to be able to get the Sales Order table
to
> > > show
> > > > up
> > > > > on
> > > > > > > the Crystal Report.
> > > > > > >
> > > > > > > Also, I'm able to add the Sales Order table to the
Report
> > > > > > Definition,
> > > > > > > but can't get the data to populate on the report.
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > --SF
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Useful links for the Yahoo!Groups Vantage Board are: (
> > Note:
> > > > You
> > > > > > must have
> > > > > > > already linked your email address to a yahoo id to
enable
> > > > > access. )
> > > > > > > (1) To access the Files Section of our Yahoo!Group for
> > Report
> > > > > > Builder and
> > > > > > > Crystal Reports and other 'goodies', please goto:
> > > > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > > > (2) To search through old msg's goto:
> > > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > > (3) To view links to Vendors that provide Vantage
> services
> > > > goto:
> > > > > > > http://groups.yahoo.com/group/vantage/links
> > > > > > > Yahoo! Groups Links
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > Useful links for the Yahoo!Groups Vantage Board are: (
> > Note:
> > > > You
> > > > > must have
> > > > > > already linked your email address to a yahoo id to enable
> > > > access. )
> > > > > > (1) To access the Files Section of our Yahoo!Group for
> > Report
> > > > > Builder and
> > > > > > Crystal Reports and other 'goodies', please goto:
> > > > > > http://groups.yahoo.com/group/vantage/files/.
> > > > > > (2) To search through old msg's goto:
> > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > (3) To view links to Vendors that provide Vantage
services
> > goto:
> > > > > > http://groups.yahoo.com/group/vantage/links
> > > > > > Yahoo! Groups Links
> > > > > >
> > > > >
> > > >
> > >
> >
>