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.

Thanks for the idea, but alas this doesn't help. I have the feeling as though the report still thinks this is a VARCHAR(10) field and is truncating the data.