?
Solved

Not All Fields in Same Index Expression

Posted on 2002-04-23
9
Medium Priority
?
1,318 Views
Last Modified: 2007-11-27
I need help with SCR 8.0 which is connected to an Access 2000 database.  I have two table in the Crystal report, "tblMonthlyServiceAnalysis and "tbl2002RVUsw/Mod".  There are two fields (both Text) that I want to use to connect the table.  The first field is called "CPT" and the second is "MOD".  Both fields are present on both tables and spelled the same way.  CPT is 5 characters long and Indexed on a "Yes no Duplicates" Index on both tables.  MOD is 255 characters long and Indexed again on both tables as "Yes No Duplicates".

When I used the Crystal report Expert it will automatically link up CPT to CPT.  -- tblMonthlyService Analysis is on the left and tbl2002RVUsw/Mod on the right.  Now when I try to join MOD from tblMonthlyService to MOD on tbl2002RVUsw/Mod I get the message "Invalid File Link.  Not All Fields on Same Index Expression"

Any ideas what this means?  And how I can get MOD to link to MOD on this report?

Help.  --Mike
0
Comment
Question by:Geekisme
[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
9 Comments
 
LVL 6

Expert Comment

by:dbirdman
ID: 6964027
According to Crystal, you cannot have more than one link when the data sources are from different data sources.  See the following:

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

The above link also references a Technical Brief that may give further information.

Hope this helps.
0
 

Author Comment

by:Geekisme
ID: 6964062
Actually, I found that article, but my two tables are out of the same Access 2000 database.  So there must be another reason why I get that message.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 6964359
What happens if you delete the CPT link and try to link only on the MOD field?

CR may not be able to link on fields as large as 255 characters.

mlmcc
0
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.

 

Author Comment

by:Geekisme
ID: 6966292
mImcc,

A good question.  

If I delete the CPT link and try to link MOD, the MOD will link.  But if I then try and add CPT I will get the same message.  

I don't understand what the error message is saying.  As I said before, the tables are from the same Access 2000 database, same names for fields, same data type, same indexes, and same character length.  

In the past I have only linked tables with one field, this is the first time I have tried using two and I don't know why it isn't working.

--Mike
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 6967066
I usually use views, queries, and stored procedures in the database as the basis for my Crystal Reports.

I had anticipated the link with MOD wouldn't work by itself but that didn't pan out.

Since both fields are indexed with no duplicates you will have a unique link regardless of direction of the linking.  

Can you try to create the query in Access?

I'll play with it a little at work tomorrow and see if i get similar results.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 6967091
I created two tables named just like yours in Access97 with just the two fields CPRT and MOD.  I was able to create joins in Access on both fields.

I don't have a recent version of CR loaded here so I can't check it until tomorrow at work.

Just noticed your table name contains a special character.  

tbl2002RVUsw/Mod

CR may not like the slash.  Chnage it to an underscore and see if the join works.

Do the tables have primary keys?  If not that also may be causing a problem.

good luck
mlmcc
0
 

Author Comment

by:Geekisme
ID: 6967150
Ah #^%$!  I just realized that when I asked the question, I posted some incorrect info!  Sorry!  Both MOD and CPT are indexed as "Duplicates Okay".

I should be able to do MOD and CPT as a joint primary key ("No Duplicates") on tbl2002RVUsw/Mod (and take out the "/").  I will try it that way.  I can not do MOD and CPT as primary keys on tblMonthlyService however.

I will try doing the above and see what Crystal thinks on a new, clean Crystal report.  If that doesn't work, I will try the query in Access and then see if Crystal will take it.

0
 
LVL 101

Accepted Solution

by:
mlmcc earned 600 total points
ID: 6967446
It will probably work from CR now.

mlmcc
0
 

Author Comment

by:Geekisme
ID: 6968761
Yes it did!  When I make a joint primary key out of MOD and CPT in tbl2002RVUswMod, Crystal will let me link two fields between two tables!  Kudos to mImcc!

--Mike
0

Featured Post

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.

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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

801 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