cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic parameter with 'type-ahead' capability

Former Member
0 Kudos

Hi,

How do I create a dynamic parameter that will return a drop down list of over 11,000 records in alphabetic order that I can then select the value I want by starting to type in the value. For example, in a list of cities of the world I want to select 'London' so I type in an 'L' and the list moves to the first city starting with an 'L', I then type an 'o' and the list goes to 'Lo' etc.

At the moment only 30 values appear in the drop-down list and I can only enter the first letter.

I want to use this value as the parent for a cascading parameter.

Thanks, Colin

Accepted Solutions (0)

Answers (1)

Answers (1)

alex_styles
Advisor
Advisor
0 Kudos

The dynamic parameter does not have the functionality to 'type-ahead' and go to specific values in the list in that manner. The most you can do is go to values that start with a specific letter and scroll through them. This behavior is occurring by design.

By default, Crystal Reports will only return the first 1000 unique values for a dynamic parameter. This can be changed through a registry entry.

For information on changing the values retrieved for the dynamic parameter, you can refer to the following Business Objects Note.

- Go to this link

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_ossnotes&query=&adv=true

- Search for the Note: 1218588

When using a dynamic parameter, the limit will be a combination of all the values return at each level to reach the total number of records returned. Also the more records that you return to the dynamic parameter, the longer it will take to retrieve the data from the database.