Parameter Showing Incomplete List of Records

[vcarlson]

Disclaimer: I am a novice at Crystal Reports.

I created a report with a date range parameter and a dynamic parameter to choose from multiple employees -- it worked fine.

There was an issue in my SQL statement, so I edited the SQL and uploaded the new version to the report. But now the list of values for the employees is about half what it should be, even though when I run the SQL query in SQL Developer I see all records.

I tried creating a new, blank report with the new SQL query and all employee records show up on the report. But as soon as I try to add a parameter, either dynamic or static, I only get the abbreviated list. I tried to manually add the value of one of the employees that shows on my report, and when I run the report I get no data.

It seems like it is some caching issue.

I have a standalone version of Crystal Reports 2020.

[vcarlson]

Dell, you were right -- it was the row limit in the registry. I have a standalone version of Crystal Reports 2020, and although I changed the keys in the registry that I found in posts online, they didn't change the report. So I searched in the registry under the HKEYCurrentUser and HKEYMachine for anything relating to Crystal Reports and added the LOV keys to the registry. That did the trick. I wish I would have kept track of exactly what I changed so other users would be able to find those specific keys for Crystal 2020. Thank you for your help.

[DellSC]

Are you using a command in your report? Does the data for the dynamic parameter come from the command? If so, please see my blog on working with commands: https://blogs.sap.com/2015/04/01/best-practices-when-using-commands-with-crystal-reports/

If you're not using the command to provide the dynamic prompt, then you may be running into the default record limit that Crystal has for dynamic prompts. There is a registry setting that will get around this for you:

• HKEY_LOCAL_MACHINE\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords

The default value is 1000, but you can increase that to show more records.

-Dell

[vcarlson]

I saw your post earlier and tried some of your recommendations.

I did use a command for the report. When I was having issues with the dynamic parameter, I tried creating a static parameter to troubleshoot the issue, but when I choose to append all values from the database, only the incomplete list populates, even though I see all the records for every employee in the details on my report. How could the report pull the records into the details, but it won't include them in the parameter?

I don't think it is an issue with the registry because the data returned is not huge.

[DellSC]

Perchance, does your query return more than one record per person? The limit from the registry is the total number of records, not the total number of unique values.

Have you tried using a separate table for the prompt values instead of the query?

-Dell