?
Solved

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

Posted on 2003-11-11
10
Medium Priority
?
538 Views
Last Modified: 2010-05-18
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
0
Comment
Question by:Waxad
  • 4
  • 4
8 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 9722615
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
 

Author Comment

by:Waxad
ID: 9729576
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
 

Author Comment

by:Waxad
ID: 9731455
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
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 
LVL 101

Expert Comment

by:mlmcc
ID: 9736572
>> 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
 

Author Comment

by:Waxad
ID: 9739558
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 9744682
0
 

Author Comment

by:Waxad
ID: 9746450
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
 
LVL 101

Accepted Solution

by:
mlmcc earned 560 total points
ID: 9752256
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question