I just created a new RDD for the ARForm yesterday. Since there are subreports you need to be careful when looking at the explorer fields on the main AR form as some of them can only be seen when you open up the subreport and look at its fields
Â
That may explain the issue you are having
________________________________
From: "McMullen, Travis" <tmcmullen@...>
To: vantage@yahoogroups.com
Sent: Friday, May 18, 2012 8:32 AM
Subject: Re: [Vantage] AR Invoice Report Data Definition
I have been updating the current data source in the manner that you
described. My fields are in field explorer.
I'm going to try to add the field I need through the linked field one more
time today and follow all of the recommendations I have received here.
Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VAÂ 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...
On Thu, May 17, 2012 at 5:19 PM, Karen Schoenung <
kschoenung@...> wrote:
------------------------------------
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/.%c2%a0
(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]
Â
That may explain the issue you are having
________________________________
From: "McMullen, Travis" <tmcmullen@...>
To: vantage@yahoogroups.com
Sent: Friday, May 18, 2012 8:32 AM
Subject: Re: [Vantage] AR Invoice Report Data Definition
I have been updating the current data source in the manner that you
described. My fields are in field explorer.
I'm going to try to add the field I need through the linked field one more
time today and follow all of the recommendations I have received here.
Travis L. McMullen
ERP Specialist
ComSonics, Inc.
Harrisonburg, VAÂ 22801
Phone: 540-434-5965 x1274
Toll Free: 1-800-336-9681 x1274
Mobile: 540-435-1920
Fax: 540-434-9847
E-Mail: tmcmullen@...
On Thu, May 17, 2012 at 5:19 PM, Karen Schoenung <
kschoenung@...> wrote:
> **[Non-text portions of this message have been removed]
>
>
> and updating the Current Data Source?
> Do you see your tables/fields in the FIELD Explorer? If not, you need to
> also go into where you set the datasource and update the "current
> connection" - two windows, upper has your xml properties path and lower has
> current connections - I think you need the lower highlighted to update the
> upper (for example Report results)
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of McMullen, Travis
> Sent: Thursday, May 17, 2012 3:33 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] AR Invoice Report Data Definition
>
> Yes, I am going to Datasource location and bringing in the new XML.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
> On Thu, May 17, 2012 at 4:24 PM, Ted Koch <tkoch77@...> wrote:
>
> > **
>
> >
> >
> > How are you bringing the newly generated XML into your report in the
> > designer? Set Datasource Location and updating the Current Data Source
> > with the correct XML? Maybe double check that.
> >
> > ________________________________
> > From: "McMullen, Travis" <tmcmullen@...>
> > To: vantage@yahoogroups.com
> > Sent: Thursday, May 17, 2012 4:00 PM
> > Subject: Re: [Vantage] AR Invoice Report Data Definition
> >
> >
> > Karen: The fields I am selecting are appearing in the XML when I
> > bring it in to Crystal Reports, however, when I right click and Browse
> > data or add them to the form, there is no data.
> >
> > Vic: I did add the relationship in the RDD, and I think that I added
> > it Database Expert, I'll have to retrace my steps to be certain. I
> > also tried the linked tables approach that you mentioned and got the
> > exact same results, no data...
> >
> > Travis L. McMullen
> > ERP Specialist
> > ComSonics, Inc.
> > Harrisonburg, VA 22801
> > Phone: 540-434-5965 x1274
> > Toll Free: 1-800-336-9681 x1274
> > Mobile: 540-435-1920
> > Fax: 540-434-9847
> > E-Mail: tmcmullen@...
> >
> > On Thu, May 17, 2012 at 2:40 PM, Vic Drecchio
> > <vic.drecchio@...>wrote:
> >
> > > **
> >
> > >
> > >
> > > You didn't say, so I have to ask: You did also create a
> > > Relationship, correct? And you'll need to repeat the relationship in
> > > CR in Database Expert.
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > > Behalf Of subzerovi
> > > Sent: Thursday, May 17, 2012 2:11 PM
> > > To: vantage@yahoogroups.com
> > >
> > > Subject: [Vantage] AR Invoice Report Data Definition
> > >
> > > Has anyone out there succuessfully made a copy of the AR Invoice
> > > report data definition and added a table to the new definition?
> > >
> > > I have a copy and have added fields to the existing tables without
> issue.
> > > However, I need to add the tracking number to my invoices and I
> > > cannot
> > get
> > > the information to come over into Crystal Reports.
> > >
> > > In Vantage 8.03, I had to use an ODBC connection in Crystal to get
> > > this information. I'm having issues with ODBC, so I'm trying the RDD
> > > way and
> > not
> > > having muc luck.
> > >
> > > Any help is appreciated.
> > >
> > > No virus found in this message.
> > > Checked by AVG - www.avg.com
> > > Version: 2012.0.2176 / Virus Database: 2425/5005 - Release Date:
> > > 05/17/12
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> >
> > 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/.
> > (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]
>
> ------------------------------------
>
> 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/.
> (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
>
>Â
>
------------------------------------
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/.%c2%a0
(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]