Error in crystal when Adding table to AR invoice

Yahoo Archive
1
Only way I could get this to work was rebuilding the report from the base arform report style.

--- On Wed, 8/1/12, b_ordway <cooner_55421@...> wrote:

From: b_ordway <cooner_55421@...>
Subject: [Vantage] Re: Error in crystal when Adding table to AR invoice
To: vantage@yahoogroups.com
Date: Wednesday, August 1, 2012, 7:20 PM
















Â









I've run into this before in Crystal.

Often I just end up adding a subreport to handle the values from new table.



I don't remember finding the cause.

I have wondered if maybe it was existing calculations in the RDD that were already using Part table fields.



--- In vantage@yahoogroups.com, Tony Hughes <thughes281@...> wrote:

>

> I added the Part table to a copy of the AR invoice report data def.

> I needed the ECCN number field and HTS number field, they export out to the xml just fine - I can see them in the file.

>

> I open the report in Crystal, and set the new xml file as its source. Then I set the links - At first, I used inner join from invcdtl.company and invcdtl.partnum.

>

> Then I put the ECCn and HTS fields on the report. When I preview the report, I get these 2 messages in Crystal:

>

> First the generic "Failed to retrieve data from the database"

>

> Next "Database Connector Error: 'If tables are already linked then the join type cannot change'"

>

> I looked at the invcdtl tables existing joins - they're all left outer joins. So I change the Invcdtl - Part joins to be left outer as well, but same result.

>

> I redid the whole thing, making the Invcdtl-Part joins to be left outer to start with, but same results.

>

>

> Any ideas?

>

> Thank you,

> Anthony Hughes

>



























[Non-text portions of this message have been removed]
2
I added the Part table to a copy of the AR invoice report data def.
I needed the ECCN number field and HTS number field, they export out to the xml just fine - I can see them in the file.

I open the report in Crystal, and set the new xml file as its source. Then I set the links - At first, I used inner join from invcdtl.company and invcdtl.partnum.

Then I put the ECCn and HTS fields on the report. When I preview the report, I get these 2 messages in Crystal:

First the generic "Failed to retrieve data from the database"

Next "Database Connector Error: 'If tables are already linked then the join type cannot change'"

I looked at the invcdtl tables existing joins - they're all left outer joins. So I change the Invcdtl - Part joins to be left outer as well, but same result.

I redid the whole thing, making the Invcdtl-Part joins to be left outer to start with, but same results.


Any ideas?

Thank you,
Anthony Hughes
3
I've run into this before in Crystal.
Often I just end up adding a subreport to handle the values from new table.

I don't remember finding the cause.
I have wondered if maybe it was existing calculations in the RDD that were already using Part table fields.

--- In vantage@yahoogroups.com, Tony Hughes <thughes281@...> wrote:
>
> I added the Part table to a copy of the AR invoice report data def.
> I needed the ECCN number field and HTS number field, they export out to the xml just fine - I can see them in the file.
>
> I open the report in Crystal, and set the new xml file as its source. Then I set the links - At first, I used inner join from invcdtl.company and invcdtl.partnum.
>
> Then I put the ECCn and HTS fields on the report. When I preview the report, I get these 2 messages in Crystal:
>
> First the generic "Failed to retrieve data from the database"
>
> Next "Database Connector Error: 'If tables are already linked then the join type cannot change'"
>
> I looked at the invcdtl tables existing joins - they're all left outer joins. So I change the Invcdtl - Part joins to be left outer as well, but same result.
>
> I redid the whole thing, making the Invcdtl-Part joins to be left outer to start with, but same results.
>
>
> Any ideas?
>
> Thank you,
> Anthony Hughes
>
4
Or, does your RDD relationship need to be the same join in Crystal?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
Sent: Wednesday, August 01, 2012 2:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Error in crystal when Adding table to AR invoice



I've run into this before in Crystal.
Often I just end up adding a subreport to handle the values from new table.

I don't remember finding the cause.
I have wondered if maybe it was existing calculations in the RDD that were already using Part table fields.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Tony Hughes <thughes281@...<mailto:thughes281@...>> wrote:
>
> I added the Part table to a copy of the AR invoice report data def.
> I needed the ECCN number field and HTS number field, they export out to the xml just fine - I can see them in the file.
>
> I open the report in Crystal, and set the new xml file as its source. Then I set the links - At first, I used inner join from invcdtl.company and invcdtl.partnum.
>
> Then I put the ECCn and HTS fields on the report. When I preview the report, I get these 2 messages in Crystal:
>
> First the generic "Failed to retrieve data from the database"
>
> Next "Database Connector Error: 'If tables are already linked then the join type cannot change'"
>
> I looked at the invcdtl tables existing joins - they're all left outer joins. So I change the Invcdtl - Part joins to be left outer as well, but same result.
>
> I redid the whole thing, making the Invcdtl-Part joins to be left outer to start with, but same results.
>
>
> Any ideas?
>
> Thank you,
> Anthony Hughes
>



