SUCCESS!!! Thank you.
--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> BTW... I just tested this.
> I found I did have to add a relationship in the RDD before it would work.
>
> I linked it to the Company table, not APDtls, and only the key field Company
> No other relationship fields.
>
> Then in Crystal I added the Vendor table & linked it to the APDtls table (Company, CalcVendorID)
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > Looks like both tables in this report are calculated.
> > I've had trouble with these types of RDDs too.
> >
> > I have had some luck adding tables and not putting in any relationship - then setting the links in Crystal.
> >
> > --- In vantage@yahoogroups.com, "pluedke1107" <pluedke@> wrote:
> > >
> > > I do not see it. I only see the original table.
> > >
> > > --- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@> wrote:
> > > >
> > > > Do you see the table/fields in your XML?
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pluedke1107
> > > > Sent: Wednesday, October 26, 2011 8:43 AM
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Re: Adding a table to a Crystal Report
> > > >
> > > >
> > > >
> > > > Thanks for the help - I had done all these things but do not see the table I added when using the database expert. I am sure I am connecting to the correct XML. I am guessing I am doing something wrong on the Epicor side. The table APdtls looks like it is all calculated fields. Could that be affecting the outcome? All I need to do is pluck a couple fields from the vendor table and put them on the report. When I set up the relationship details I am not selecting a key field - is this necessary?
> > > >
> > > > Pat
> > > >
> > > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ted Koch <tkoch77@> wrote:
> > > > >
> > > > > After setting the datasource, go to Database -> Database Expert. A ReportDataSet folder should be expanded with the current datasource you brought in and that new table Vendor should be there, add it to the right pane. You will then have to create the linkage under the links tab.
> > > > >
> > > > >
> > > > >
> > > > > ________________________________
> > > > > From: pluedke1107 <pluedke@>
> > > > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > > > Sent: Tuesday, October 25, 2011 4:36 PM
> > > > > Subject: [Vantage] Adding a table to a Crystal Report
> > > > >
> > > > > I am attempting to add a table to the A/P aging report. I have created a copy of the report using report data definitions. I added the vendor table, then created relationship details using APdtls as the parent and Vendor as the child. I then created relationship fields using Calc_VendorID from APDtls as the parent field and VendorID from Vendor as the child field. I added this to the report stylesand ran the AP Aging.
> > > > > I went to Crystal and created a duplicate APaging report, then went to set the datasource and found the correct XML. However, I cannot find the table I added to the report. I am sure I am missing a step somewhere ut am not sure what it is. This is the first modification I have had to make by adding a table. Can anyone point me in the correct direction?
> > > > >
> > > > > Thanks- Pat
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> > > > > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
> > > > > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > > > > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>