Solved

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

Posted on 2003-11-11
10
519 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
10 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
>> 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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:Waxad
Comment Utility
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 100

Expert Comment

by:mlmcc
Comment Utility
0
 

Author Comment

by:Waxad
Comment Utility
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 100

Accepted Solution

by:
mlmcc earned 140 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

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…
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…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now