Hello!
How do I concatenate equally each column in concatenated string so I get and equal spacing in between each of the fields in report studio? I need to display it looking like table output, i.e liking like each individual column
I am using Informix as a source
I do the following command, but it doesn't work properly after location.
[Ticket No] ||' '||[ Date]||' '|| [Status Description]|| ' '||cast([P First Name] as char(15)) ||' '||cast([P Last Name]as char(25)) ||' '|| cast([Location] as char(35)) ||' '|| cast([Desc]as char(60))
Thank you very much in advance for your help,
If you need it to look "like table output", why don't you just use a normal data container with data items in columns and style accordingly? e.g. set the column widths to be fixed equal lengths. You can remove borders and other styling if you like.
Most containers already render as tables.