Including Sales Order Date on Job Traveler

Yahoo Archive
1
Rob, I dont know if your reply was to me, or the OP, I did add a relationship in the RDD

Parent table: JobHead
Child Table: OrderHed
Key: JobNum

Relationship fields: Company - Comany.



--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> Did you add a relationship to the RDD?
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of howco22
> Sent: Wednesday, April 14, 2010 4:41 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Including Sales Order Date on Job Traveler
>
>
>
>
>
> In Crystal you need to include it in the database. Go to the database
> tab, click on database expert, under the data tab, go to current
> connection, (available data source), highlifght the OrderHed talbe then
> click the right arrow to move the orderhed talbe to the selected tables
> (rightside).
>
> You will have to run the report using the new RDD to beable to see
> these. PM me With your tel # & I can call tomorrow if you have any other
> questions.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "sanfranc415" <sanfranc415@> wrote:
> >
> >
> > I'm doing something wrong. I successfully created the "Left-Outer
> Joins," but for some reason the OrderHed table doesn't have any data
> associated with it in Crystal.
> >
> > Do I need to do more than just add the Orderhed table to the Report
> Data Definition?
> >
> > Thanks,
> >
> > --sf
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "howco22" <agortman@> wrote:
> > >
> > > I linked the OrderHed.OrderNum to JobShip.OrderNum, &
> OrderHed.Comany to JobHead.company, Both Outer left Join.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "sanfranc415" <sanfranc415@> wrote:
> > > >
> > > > How did you link the OrderHed table in Crystal Reports?
> > > >
> > > > Thanks,
> > > >
> > > > --sf
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> , "howco22" <agortman@> wrote:
> > > > >
> > > > > I dont beleive it is in the standard RDD.
> > > > >
> > > > > I had modified my Job Travelers, but added sales order number &
> customer name on the traveler.
> > > > > I made a copy of the the RDD, & added the OrderHed table, the
> sales order date would be in the OrderHed table.
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> , "sanfranc415" <sanfranc415@> wrote:
> > > > > >
> > > > > > I'm trying to populate a Job Traveler with the Sales Order
> Date. Can somebody tell me where to find this information in the "Report
> Data Maintenance?"
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > --sf
> > > > > >
> > > > >
> > > >
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I'm trying to populate a Job Traveler with the Sales Order Date. Can somebody tell me where to find this information in the "Report Data Maintenance?"

Thanks,

--sf
3
I dont beleive it is in the standard RDD.

I had modified my Job Travelers, but added sales order number & customer name on the traveler.
I made a copy of the the RDD, & added the OrderHed table, the sales order date would be in the OrderHed table.



--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> I'm trying to populate a Job Traveler with the Sales Order Date. Can somebody tell me where to find this information in the "Report Data Maintenance?"
>
> Thanks,
>
> --sf
>
4
How did you link the OrderHed table in Crystal Reports?

Thanks,

--sf

--- In vantage@yahoogroups.com, "howco22" <agortman@...> wrote:
>
> I dont beleive it is in the standard RDD.
>
> I had modified my Job Travelers, but added sales order number & customer name on the traveler.
> I made a copy of the the RDD, & added the OrderHed table, the sales order date would be in the OrderHed table.
>
>
>
> --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> >
> > I'm trying to populate a Job Traveler with the Sales Order Date. Can somebody tell me where to find this information in the "Report Data Maintenance?"
> >
> > Thanks,
> >
> > --sf
> >
>
5
I linked the OrderHed.OrderNum to JobShip.OrderNum, & OrderHed.Comany to JobHead.company, Both Outer left Join.

--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
> How did you link the OrderHed table in Crystal Reports?
>
> Thanks,
>
> --sf
>
> --- In vantage@yahoogroups.com, "howco22" <agortman@> wrote:
> >
> > I dont beleive it is in the standard RDD.
> >
> > I had modified my Job Travelers, but added sales order number & customer name on the traveler.
> > I made a copy of the the RDD, & added the OrderHed table, the sales order date would be in the OrderHed table.
> >
> >
> >
> > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> > >
> > > I'm trying to populate a Job Traveler with the Sales Order Date. Can somebody tell me where to find this information in the "Report Data Maintenance?"
> > >
> > > Thanks,
> > >
> > > --sf
> > >
> >
>
6
I'm doing something wrong. I successfully created the "Left-Outer Joins," but for some reason the OrderHed table doesn't have any data associated with it in Crystal.

Do I need to do more than just add the Orderhed table to the Report Data Definition?

Thanks,

