Priority Dispatch Report - JobMtl table

Yahoo Archive
1
>pretty much the situation I keep running into
>doesn't really make any sense
Tables like sJCR65 are work tables and get populated on the fly.
As far as I know, there is not much an end user is allowed to do with them.

--- In vantage@yahoogroups.com, "vacortes21" <vcortes@...> wrote:
>
> Thanks for your reply. that is pretty much the situation I keep running into and it doesnt really make any sense why it doesn't work.
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > I've never had luck building a relationship to a table like JCR65.
> > I have added tables with a relationship to the company.company field.
> > Or in some case, no relationship at all.
> > Then I'll make my joins in Crytal.
> > I remember in one case, I still had to use a subreport.
> >
> >
> > --- In vantage@yahoogroups.com, "vacortes21" <vcortes@> wrote:
> > >
> > > Hi,
> > > I am working with Vantage 8.03.409C - Priorty Dispatch Report. what i am trying to accomplish is, add the JobMtl.PartNum by joining the system table *JCR65* used by the report to the JobMtl table which is already built into the Report Defenition as well! I created a Copy of the Report Defenition PrioDisp and add the "RelatedOperation" field to the JobMtl Table because I need to Join them by JobNum and OprSeq (JCR65.JobNum = JobMtl.JobNum AND JCR65.OprSeq = JobMtl.RelatedOperation). however when i used this new DataSet in Crystal Reports it return totally differnt results with differnt Job#'s and Multiple identical lines.
> > >
> > > has anyone attempted to do this or have any tips that could help me?
> > >
> > > Thanks in Advance!
> > >
> >
>
2
Hi,
I am working with Vantage 8.03.409C - Priorty Dispatch Report. what i am trying to accomplish is, add the JobMtl.PartNum by joining the system table *JCR65* used by the report to the JobMtl table which is already built into the Report Defenition as well! I created a Copy of the Report Defenition PrioDisp and add the "RelatedOperation" field to the JobMtl Table because I need to Join them by JobNum and OprSeq (JCR65.JobNum = JobMtl.JobNum AND JCR65.OprSeq = JobMtl.RelatedOperation). however when i used this new DataSet in Crystal Reports it return totally differnt results with differnt Job#'s and Multiple identical lines.

has anyone attempted to do this or have any tips that could help me?

Thanks in Advance!
3
I've never had luck building a relationship to a table like JCR65.
I have added tables with a relationship to the company.company field.
Or in some case, no relationship at all.
Then I'll make my joins in Crytal.
I remember in one case, I still had to use a subreport.


--- In vantage@yahoogroups.com, "vacortes21" <vcortes@...> wrote:
>
> Hi,
> I am working with Vantage 8.03.409C - Priorty Dispatch Report. what i am trying to accomplish is, add the JobMtl.PartNum by joining the system table *JCR65* used by the report to the JobMtl table which is already built into the Report Defenition as well! I created a Copy of the Report Defenition PrioDisp and add the "RelatedOperation" field to the JobMtl Table because I need to Join them by JobNum and OprSeq (JCR65.JobNum = JobMtl.JobNum AND JCR65.OprSeq = JobMtl.RelatedOperation). however when i used this new DataSet in Crystal Reports it return totally differnt results with differnt Job#'s and Multiple identical lines.
>
> has anyone attempted to do this or have any tips that could help me?
>
> Thanks in Advance!
>
4
Thanks for your reply. that is pretty much the situation I keep running into and it doesnt really make any sense why it doesn't work.

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> I've never had luck building a relationship to a table like JCR65.
> I have added tables with a relationship to the company.company field.
> Or in some case, no relationship at all.
> Then I'll make my joins in Crytal.
> I remember in one case, I still had to use a subreport.
>
>
> --- In vantage@yahoogroups.com, "vacortes21" <vcortes@> wrote:
> >
> > Hi,
> > I am working with Vantage 8.03.409C - Priorty Dispatch Report. what i am trying to accomplish is, add the JobMtl.PartNum by joining the system table *JCR65* used by the report to the JobMtl table which is already built into the Report Defenition as well! I created a Copy of the Report Defenition PrioDisp and add the "RelatedOperation" field to the JobMtl Table because I need to Join them by JobNum and OprSeq (JCR65.JobNum = JobMtl.JobNum AND JCR65.OprSeq = JobMtl.RelatedOperation). however when i used this new DataSet in Crystal Reports it return totally differnt results with differnt Job#'s and Multiple identical lines.
> >
> > has anyone attempted to do this or have any tips that could help me?
> >
> > Thanks in Advance!
> >
>