Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Not index fields on DB - not visible Post Reply Post New Topic
Author Message
fgoitre
Newbie
Newbie
Avatar

Joined: 04 Sep 2010
Location: Italy
Online Status: Offline
Posts: 17
Quote fgoitre Replybullet Topic: Not index fields on DB - not visible
    Posted: 26 Oct 2010 at 6:15am
Hello
I am using an ODBC connection.
I am using 2 tables from the same connection.
Once I select the tables needed for the report, on the link tab I see only the index fields of each table. All the other fields are not present.
 
I have tryed to use only 1 table for making a test, and also when I want to group, the only selectable field is the index column.
 
Do someone knows if there is an option to make appear the other fields?
 
Thanks and regards,
 
Felipe
 


Edited by fgoitre - 26 Oct 2010 at 6:17am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 27 Oct 2010 at 3:35am
What type of database are you connecting to?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
fgoitre
Newbie
Newbie
Avatar

Joined: 04 Sep 2010
Location: Italy
Online Status: Offline
Posts: 17
Quote fgoitre Replybullet Posted: 27 Oct 2010 at 3:53am
I am using the ODBC connection with a Sequel database
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 27 Oct 2010 at 6:54am

I've never heard of "Sequel" as a database type - is it MS SQL Server, Oracle, or something else?

I suspect that one of two things is going on - either an access rights issue in the database is preventing you from seeing the fields or the ODBC driver for your database needs to be updated.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
fgoitre
Newbie
Newbie
Avatar

Joined: 04 Sep 2010
Location: Italy
Online Status: Offline
Posts: 17
Quote fgoitre Replybullet Posted: 28 Oct 2010 at 6:05am
You are right.
The database I am using MySQL.
The driver version I am using is: 2.575.1132.0 - I am really not sure if it is the last version.
 
IP IP Logged
fgoitre
Newbie
Newbie
Avatar

Joined: 04 Sep 2010
Location: Italy
Online Status: Offline
Posts: 17
Quote fgoitre Replybullet Posted: 18 Nov 2010 at 8:25am
Problem solved
 
The problem was the field type on the SQL database. Cristal Reports recognize the fields as "memo" thats why the fields are not visibile.
Changing the field type to number or string solve the problem.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.015 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.