CR 2016 cuts static picklist into multiple parts

[allisonclark]

I have a static picklist of about 400 entries. In CR XI this was fine. Now converting to CR 2016. It chops picklist into 3 parts, and adds an extra dropdown with values of 1, 2, or 3. Selecting 1 gives you items starting with A - E, 2 gives you F - O, and so on. How can I make it display all items in one list?

[abhilash_kumar]

Hi Allison,

The 'MaxRowSetRecords' registry key only increases the total values in the list.

To fix LOVs showing up as batches, you'd have to use the registry key suggested by Dell.

-Abhilash

[allisonclark]

I tried a previous suggestion of setting registry key HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV\string value MaxRowSetRecords = 500. That was specific to Windows 10 64-bit install of Crystal 2016. It made no difference, but behavior in the Crystal SDK is irrelevant anyway. It has to work on the Enterprise server. If Crystal XI could display a static list of 400 values, how can it be that Crystal 2016 cannot?

[DellSC]

There is a registry setting that may help with this.

Starting at

• HKEY_LOCAL_MACHINE\ Software \Wow6432Node\SAP BusinessObjects\Suite XI 4.0\ (on 64 bit OS)
• HKEY_LOCAL_MACHINE\ Software \ SAP BusinessObjects\Suite XI 4.0\ (on 32 bit OS)

go to \Crystal Reports\Reportview\PromptingLOVBatchSize. If the key isn't there, create it - this is case sensitive!. The value is the number of records that you want to show in each batch - in your case it might be 500 to get all of the records.

-Dell