We are writing a Crystal report based on Oracle database. In Crystal designer lot of database fields are displaying wrong length compared to actual lengths defined in the database. Is there any reason for mismatch between Crystal and database? I have attached a screenshot of some fields from Crystal, Week_number is showing as 4000 characters length where as database side that field is 10 characters.
Is there any way we can make it real length in Crystal?