Resize varchar doesn't update crystal report

Question

I've got an existing report with quite a few fields on it.

I have just modified my database changing a varchar(10) to a varchar(20)

When I test it out with data '12345678901234567890' the query against my view works perfectly fine. However, even after I've completed a "Verify Database" it doesn't display the whole value.

I have attempted using a formula to display it, it still truncates it at 10 characters, I have also done a LEN({myfield}) and it displays 10.

I have also used the command "Update datasource location".

Somehow that field length information is stuck.

Answer 1

I have resolved it in a roundabout way.

1. I removed this field from my datasource,
2. I then verified the database and the field was removed from the report
3. I then re-added the field to the datasource
4. Then re-added the field to the report

Everything displayed properly.