[Non-text portions of this message have been removed]
5
> Or, does your RDD relationship need to be the same join in Crystal?
In my case I always try to make the joins in Crystal match any relationships in the RDD. Even so there are times the report just bombs when I put the new table in the main report.
As far as I know, the guts of the RDDs aren't exposed to users & that's why I end up wondering if there are table relationships buried in some of those.

--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> Or, does your RDD relationship need to be the same join in Crystal?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of b_ordway
> Sent: Wednesday, August 01, 2012 2:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Error in crystal when Adding table to AR invoice
>
>
>
> I've run into this before in Crystal.
> Often I just end up adding a subreport to handle the values from new table.
>
> I don't remember finding the cause.
> I have wondered if maybe it was existing calculations in the RDD that were already using Part table fields.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Tony Hughes <thughes281@<mailto:thughes281@>> wrote:
> >
> > I added the Part table to a copy of the AR invoice report data def.
> > I needed the ECCN number field and HTS number field, they export out to the xml just fine - I can see them in the file.
> >
> > I open the report in Crystal, and set the new xml file as its source. Then I set the links - At first, I used inner join from invcdtl.company and invcdtl.partnum.
> >
> > Then I put the ECCn and HTS fields on the report. When I preview the report, I get these 2 messages in Crystal:
> >
> > First the generic "Failed to retrieve data from the database"
> >
> > Next "Database Connector Error: 'If tables are already linked then the join type cannot change'"
> >
> > I looked at the invcdtl tables existing joins - they're all left outer joins. So I change the Invcdtl - Part joins to be left outer as well, but same result.
> >
> > I redid the whole thing, making the Invcdtl-Part joins to be left outer to start with, but same results.
> >
> >
> > Any ideas?
> >
> > Thank you,
> > Anthony Hughes
> >
>
>
>
> [Non-text portions of this message have been removed]
>
6
Open a clean copy of the report. Clear out your old/disconnected
datasources. Then point it to the new XML and add the new table. Make sure
to add the table from the SAME datasource as the rest of the report. After
this, you can create your links.

Make sure to create you links manually, don't tell Crystal to do it
automatically lest it fubar things for you. It's probably going to make
some links to your new table automatically anyway, just delete these and
replace them with what you want. At this point you should be good to go.

FWIW, joins do not need to be configured the same way in Crystal and the
RDD. Normally you're going to want to, just because it's the only way the
data really makes sense --but you don't HAVE to. Crystal just gets a list
of the tables and records from the XML. You can tell it to organize them
anyway that floats your boat. You can also declare your
joins independently inside each sub-report.


*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Wed, Aug 1, 2012 at 6:59 PM, b_ordway <cooner_55421@...> wrote:

> **
>
>
> > Or, does your RDD relationship need to be the same join in Crystal?
> In my case I always try to make the joins in Crystal match any
> relationships in the RDD. Even so there are times the report just bombs
> when I put the new table in the main report.
> As far as I know, the guts of the RDDs aren't exposed to users & that's
> why I end up wondering if there are table relationships buried in some of
> those.
>
>
> --- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
> >
> > Or, does your RDD relationship need to be the same join in Crystal?
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of b_ordway
> > Sent: Wednesday, August 01, 2012 2:21 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Error in crystal when Adding table to AR invoice
> >
> >
> >
> > I've run into this before in Crystal.
> > Often I just end up adding a subreport to handle the values from new
> table.
> >
> > I don't remember finding the cause.
> > I have wondered if maybe it was existing calculations in the RDD that
> were already using Part table fields.
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Tony
> Hughes <thughes281@<mailto:thughes281@>> wrote:
> > >
> > > I added the Part table to a copy of the AR invoice report data def.
> > > I needed the ECCN number field and HTS number field, they export out
> to the xml just fine - I can see them in the file.
> > >
> > > I open the report in Crystal, and set the new xml file as its source.
> Then I set the links - At first, I used inner join from invcdtl.company and
> invcdtl.partnum.
> > >
> > > Then I put the ECCn and HTS fields on the report. When I preview the
> report, I get these 2 messages in Crystal:
> > >
> > > First the generic "Failed to retrieve data from the database"
> > >
> > > Next "Database Connector Error: 'If tables are already linked then the
> join type cannot change'"
> > >
> > > I looked at the invcdtl tables existing joins - they're all left outer
> joins. So I change the Invcdtl - Part joins to be left outer as well, but
> same result.
> > >
> > > I redid the whole thing, making the Invcdtl-Part joins to be left
> outer to start with, but same results.
> > >
> > >
> > > Any ideas?
> > >
> > > Thank you,
> > > Anthony Hughes
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
7
I removed the old datasources, and redid from scratch and this works.
We've made other changes to base arform so I have to rebuild that before I can test completely. But on initial test, it did seem to link Part correctly, and pull in the part eccn and hts numbers correctly.

