Problem: When I run my Crystal Report in your Viewer, all of my dynamic parameter values do not show up. The Viewer seems to be cutting the list of values short.
Answer: Your query is being limited, because the default fetch amount is being used and/or is set to low. Find (or Add) the registry setting "LOV" and "MaxRowsetRecords": (see bottom of page)
32-bit Location:
HKLM\SOFTWARE\Wow6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
64-bit Location:
HKLM\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
---
Final Steps to Add and/or Set LOV and MaxRowsetRecords:
Step 1: Once you have clicked on DatabaseOptions, check if there is a folder called LOV underneath it. If LOV already exists, click on it and skip to Step 8.
Step 2: If LOV does not exist, you need to create it. Right-click on DatabaseOptions and select New, then select Key.
Step 3: Type LOV and press Enter.
Step 4: Click on the LOV folder. Now look at the right side panel. You need to create a new value here.
Step 5: Right-click in an empty area of the right side panel and select New, then select String Value.
Step 6: Type the name exactly as shown below and press Enter: MaxRowsetRecords
Step 7: Double-click on the new MaxRowsetRecords entry you just created.
Step 8: In the Value data box, type large value like 5000 or 10000.
Step 9: Click OK.
Step 10: Restart Report Runner Viewer and run your report. All values should show now in dynamic parameter choices.
