COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: HDA on 23 Sep 2013 11:20:19 AM

Title: Character length in Cognos Report studio value prompt
Post by: HDA on 23 Sep 2013 11:20:19 AM
I have a value prompt in which I want to display Employee Number and Employee name. I have set use value as Employee Number and display value is the combination of Employee Number and Employee Name.

I want the Employee Number and Employee name to be aligned in a line, but the default character size is not letting me do that.

For Example, I have the following emploee no's and names and I want them to display in the following way.

422 STI      Richard

422 XXX     Johnson

In the above example, if you observe STI and XXX are three characters but the letters XXX occupy more space than STI. Because of this my employee names are not lined up in the prompt. They display in the following way which I do not want.

422 STI        Richard

422 XXX        Johnson



Please advice.





Thanks,
Title: Re: Character length in Cognos Report studio value prompt
Post by: calson33 on 23 Sep 2013 11:28:19 AM
You would have to change the font to some fixed width type - I think you can do that using CSS.
I believe Courier New is one of those type of fonts.
Title: Re: Character length in Cognos Report studio value prompt
Post by: HDA on 23 Sep 2013 12:07:11 PM
It works, thank you so much  :)