Thanks for your help!

--- On Thu, 8/2/12, John Driggers <waffqle@...> wrote:

> From: John Driggers <waffqle@...>
> Subject: Re: [Vantage] Re: Error in crystal when Adding table to AR invoice
> To: vantage@yahoogroups.com
> Date: Thursday, August 2, 2012, 3:48 AM
> Open a clean copy of the report.
> Clear out your old/disconnected
> datasources. Then point it to the new XML and add the new
> table. Make sure
> to add the table from the SAME datasource as the rest of the
> report. After
> this, you can create your links.
>
> Make sure to create you links manually, don't tell Crystal
> to do it
> automatically lest it fubar things for you. It's probably
> going to make
> some links to your new table automatically anyway, just
> delete these and
> replace them with what you want. At this point you should be
> good to go.
>
> FWIW, joins do not need to be configured the same way in
> Crystal and the
> RDD. Normally you're going to want to, just because it's the
> only way the
> data really makes sense --but you don't HAVE to. Crystal
> just gets a list
> of the tables and records from the XML. You can tell it to
> organize them
> anyway that floats your boat. You can also declare your
> joins independently inside each sub-report.
>
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>
>
> *
>
> *
>
>
>
> On Wed, Aug 1, 2012 at 6:59 PM, b_ordway <cooner_55421@...>
> wrote:
>
> > **
> >
> >
> > > Or, does your RDD relationship need to be the same
> join in Crystal?
> > In my case I always try to make the joins in Crystal
> match any
> > relationships in the RDD. Even so there are times the
> report just bombs
> > when I put the new table in the main report.
> > As far as I know, the guts of the RDDs aren't exposed
> to users & that's
> > why I end up wondering if there are table relationships
> buried in some of
> > those.
> >
> >
> > --- In vantage@yahoogroups.com,
> Karen Schoenung <kschoenung@...> wrote:
> > >
> > > Or, does your RDD relationship need to be the same
> join in Crystal?
> > >
> > > From: vantage@yahoogroups.com
> [mailto:vantage@yahoogroups.com]
> On
> > Behalf Of b_ordway
> > > Sent: Wednesday, August 01, 2012 2:21 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Error in crystal when
> Adding table to AR invoice
> > >
> > >
> > >
> > > I've run into this before in Crystal.
> > > Often I just end up adding a subreport to handle
> the values from new
> > table.
> > >
> > > I don't remember finding the cause.
> > > I have wondered if maybe it was existing
> calculations in the RDD that
> > were already using Part table fields.
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> Tony
> > Hughes <thughes281@<mailto:thughes281@>>
> wrote:
> > > >
> > > > I added the Part table to a copy of the AR
> invoice report data def.
> > > > I needed the ECCN number field and HTS number
> field, they export out
> > to the xml just fine - I can see them in the file.
> > > >
> > > > I open the report in Crystal, and set the new
> xml file as its source.
> > Then I set the links - At first, I used inner join from
> invcdtl.company and
> > invcdtl.partnum.
> > > >
> > > > Then I put the ECCn and HTS fields on the
> report. When I preview the
> > report, I get these 2 messages in Crystal:
> > > >
> > > > First the generic "Failed to retrieve data
> from the database"
> > > >
> > > > Next "Database Connector Error: 'If tables
> are already linked then the
> > join type cannot change'"
> > > >
> > > > I looked at the invcdtl tables existing joins
> - they're all left outer
> > joins. So I change the Invcdtl - Part joins to be left
> outer as well, but
> > same result.
> > > >
> > > > I redid the whole thing, making the
> Invcdtl-Part joins to be left
> > outer to start with, but same results.
> > > >
> > > >
> > > > Any ideas?
> > > >
> > > > Thank you,
> > > > Anthony Hughes
> > > >
> > >
> > >
> > >
> > > [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/.%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
>
>
> Â Â vantage-fullfeatured@yahoogroups.com
>
>