Community
Showing results for 
Search instead for 
Do you mean 
Reply

Addon TopLine Designer- compatible with CRep11 ??

Accepted Solution Solved
Copper Contributor
Posts: 56
Country: Netherlands
Accepted Solution

Addon TopLine Designer- compatible with CRep11 ??

I have TopLineDesigner standard Addon and made extra Tab Prodin where products 1,2,3, are stored These products

made by contact Johnson. etc etc.

I can see the product for each contact browsing the contacts, and In CrystalReports11

I can see via OleDB the (Topline)database "prodin" with the required fields

Once I put them in CR details I get error report relating to prodin.

I have In CR11 three databases in this case:

Contacts---Contacts.Prodin(two ID fields) ....Prodin  itself with the required fields.

Links via corresponding IDs

If I place a field of Prodin in Page header or Detail section I get these errors

The links Contacts and Contact.Prodin are having same ID numbers,but

the ProdinID (one) to Prodin(Many) of the Prodin database is the problem.

Cannot check that,because as soon as put into Cr11 I get error.

Any ideas ??

 

William

 

 


Accepted Solutions
Solution
Accepted by topic author Wim Rippen
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 56
Country: Netherlands

Re: Addon TopLine Designer- compatible with CRep11 - USD 100 reward!!

[ Edited ]

I am familiar with Crystal Reports and I have of course the CONTACT say name Johnson in the PAGEHEADER and in the details

I put the PRODIN (Products) fields.

 

The Problem is in the LINKS like ContactID and what kind of link to Prodin details.

 

Again: My issue is : Johson is make Tomatoes,Apples.Pears etc etc.

 

Please read and try to understand my initial message.

 

So it it the ONE to MANY link which is the problem.

I see and can make a details-report with the "Tomatoes,Apples,Pears"and I DO SEE them in the report,however ,as soon as I add

via the Datyabase Expert the CONTACTS and put CONTACT in the Pageheader then I don;t see nothing anymore... no details/ no Johson name..

 

I did ContactID,and linked one to many to ProdIn ID.

 

Hopefull somebody can help me,I am willing to pay USD100 by Paypal, and via Logmein remote controle during Amsterdam/Europe timezone

hours.

 

Thanks !

Message Edited by Wim Rippen on 10-09-2009 11:39 PM

View solution in original post


All Replies
Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Addon TopLine Designer- compatible with CRep11 ??

Wouldn't you have to place the fields/data from the Prodin table in a sub-report in Crystal, being that Contact would likely be your main table and since the data is in two related tables, and not the same?
Solution
Accepted by topic author Wim Rippen
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 56
Country: Netherlands

Re: Addon TopLine Designer- compatible with CRep11 - USD 100 reward!!

[ Edited ]

I am familiar with Crystal Reports and I have of course the CONTACT say name Johnson in the PAGEHEADER and in the details

I put the PRODIN (Products) fields.

 

The Problem is in the LINKS like ContactID and what kind of link to Prodin details.

 

Again: My issue is : Johson is make Tomatoes,Apples.Pears etc etc.

 

Please read and try to understand my initial message.

 

So it it the ONE to MANY link which is the problem.

I see and can make a details-report with the "Tomatoes,Apples,Pears"and I DO SEE them in the report,however ,as soon as I add

via the Datyabase Expert the CONTACTS and put CONTACT in the Pageheader then I don;t see nothing anymore... no details/ no Johson name..

 

I did ContactID,and linked one to many to ProdIn ID.

 

Hopefull somebody can help me,I am willing to pay USD100 by Paypal, and via Logmein remote controle during Amsterdam/Europe timezone

hours.

 

Thanks !

Message Edited by Wim Rippen on 10-09-2009 11:39 PM