Yes, it is possible sometimes, maybe.
With the Cut List, I was able to do this in the RDD:
CutList(standard table) --> JobHead(new table 1)
JobHead(new table 1) --> CustXPrt(new table 2)
JobHead(new table 1) --> Part(new table 3)
After finishing my Relationship in the Report Data Definition, then I repeat the same linking in Crystal. The Crystal Report correctly displays all the data I need from the proper tables for the Cut List.
However, I did not have the same positive results with the Job Traveler. On the Job Traveler, I am trying to do this:
JobPart(standard table) --> CustXPrt(new table 1)
CustXPrt(new table 1) --> Customer(new table 2)
But Vantage will not send any data from the Customer table to the Crystal Report. All of the Customer fields are blank in Crystal. I have been unable to figure out why this works with the Cut List RDD, but will not work with the Job Traveler RDD.
Vantage 8.03.404
Lynn
With the Cut List, I was able to do this in the RDD:
CutList(standard table) --> JobHead(new table 1)
JobHead(new table 1) --> CustXPrt(new table 2)
JobHead(new table 1) --> Part(new table 3)
After finishing my Relationship in the Report Data Definition, then I repeat the same linking in Crystal. The Crystal Report correctly displays all the data I need from the proper tables for the Cut List.
However, I did not have the same positive results with the Job Traveler. On the Job Traveler, I am trying to do this:
JobPart(standard table) --> CustXPrt(new table 1)
CustXPrt(new table 1) --> Customer(new table 2)
But Vantage will not send any data from the Customer table to the Crystal Report. All of the Customer fields are blank in Crystal. I have been unable to figure out why this works with the Cut List RDD, but will not work with the Job Traveler RDD.
Vantage 8.03.404
Lynn
--- In vantage@yahoogroups.com, tomas paulavicius <tpaulavicius@...> wrote:
>
> I am on 8.03 version
>
>
>
>
>
>
>
>
>
>
>
>
> If you are in 8.03, then yes you can do this and yes you have to link the new table to one of the existing tables.
>
> Existing table should be one of standard report or can it be isn previous step added new table?
>
> When I link (Standart table)<->(New table 1) and (Standart table)<->(New table 2) I get all data, but it is incorrect.
>
> But when I link (Standart table)<->(New table 1)<->(New table 2) I do not get (New table 2 ) data, but I need to get It this way.
>
> Is it possible to link tables this way?
>
> Tom
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>