Displaying varchar(max) columns

[#1]

Hello, I have a table that has case comments like this:

CaseID (integer)

Comment (varchar(max))

These comments can be quite long. I want to have a tab where I can pick a caseID and it display all of the comments. I have a list box for the caseID, my question is what is the best way to display the comments in their entirety... I have made a table box with the Comment in it, but it will only display the entire comment when I hover over it. I can set the wrap lines to diplay more lines but comments can be short or comments can be very long... If I set the wrap lines to something huge like 10000 then it works but it puts huges spaces in between the comments. They need to be able to see and print the complete comments. What is the best way to do this? Thanks.

[rbecher]

Hi Brian,

there is no dynamic line height in table object or straight table chart. Maybe you can use a text object with horizontal scroll bar and this expression:

=Concat(<your field>, chr(10) & '---------------------------' & chr(10))  // you can use what ever text to separate comments..

- Ralf

[preminqlik]

you can display comments by using maxstring() also....actually i didnt get you what you exactly mea,,... can u post an example qvw....

[Anonymous]

Why not you create a list box with attribute always one selected for field Caseid,

Create a text box and use value as:

mmaxstring(comment)., here you can create a large text box which will always show the comment of whatever caseid is selected.

Hope it helps.

HAPPY NEW YEAR!!!!

Regards

Nitin