Limit of dynamic parameter

[pmgatwork]

Hi all
Crystal XI

When I create a dynamic parameter on a colum in a report and then run the report I only get the first 1000 entries in the table. Is there a limit of the first 1000 entries for dynamic parameters

Thanks

Peter

 

[dgillz]

This is a registry setting:

HKEY_CURRENT_USER/Software/Business Objects/Suite 11.0/Crystal Reports/Database/QPMaxLOVSize

The default value is 1000. Change this up as needed, or to zero to display all.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[pmgatwork]

Dave
Made the change up to 10000 and also tried setting to zero.

restarted after each change but still only get the first 1000 records
Crystal XI, Windows XP SP2

Thansk
Peter

 

[dgillz]

This is a dynamic parameter correct? And you are not building a values list for the parameter?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[IdoMillet]

XI R1 or R2?

R2 may require 11.5 in the key, instead of 11.0...

Cheers,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[pmgatwork]

Dave

Dynamic parameter.

Not sure what you mean by not building a value list

Peter

 

[IdoMillet]

Hi Peter,

Here is a technical document describing the settings you need to use:

http://technicalsupport.businessobj...sliceId=&dialogID=4756678&stateId=1 0 4758038

Regards,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ClareR]

Hi all

I am having this issue too when appending database values on creation of a parameter. The link does not seem to be working.... can you repost?

pmgatwork - did you find a solution?

Many thanks



Clare

Crystal XI