Solved

Not All Fields in Same Index Expression

Posted on 2002-04-23
9
1,222 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
  • 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 100

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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

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 100

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 100

Accepted Solution

by:
mlmcc earned 150 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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. …
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

911 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

21 Experts available now in Live!

Get 1:1 Help Now