Dynamic Parameter- Crystal Reports 2011

[Former Member]

Please Help I have an issue and wondered if someone could  help me with it.  I created a dynamic parameter for  Patient’s Last and the issue is that all the name values does not display it stops at page#5 and there are over 1,000 patients in our EMR.  Do you know how to extend the limit so that all the batches of patient’s name will display ?

[abhilash_kumar · Accepted solution]

Hi Chianne,

The default number of values in a list is limited to 1000 records.

This is however,  controlled by a registry key. To increase this limit, here's what you need to do:

(I'm assuming this a 64-bit machine)

Go to Start > Run > Type 'regedit' (without quotes)

Browse to:

HKEY_CURRENT_USER\Software\Wow6432Node\Business Objects\Suite XI 4.0\Crystal  Reports\DatabaseOptions

Create a new key (or folder) called 'LOV' and then on the right-hand side create a new string value called 'MaxRowsetRecords' with a value higher than 1000, perhaps around 20000.

Do this on the HKEY_LOCAL _MACHINE hive as well.

Let me how this goes!

-Abhilash

[Former Member · Accepted solution]

Thank you Abhilash, once I add this information locally would it carry over to the server-side as well? 

[abhilash_kumar · Accepted solution]

No it won't!

You'd need add the same registry key on the BI Server too.

-Abhilash