Business View Manager and Dyanamic Prompts

[tip4you]

I have created several dynamic prompts for use within the business view manager (v11) for use with my reports (CR Xi). The problem is the prompts are being limited to the first 1000 records. Does anyone know how to increase the number of records returned?

 

[tip4you]

I have found the solution to my own problem and am passing it on. There needs to be two (2) registry keys added. These keys must be run on the client machine running the Crystal Xi IDE and on the server running the Business Objects Enterprise. The keys are as follows (both are currently set to 2000 records, modify as needed):

[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV]
"MaxRowsetRecords"=dword:000007d0


[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV]
"MaxRowsetRecords"=dword:000007d0