Here is what I got so far:
In RDD:
I duplicated the RDD
Added the CustCnt table to it
Then added a relationship between FsCallhd [parent] and CustCnt [child] with key ShpConNum
and relationship fields: company-company; CustNum-custNum; ShpConNum-ConNum
In Report Style:
I added a new [test]style that uses my modified RDD and my modified report.
In Crystal:
I updated the datasource, saved, then ran the report in Vantage and updated again in Crystal with the new Datasource.
It seems to work for now and the fields come thru.
Plamen
In RDD:
I duplicated the RDD
Added the CustCnt table to it
Then added a relationship between FsCallhd [parent] and CustCnt [child] with key ShpConNum
and relationship fields: company-company; CustNum-custNum; ShpConNum-ConNum
In Report Style:
I added a new [test]style that uses my modified RDD and my modified report.
In Crystal:
I updated the datasource, saved, then ran the report in Vantage and updated again in Crystal with the new Datasource.
It seems to work for now and the fields come thru.
Plamen
--- In vantage@yahoogroups.com, "plamen21" <plamen21@...> wrote:
>
> Vantage 803.407C
> Trying to pull additional info into an existing report.
> Simply adding the Customer Contact Name, Phone Number and E-mail to the Service
> Call Ticket.
>
> How can I pull in CustCnt records where CustCnt.ConNum equals FSCallhd.ShpConNum
> [FSCallhd is in the Data Definition for the report but CustCnt isn't]
>
> I made a BAQ, I can add it to the datasource, but when I add any of the fields
> the report turns blank. So maybe a BAQ is not the way to do this.
>
> How do you add a new table [CustCnt] to a report (add table to RDD?) and how do you link it to an
> existing table [FSCallhd]? Which way should the arrow point? From existing table
> field to the new one or vice versa?
>
> Thanks,
> Plamen Cheshmedjiev
> Systems Administrator
> Art Display Co.
>