Job Travler report data definition 9.05.607B

Yahoo Archive
1
Those steps are right. If only some of your jobs are make to order,
then change it to a left join. And you might need to fiddle with the
crystal report format or formulas later to prevent a large blank spot on
the page where the address would go.



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of randy.hunter75
Sent: Monday, August 20, 2012 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job Travler report data definition 9.05.607B





Brian

Thanks for your response. I'm still missing something however. I was
taking this one step (table) at a time. I added the jobprod table to the
report defintion and created a relationship between jobhead,jobprod
(company + jobnum), ran the report using the definition, set the
datasource in crystal to the xml file, added the table to the report and
matched the links in crystal to what I used in the data definition. This
part worked fine. I browsed data in the field explorer and everything
was fine. I could add fields to the report.

I then added the orderhed to the defintion, linked on company+ordernum,
updated the report data defintiion and I get no data in the orderhed
fields. If I add fields to the report, I get a blank report. I assume
this is from the inner join finding nothing.

What do you think I'm missing here?

Thanks in advance

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian Roberts" <broberts@...> wrote:
>
> Jobs are linked to orders via the JobProd table, and from there you
can
> link to OrderHed by Company+OrderNum. To get the actual customer name
&
> ship to address, you'll need the Customer or ShipTo table.
>
>
>
> In general, if you know what tables you want but not how to link them,
> try adding both tables in the BAQ builder and seeing how it
> automatically links them. Doesn't always work, but an easy shortcut.
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of randy.hunter75
> Sent: Friday, August 17, 2012 10:28 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Job Travler report data definition 9.05.607B
>
>
>
>
>
> I'm trying to add several fields to our job traveler. PO # and ship to
> address from the Sales order. Any advice on the proper table
> relationships in the data defintion to get this information?
>
> Thanks in advance for any help
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I'm trying to add several fields to our job traveler. PO # and ship to address from the Sales order. Any advice on the proper table relationships in the data defintion to get this information?

Thanks in advance for any help
3
You will want to add jobprod to your definition that will spider out to order related tables, thats the hub. I warn that what you are trying to do can and will get hairy I've done it before for custom labels from job entry. Make sure you include all of the keys in the data dic, I didn't the first time, and it was slooooooooooooooooooooooooooooooooooooow jobprod has a lot of keys

--- In vantage@yahoogroups.com, "randy.hunter75" <randy.hunter75@...> wrote:
>
> I'm trying to add several fields to our job traveler. PO # and ship to address from the Sales order. Any advice on the proper table relationships in the data defintion to get this information?
>
> Thanks in advance for any help
>
4
Jobs are linked to orders via the JobProd table, and from there you can
link to OrderHed by Company+OrderNum. To get the actual customer name &
ship to address, you'll need the Customer or ShipTo table.



In general, if you know what tables you want but not how to link them,
try adding both tables in the BAQ builder and seeing how it
automatically links them. Doesn't always work, but an easy shortcut.



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of randy.hunter75
Sent: Friday, August 17, 2012 10:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Job Travler report data definition 9.05.607B





I'm trying to add several fields to our job traveler. PO # and ship to
address from the Sales order. Any advice on the proper table
relationships in the data defintion to get this information?

Thanks in advance for any help





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

Thanks for your response. I'm still missing something however. I was taking this one step (table) at a time. I added the jobprod table to the report defintion and created a relationship between jobhead,jobprod (company + jobnum), ran the report using the definition, set the datasource in crystal to the xml file, added the table to the report and matched the links in crystal to what I used in the data definition. This part worked fine. I browsed data in the field explorer and everything was fine. I could add fields to the report.

I then added the orderhed to the defintion, linked on company+ordernum, updated the report data defintiion and I get no data in the orderhed fields. If I add fields to the report, I get a blank report. I assume this is from the inner join finding nothing.

What do you think I'm missing here?

Thanks in advance



--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Jobs are linked to orders via the JobProd table, and from there you can
> link to OrderHed by Company+OrderNum. To get the actual customer name &
> ship to address, you'll need the Customer or ShipTo table.
>
>
>
> In general, if you know what tables you want but not how to link them,
> try adding both tables in the BAQ builder and seeing how it
> automatically links them. Doesn't always work, but an easy shortcut.
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of randy.hunter75
> Sent: Friday, August 17, 2012 10:28 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job Travler report data definition 9.05.607B
>
>
>
>
>
> I'm trying to add several fields to our job traveler. PO # and ship to
> address from the Sales order. Any advice on the proper table
> relationships in the data defintion to get this information?
>
> Thanks in advance for any help
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Brian

Thanks for your response. I'm still missing something however. I was taking this one step (table) at a time. I added the jobprod table to the report defintion and created a relationship between jobhead,jobprod (company + jobnum), ran the report using the definition, set the datasource in crystal to the xml file, added the table to the report and matched the links in crystal to what I used in the data definition. This part worked fine. I browsed data in the field explorer and everything was fine. I could add fields to the report.

I then added the orderhed to the defintion, linked on company+ordernum, updated the report data defintiion and I get no data in the orderhed fields. If I add fields to the report, I get a blank report. I assume this is from the inner join finding nothing.

What do you think I'm missing here?

Thanks in advance



