开发者

Resize varchar doesn't update crystal report

开发者 https://www.devze.com 2023-01-07 12:19 出处:网络
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)

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开发者_Go百科 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.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号