Solved

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

Posted on 2003-11-11
10
526 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
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
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 100

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 100

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 100

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Title # Comments Views Activity
dynamically populate report text based on command data 7 61
Crystal Reports - group header 2 48
Possibly a grouping issue? 7 28
Summarizing a percent by a grouped category 14 32
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 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