Truncating the text of a Record inside a Report


Peter Bradstreet
Hi,

In my Report I am showing a list of notes including the title and body of the note below in each row. I would like to truncate the body of the note in the grid view if the note is longer than xxx characters. For example, if I set xxx to 16 then "This is a longer sentence that has more than 16 characters" would be truncated to "This is a longer..." but "This is short" would remain as "This is short".

I figured that the easiest solution would be to store the truncated body in a separate field such as note_truncated when adding or editing a record(note) and show 'note_truncated' in the report but show the full 'note' in the edit view.

I was wondering whether you have done anything like this before in AB using existing string functions or would I need to create a custom function?

Thanks, Pete

decsoft

Hello Peter,

Talking about some string inside a Report, I am not sure if we can use a bit of CSS to do what we wanted, probably yes, but, also it's possible to use a code like the below one, inside the Report's HTML:

Above you can see two "span" elements. If the "Record.Name" is less or equal to 4, then the Record.Name is printed out as is, in other words, the first "span" appear visible, and not the other one. On the other hand, if "Record.Name" is greater than 4, then the "Record.Name" is truncated using the "substr" Javascript function, so in this last case the second "span" is show, and not first one.



Peter Bradstreet
That is really cool. Thanks very much!

decsoft

No problem! :-)


Todo el mundo puede leer el foro de soporte de DecSoft para aprender del mismo, sin embargo, sólo los clientes de DecSoft pueden abrir nuevos hilos. Compre una o más licencias de productos de DecSoft y obtendrá este y otros beneficios.

Este sitio utiliza "cookies" útiles para almacenar sus preferencias.

Bien. Ocultar esta nota. Obtener más información.