--sf
--- In vantage@yahoogroups.com, "howco22" <agortman@...> wrote:
>
> I linked the OrderHed.OrderNum to JobShip.OrderNum, & OrderHed.Comany to JobHead.company, Both Outer left Join.
>
> --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> >
> > How did you link the OrderHed table in Crystal Reports?
> >
> > Thanks,
> >
> > --sf
> >
> > --- In vantage@yahoogroups.com, "howco22" <agortman@> wrote:
> > >
> > > I dont beleive it is in the standard RDD.
> > >
> > > I had modified my Job Travelers, but added sales order number & customer name on the traveler.
> > > I made a copy of the the RDD, & added the OrderHed table, the sales order date would be in the OrderHed table.
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> > > >
> > > > I'm trying to populate a Job Traveler with the Sales Order Date. Can somebody tell me where to find this information in the "Report Data Maintenance?"
> > > >
> > > > Thanks,
> > > >
> > > > --sf
> > > >
> > >
> >
>
7
In Crystal you need to include it in the database. Go to the database tab, click on database expert, under the data tab, go to current connection, (available data source), highlifght the OrderHed talbe then click the right arrow to move the orderhed talbe to the selected tables (rightside).

You will have to run the report using the new RDD to beable to see these. PM me With your tel # & I can call tomorrow if you have any other questions.

--- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@...> wrote:
>
>
> I'm doing something wrong. I successfully created the "Left-Outer Joins," but for some reason the OrderHed table doesn't have any data associated with it in Crystal.
>
> Do I need to do more than just add the Orderhed table to the Report Data Definition?
>
> Thanks,
>
> --sf
> --- In vantage@yahoogroups.com, "howco22" <agortman@> wrote:
> >
> > I linked the OrderHed.OrderNum to JobShip.OrderNum, & OrderHed.Comany to JobHead.company, Both Outer left Join.
> >
> > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> > >
> > > How did you link the OrderHed table in Crystal Reports?
> > >
> > > Thanks,
> > >
> > > --sf
> > >
> > > --- In vantage@yahoogroups.com, "howco22" <agortman@> wrote:
> > > >
> > > > I dont beleive it is in the standard RDD.
> > > >
> > > > I had modified my Job Travelers, but added sales order number & customer name on the traveler.
> > > > I made a copy of the the RDD, & added the OrderHed table, the sales order date would be in the OrderHed table.
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "sanfranc415" <sanfranc415@> wrote:
> > > > >
> > > > > I'm trying to populate a Job Traveler with the Sales Order Date. Can somebody tell me where to find this information in the "Report Data Maintenance?"
> > > > >
> > > > > Thanks,
> > > > >
> > > > > --sf
> > > > >
> > > >
> > >
> >
>
8
Did you add a relationship to the RDD?



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of howco22
Sent: Wednesday, April 14, 2010 4:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Including Sales Order Date on Job Traveler





In Crystal you need to include it in the database. Go to the database
tab, click on database expert, under the data tab, go to current
connection, (available data source), highlifght the OrderHed talbe then
click the right arrow to move the orderhed talbe to the selected tables
(rightside).

You will have to run the report using the new RDD to beable to see
these. PM me With your tel # & I can call tomorrow if you have any other
questions.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"sanfranc415" <sanfranc415@...> wrote:
>
>
> I'm doing something wrong. I successfully created the "Left-Outer
Joins," but for some reason the OrderHed table doesn't have any data
associated with it in Crystal.
>
> Do I need to do more than just add the Orderhed table to the Report
Data Definition?
>
> Thanks,
>
> --sf
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"howco22" <agortman@> wrote:
> >
> > I linked the OrderHed.OrderNum to JobShip.OrderNum, &
OrderHed.Comany to JobHead.company, Both Outer left Join.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"sanfranc415" <sanfranc415@> wrote:
> > >
> > > How did you link the OrderHed table in Crystal Reports?
> > >
> > > Thanks,
> > >
> > > --sf
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
, "howco22" <agortman@> wrote:
> > > >
> > > > I dont beleive it is in the standard RDD.
> > > >
> > > > I had modified my Job Travelers, but added sales order number &
customer name on the traveler.
> > > > I made a copy of the the RDD, & added the OrderHed table, the
sales order date would be in the OrderHed table.
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> , "sanfranc415" <sanfranc415@> wrote:
> > > > >
> > > > > I'm trying to populate a Job Traveler with the Sales Order
Date. Can somebody tell me where to find this information in the "Report
Data Maintenance?"
> > > > >
> > > > > Thanks,
> > > > >
> > > > > --sf
> > > > >
> > > >
> > >
> >
>





[Non-text portions of this message have been removed]