Solved

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

Posted on 2003-11-11
10
529 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
10 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
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

 
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 140 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

696 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