Print Page | Close Window

Available Report Fields

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3687
Printed Date: 02 May 2024 at 4:25pm


Topic: Available Report Fields
Posted By: chitemerere
Subject: Available Report Fields
Date 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


Replies:
Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: chitemerere
Date 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

Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: chitemerere
Date 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


Print Page | Close Window