Dynamic Parameter with large List of Values doesn't work in SQL Server

[reporting]

One of our clients upgraded their software. We used to export the data from a Pervasive data format into Access and run their reports (CR XI) from the Access data extraction.

I had to use a Dynamic Parameter and the particular field had a huge choice of values. I found the CR article on creating the "LOV" registry key and adding MaxRowsetRecords. Using a value of 5000 in MaxRowsetRecords returned all the records to choose from (SAP KBase Article 1218588 - How to increase the number of values in a dynamic parameter list?)

After the upgrade, their database is now SQL Server 2008. The table & field structure changed significantly and I have been redoing the report for SQL Server (converting and mapping fields didn't work...).

When I add in the Dynamic Parameter described above, all I get is an empty parameter box with "Selected Values" at the top and two buttons: "Remove" and "Remove All" at the bottom. Ie CR is showing me the right hand box with no "Available Values" list on the left!

Any ideas on how to get this working properly?

Thanks very much,

John

John Marrett
Crystal Reports Trainer & Consultant
Maximizer CRM Trainer & Consultant

http://www.e-reporting.ca