Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: removing Index ?? Post Reply Post New Topic
Author Message
Getch
Groupie
Groupie


Joined: 26 Dec 2008
Online Status: Offline
Posts: 47
Quote Getch Replybullet Topic: removing Index ??
     Posted: 08 Apr 2010 at 6:21am
Sorry if this is a simple one but I cant seem to find it.
 
I have an access DB I added to a crystal. This db is Mutual Fund performance numbers.
 
I attempted to run the report and I get an Invalid Index error. The cusip field in that access db is noted as an indexed field.
 
I need the link but not indexed. How do I clear that index???
 
I tried to delete the link then re link but after I deleted the link...the index is still there...
 
 
Newbie reports
IP IP Logged
Getch
Groupie
Groupie


Joined: 26 Dec 2008
Online Status: Offline
Posts: 47
Quote Getch Replybullet Posted: 09 Apr 2010 at 7:23am
Anyone?
 
I think this is the only thing keeping my report from running.
 
The field is showing as indexed even though the DB is no longer linked to the other table.
 
All I need to do is clear that index, but I cant seem to find out how to do that.


Edited by Getch - 09 Apr 2010 at 7:23am
Newbie reports
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 09 Apr 2010 at 8:27am
Wish I had an answer, but have never seen an error like that.  It might be possible to created a new data source (different name) and see if that clears up the issue.  If it does, try switching back to the first data source.  I have gotten rid of some weird errors that way.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 12 Apr 2010 at 8:29am

Have you tried Verifying the database?  That should take care of removing any indexes that don't actually exist.

-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.