Print Page | Close Window

Select expert

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19568
Printed Date: 16 May 2024 at 8:51pm


Topic: Select expert
Posted By: crystal9999
Subject: Select expert
Date Posted: 23 May 2013 at 8:14am
Hi,
I am a new Crystal User and working in crystal 11.
In my select expert I want to make a choice selection but I do not see full list in only goes to G.
Is there a limit? can I extend this limit so I can select my options?
Thank you,


Replies:
Posted By: hilfy
Date Posted: 23 May 2013 at 12:25pm
To extend the limit, there is a registry setting that needs to be tweaked.  Increase the value of HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords or set it to -1 to get all records (not always a good idea, if there can be millions of rows....)
 
-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: crystal9999
Date Posted: 24 May 2013 at 3:26am
Hi Thank you for your response,
I had some help from co-worker and this is what he did to assist:
 

I looked for the value in the registry and it didn’t exist. I created the folder and value and when I tested -1 it gave me the same results. I set "MaxRowsetRecords"="15000" and the I was able to see the full list.

 

I created registry file using notepad for those who aren’t sure how to add values to registry. Save file and rename from .txt to .reg

 

REGEDIT4

 

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV]

"MaxRowsetRecords"="15000"


Print Page | Close Window