Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: Available Report Fields Post Reply Post New Topic
Author Message
chitemerere
Newbie
Newbie
Avatar

Joined: 04 Jul 2008
Location: Zimbabwe
Online Status: Offline
Posts: 29
Quote chitemerere Replybullet Topic: Available Report Fields
    Posted: 13 Jul 2008 at 5:19am
I am creating crystal reports using an sql connection.  On the diplay fields section, all my columns from my chosen data table appear.  However, when I go to the record selection Report fields, one of the columns is not available in the available report fields section of the wizard.  What could be problem and what is the solution to it?
 
Many thanks and kind regards.
Chris
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 14 Jul 2008 at 1:14pm
What type of field is not showing up?
 
Crystal won't let you use some specific field types in select criteria.  This  includes blobs and clobs (long text fields).
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
chitemerere
Newbie
Newbie
Avatar

Joined: 04 Jul 2008
Location: Zimbabwe
Online Status: Offline
Posts: 29
Quote chitemerere Replybullet Posted: 15 Jul 2008 at 2:53am
Dear Dell
 
Many thanks for your response.
 
The field contains long text data.  Surprisingly, the same long text field can easily be used in Crystal Reports 10 as select criteria!
 
Is this because of the limited version of the bundled Crystal Basic for Visual Studio?
 
many thaks and kind regards.
Chris
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 15 Jul 2008 at 7:57am
Yes, that is part of the issue.  However, you can get around it by building your report design in the full version of Crystal 10 and then adding it to your project so that it can be used inside VS.
 
-Dell 
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
chitemerere
Newbie
Newbie
Avatar

Joined: 04 Jul 2008
Location: Zimbabwe
Online Status: Offline
Posts: 29
Quote chitemerere Replybullet Posted: 15 Jul 2008 at 12:54pm
Thanks for the response.
 
I managed to see where the problem was.  The Data Type for the report field which could not be selected as a report filter select field was set to varchar(max) in the sql database.  When this was changed to varchar(50), the field was available for report filtering.
 
I realized that I had the same problem with Crystal Reports 10 when I had already written to you.  I created old reports with the data type set to varchar(50) long back which I later changed to varchar(max) and had not created new reports for this data table until today.
 
Many thanks for your help and effort.
Chris
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.016 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.