Print Page | Close Window

incomplete table

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=1192
Printed Date: 03 May 2025 at 1:58pm


Topic: incomplete table
Posted By: ssweeney
Subject: incomplete table
Date Posted: 17 Aug 2007 at 8:56am
Can someone explain to me why when i browse a field in a table i do not see all the data that is in the table in the sql server?
 
Example i have student id's.  I only see a handful in the crystal report when i browse.  I only used one table to keep it simple in case i was doing a linking incorrect.
 
Suggestions?
 
Shawn


Replies:
Posted By: hilfy
Date Posted: 17 Aug 2007 at 2:18pm
There is a limit on how many records are brought through when you browse data or use the drop-down in the Select Expert.  I think the limit is 256 records and then it only displays the unique values from that 256.  However, there is a registry setting that you can use to increase the record count.
 
Go to this link: http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2006602&sliceId=&dialogID=6078949&stateId=1%200%206076996 - http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do?cmd=displayKC&docType=kc&externalId=c2006602&sliceId=&dialogID=6078949&stateId=1%200%206076996  for information about which key to set based on the version of Crystal that you're running.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window