Skip to Content
0
Former Member
Dec 30, 2007 at 10:59 PM

Dynamic cascading prompt problem

27 Views

Post Author: endtr

CA Forum: General

Hi,

I am using Crystal Reports XI Release 2. I have a dynamic cascading prompt with two parameters which are country and city. When the user selects a country, city parameter changes. I am using both "Value" and "Description" properties of the parameter. "Value" property has "country_id" and "city_id" information and "Description" property has "country_name" and "city_name" information repectively. "country_id" and "city_id" values are 15 digits numbers. With these values, cascading prompt is not working well. I tried on my local database with both "country_id" and "city_id" values having 5 digits numbers, cascading prompt worked well. The problem is that "Value" property has big numbers. I can't change customer's database, so I have to find a way to solve this problem. Is there a bug or is there a limitation in Crystal Reports?

Thanks.