Simon Pearce
asked on
Appending value is bringing in a limited list
I had this question after viewing Append all database values in Parameter not bringing in all data..
I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database. If I create an "ALL" selection and run the report it does bring in all sites. Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.
It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing! Not sure if this has an effect.
I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.
I have come to the end of any other solutions?
Any help is much appreciated!
I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database. If I create an "ALL" selection and run the report it does bring in all sites. Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.
It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing! Not sure if this has an effect.
I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.
I have come to the end of any other solutions?
Any help is much appreciated!
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
There is a registry setting, you can use to change the length of the lists.
This link shows where to set the value as it changes with each version of Crystal.
https://apps.support.sap.com/sap/support/knowledge/public/en/1218588
If you only have Crystal Reports and don't run them through BOE you can use 0 as the limit.
Note - A static list may be limited to 1000 elements
mlmcc