Show only first part of a large text field on a grid

Jhstephenson

I have a large text field that I only want to show the first 60 characters of on a grid.

How do I do that?

Alternatively the question might also be, how do I keep the row to only one line instead of expanding to fit all of lines of text in the attribute?

Thanks,
Jim

Jaymer

that must be an html field?
maybe 1 of these will work:
either have a copy of it in another field (using a rule) thats not marked as HTML, or use the new 8.1 function to make a calculated column and show that?

but an html field shown in regular text field will show all the html markup (looks ugly maybe to a user). a PATTERN_REPLACE could remove tags.

jaymer...

mrbdrm

if your using custom query you can use css style to show only part of the text

Jhstephenson

Does the CSS Style only work with a custom query?

I am running this from a Tabbed section of a BO form.

I tried putting the following into the CSS Style for the Grid:

.k-grid tbody tr{ height: 50px;} .k-grid td{white-space: nowrap;}

But it didn't seem to have any effect.

customaware

In 8.1 I think you could use a dynamic column.

CHARS_FROM_LEFT(MyBO.MyString,60)

just a thought

aware_support

You can do it with a CSS for a standard query. But I forget the actual values off the top of my head - you can Google for them. The CSS you have tried doesn't seem right. It has something to do with "ellipsis"

mrbdrm

white-space: nowrap;text-overflow: ellipsis;-o-text-overflow: ellipsis;overflow: hidden;

Jhstephenson

mrbdrm, should this be entered in the custom css file or will it work by entering it directly into the CSS Style property of the Query?

Jhstephenson

Mark, your dynamic column suggestion worked.

I think I still want to see if I can get the CSS Style suggestion to work too though because I can see some other uses for it.

mrbdrm

it will work directly with inline style .