If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

fixed lengths for the each of the columns in concatenated string

Started by Cognos Talk, 18 Jun 2014 12:05:25 PM

Previous topic - Next topic

Cognos Talk

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,

bdbits

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.