Many of the reports we use have dynamic parameters. When the report is run these parameters are dropdowns on the Crystal parameter page. Because we are using Crystal Reports 2008 the dropdowns are paginated in order to show more options than will fit in a single dropdown list. The problem is that the dropdown lists are still missing values. I have not been able to figure out a pattern for the ones that are missing though the same values are consistently missing. There are several parameters that are exhibiting the same behavior.

 

I know that in previous versions of Crystal there were issues with the built-in limit for the number of items in the list and that the limit could be adjusted using a registry tweak. We are using Crystal Reports 2008 where the pagination of the dropdowns was supposed to address that issue.

 

Thanks in advance. Any ideas would be helpful as it is affecting more and more and has quickly become a priority issue.

Thanks for the response. Let me answer the questions for continuity's sake. The records do appear in the database and can be seen when running queries directly on the database. Crystal has no idea if a value will return an empty report since we are using stored procedures to generate the report.

 

After spending more time searching I have discovered that I misunderstood the change made in Crystal 2008. And according to the many threads I have been searching through I am convinced I am not the only one in that situation. Here is what I have discovered in hopes that some other poor searcher finds this and resolves their problem quicker than I did.

 

The introduction of the paginated dropdowns did not change the 1000 row limit, it just made it easier to manage and sort through long lists. The limit is now 5 pages of 200 items (so yes, still 1000). In order to show more than the default 1000 rows  a registry tweak must be used. The tweak is not in the same path as posts dealing with this problem in previous version outlined.

 

To display more than the default 5 pages (or 1000 rows) add the following key to the registry:

 

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV

 

Then add the following String Value:

 

MaxRowsetRecords

 

Set MaxRowsetRecords to the desired value. As far as I can tell there is not a value that can be used to allow an unlimited number but it will allow more than what I currently have a need for. Hopefully that helps others searching for this wonderfully undocumented feature.

 

I saw this topic and hoped that I would get some help, but those suggestions above didn't help for me.

 

So what I'm getting with dynamic parameter is exactly 1000 rows.

That is half of what there is (I know it's alot but it really would be necessary)

 

So what I did was :

 

added key to registry :

 

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV

 

I had to create the whole chagin from Business Objects onwards...because I didn't have Suite 12.0 key at all. All I had was Suite 11.0. Maybe there is something wrong with whole installation, and I should repair the Crystal Reports XI installation.

 

My version of Crystal is 11.0.0.2495

 

If someone could help me with this, I would be very grateful.

 

- Jyri