Workaround for error "...multiple paths leading to..."

Hello!
This question contains to problems.
1: When I try to link my tables I get the error: "The link you added causes a link configuration with multiple paths leading to the same table."
I can´t find any solution to this problem. I´ve tried to revers the links without any luck.

2: I found a workaround for this by using the Crystal SQL Designer where the SQL worked. Then I used the .qry fil to create a subreport. This works like a charm when I´m in Crystal Reports but when I use RDC on a different machine then the development environment to print (not view) the report, nothing happens.

Can someone please enlighten me in one of these two matters?

/Markus
WaxadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
1.  Can you show the basics of the tables and how you have them linked?


2.  Did you rebuild the application to include the .qry drivers or did you just take the report over to the machine and try to run it?

mlmcc
0
WaxadAuthor Commented:
1. I want to link my tables like this:
tableA.field1=tableB.field1
tableA.field2=tableC.field1
tableC.field2=tableD.field1
tableD.field1=tableB.field2

so it´s obviously that multiple paths leads from tableA to table B. But why must this be a bad thing?

2. I´m not sure what you mean with "rebuild" but here´s what I did:
I copied my .rpt and .qry file to the target machine where my application (C++) and craxdrt.dll, crviewer.dll (not used for this particular task) and p2sodbc.dll already exists. Then I ran my application, trying to print the report. If I print to a file I get an empty file.
Do I need some other .dll or something else on the target machine? It seems like that since my report works on my own machine that have CR installed.
0
WaxadAuthor Commented:
By reading the runtime.hlp (smart move =) distributed with CR I got this answer:

If your runtime report is based on a query file (.QRY) created in the Crystal SQL Designer, you must include the following files at runtime:

FILE      LOCATION      DESCRIPTION
P2IXBSE.DLL      \WINDOWS\CRYSTAL      Crystal Query saved data driver
P2LODBC.DLL      \WINDOWS\CRYSTAL      Crystal Query saved data driver
NOTE: You must also include runtime files for the direct access database or ODBC data source format your query file reads.

So now I´ve copied those files to the target machine and since I´m working with a Oracle DB (ODBC) I´ve also copied these files (according to runtime.hlp):

CRBAS14.DLL      \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      MERANT ODBC driver shared library
CRFLT14.DLL      \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      MERANT flat-file ODBC driver shared library
CRUTL14.DLL      \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      MERANT ODBC driver utility DLL
CROR714.DLL      \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      MERANT ODBC Oracle 7 only driver
CROR814.DLL      \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      MERANT ODBC Oracle 8 only driver
QECR.LIC      \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32 (NT only)      MERANT ODBC driver license file

But there was also a note: The Open Client DB-Library must be installed on the system that will access the database.

What does this mean?
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

mlmccCommented:
>> The Open Client DB-Library must be installed on the system that will access the database.

What does this mean?
I suspect the Merant files need t be on the server and probably already are.

>> so it´s obviously that multiple paths leads from tableA to table B. But why must this be a bad thing?

It is not necessarily a bad thing if you know your data and both paths will always lead to the same record.  However what happens if they lead to different records, which tableB entries do I pick.
To solve tis you need to link only once between tables or include a second copy of table B in the query.  You then link as
tableA.field1=tableB1.field1
tableA.field2=tableC.field1
tableC.field2=tableD.field1
tableD.field1=tableB2.field2
Now there is only 1 path but 2 copies.


>> Rebuild
I thought you were including a new report in the application therefore you would have to recompile the application and install it again on the client.  If there were no changes needed to the application then no problem.  I thought you might have changed the database access method therefore the application needed a new reference or dll added.

mlmcc
0
WaxadAuthor Commented:
I´ve come to the conclusion that I´ll have to use a query (.qry file) to get the data I want. Here´s my current situation:

- I have a report (built on a .qry) that works fine on my own machine (CR installed) but not the target machine.
- I´m using CR 8.0 and Oracle Lite.
- I´ve installed several dll:s on the target machine without success (those above + the whole C:\windows\crystal library from my own PC + CROR815.DLL (registered too))
- I´m getting "Invalid TLV record" on the target machine.

It still seems like some dll:s are missing or one of those I have, have to be registered. Or can it be some problem with my ODBC datasource?
0
mlmccCommented:
0
WaxadAuthor Commented:
That was the first list I went through...

Now I ran the Report Distribution Expert. By this I hoped to get all the needed files in one package that could be installed. It worked fine to create and install but the report isn´t complete anyway...

Is there any idea to upgrade to CR 9?
0
mlmccCommented:
Invalid TLV recordhttp://support.crystaldecisions.com/library/kbase/articles/c2008108.asp

http://support.crystaldecisions.com/library/kbase/articles/c2009585.asp

CR9
Yes you can upgrade to CR9.  Contact your distributor or Crystal Decisions.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.