--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Jobs are linked to orders via the JobProd table, and from there you can
> link to OrderHed by Company+OrderNum. To get the actual customer name &
> ship to address, you'll need the Customer or ShipTo table.
>
>
>
> In general, if you know what tables you want but not how to link them,
> try adding both tables in the BAQ builder and seeing how it
> automatically links them. Doesn't always work, but an easy shortcut.
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of randy.hunter75
> Sent: Friday, August 17, 2012 10:28 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job Travler report data definition 9.05.607B
>
>
>
>
>
> I'm trying to add several fields to our job traveler. PO # and ship to
> address from the Sales order. Any advice on the proper table
> relationships in the data defintion to get this information?
>
> Thanks in advance for any help
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
Brian

Thanks for your response. I'm still missing something however. I was taking this one step (table) at a time. I added the jobprod table to the report defintion and created a relationship between jobhead,jobprod (company + jobnum), ran the report using the definition, set the datasource in crystal to the xml file, added the table to the report and matched the links in crystal to what I used in the data definition. This part worked fine. I browsed data in the field explorer and everything was fine. I could add fields to the report.

I then added the orderhed to the defintion, linked on company+ordernum, updated the report data defintiion and I get no data in the orderhed fields. If I add fields to the report, I get a blank report. I assume this is from the inner join finding nothing.

What do you think I'm missing here?

Thanks in advance



--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Jobs are linked to orders via the JobProd table, and from there you can
> link to OrderHed by Company+OrderNum. To get the actual customer name &
> ship to address, you'll need the Customer or ShipTo table.
>
>
>
> In general, if you know what tables you want but not how to link them,
> try adding both tables in the BAQ builder and seeing how it
> automatically links them. Doesn't always work, but an easy shortcut.
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of randy.hunter75
> Sent: Friday, August 17, 2012 10:28 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job Travler report data definition 9.05.607B
>
>
>
>
>
> I'm trying to add several fields to our job traveler. PO # and ship to
> address from the Sales order. Any advice on the proper table
> relationships in the data defintion to get this information?
>
> Thanks in advance for any help
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
8
Brian

Thanks for your response. I'm still missing something however. I was taking this one step (table) at a time. I added the jobprod table to the report defintion and created a relationship between jobhead,jobprod (company + jobnum), ran the report using the definition, set the datasource in crystal to the xml file, added the table to the report and matched the links in crystal to what I used in the data definition. This part worked fine. I browsed data in the field explorer and everything was fine. I could add fields to the report.

I then added the orderhed to the defintion, linked on company+ordernum, updated the report data defintiion and I get no data in the orderhed fields. If I add fields to the report, I get a blank report. I assume this is from the inner join finding nothing.

What do you think I'm missing here?

Thanks in advance



--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> Jobs are linked to orders via the JobProd table, and from there you can
> link to OrderHed by Company+OrderNum. To get the actual customer name &
> ship to address, you'll need the Customer or ShipTo table.
>
>
>
> In general, if you know what tables you want but not how to link them,
> try adding both tables in the BAQ builder and seeing how it
> automatically links them. Doesn't always work, but an easy shortcut.
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of randy.hunter75
> Sent: Friday, August 17, 2012 10:28 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job Travler report data definition 9.05.607B
>
>
>
>
>
> I'm trying to add several fields to our job traveler. PO # and ship to
> address from the Sales order. Any advice on the proper table
> relationships in the data defintion to get this information?
>
> Thanks in advance for any help
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
9
If a sales order doesn't actually exist in the system and you have it setup as an inner join blanking the entire report is the expected result.

Change it to a Left outer join. I'd also either run a job that you know has an associated sales order, or create a dummy one for your testing.

--- In vantage@yahoogroups.com, "randy.hunter75" <randy.hunter75@...> wrote:
>
> Brian
>
> Thanks for your response. I'm still missing something however. I was taking this one step (table) at a time. I added the jobprod table to the report defintion and created a relationship between jobhead,jobprod (company + jobnum), ran the report using the definition, set the datasource in crystal to the xml file, added the table to the report and matched the links in crystal to what I used in the data definition. This part worked fine. I browsed data in the field explorer and everything was fine. I could add fields to the report.
>
> I then added the orderhed to the defintion, linked on company+ordernum, updated the report data defintiion and I get no data in the orderhed fields. If I add fields to the report, I get a blank report. I assume this is from the inner join finding nothing.
>
> What do you think I'm missing here?
>
> Thanks in advance
>
>
>
> --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> >
> > Jobs are linked to orders via the JobProd table, and from there you can
> > link to OrderHed by Company+OrderNum. To get the actual customer name &
> > ship to address, you'll need the Customer or ShipTo table.
> >
> >
> >
> > In general, if you know what tables you want but not how to link them,
> > try adding both tables in the BAQ builder and seeing how it
> > automatically links them. Doesn't always work, but an easy shortcut.
> >
> >
> >
> > Brian.
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of randy.hunter75
> > Sent: Friday, August 17, 2012 10:28 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Job Travler report data definition 9.05.607B
> >
> >
> >
> >
> >
> > I'm trying to add several fields to our job traveler. PO # and ship to
> > address from the Sales order. Any advice on the proper table
> > relationships in the data defintion to get this information?
> >
> > Thanks in advance for any help
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>