Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

Displaying large fields in Crystal Report XI

Hello,

I am using CR XI.

We have a table that has a varchar column that is 3000 characters.

In CR XI this shows up as a string field of 255.

Is there anyway i can display all 3000 characters?  Is this fixed in a later version of CR?

Thanks.

/Richard
0
soozh
Asked:
soozh
2 Solutions
 
mlmccCommented:
WHat do you mean it shows as 255?

CR9 "fixed" the 255 character limit.
CR XI should be able to see it in its full length.

Have you tried putting it on the report and setting it to grow and see what you get?

What database?

What database connection method?

mlmcc
0
 
UnifiedISCommented:
Is the report upgraded from an older version?
did you "verify database" yet?
0
 
soozhAuthor Commented:
i understood from your comments that it should work... so i looked a little closer and disovered the report was based on a view... and the view needed to be refreshed (sp_refreshview) to incorpprate the changes made in the underlying tables.

So thank... its fixed.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now