Crystal Parameter Default Value limitation

[Spenello]

Using CR 8.5. When selecting default values for a parameter from a database field, the values are being truncated. Is this a limitation of Crystal?

 

[lbass]

I'm assuming you mean that not all values are being returned. The number of values allowed is established in the registry. I believe the number was pretty low in earlier versions. You are probably better off writing a separate report for the values you want to use, exporting it to text, and then importing the text file into the parameter picklist--since the list wouldn't be dynamic anyway.

-LB

 

[Spenello]

On further investigation, browsing field data on the report field, I found the CR string length is 20. The database length is 60. Why is the discrepancy and how to correct?

 

[Spenello]

Got some help on this. We reset the location of the table to the database. Unbeknown to me, this was an old legacy report that pointed to an old SQL database with a field length of 20. The new database is Oracle with a field length of 60.

Problem solved. Thanks for browsing.