number-to-string-padded--????

[pooja]

we are upgrading reports from 7.3 to v8 and we are stuck on one
issues which we are not able to overcome. please any advice/solution
would be great.
how to do number-to-string-padded in cognos 8 for BELOW EXAMPLE, please

ex--
number-to-string-padded([dept_code],3)+'_'+ number-to-string-padded([field_code],6)

thankx in advance,

[pooja]

Any Help/Response, please

[pooja]

 :o :o ???

[MFGF]

Hi,

What result are you trying to achieve?  Do you need your result to be nnn_nnnnnn or something else?

If it's the former, try the following:

substring(cast([dept_code]+1000000,char(7)),5,3) + '_' + substring(cast([field_code]+1000000000,char(10)),5,6)

MF.

[pooja]

still unable

I was not able to explain in details on my last post. But this is the case in 7.3. Now I need to
update this condition in cognos8. anyone, please advice how to achieve in cognos8

(asciiz(round("office_code",0,0),3)) || '-' || (asciiz(round("dept_code",0,0),6)) as CODE

any help kindly appreciate.

[MFGF]

As requested before, can you explain exactly what result you are trying to achieve?  We've already had one stab at providing an answer, which appears not to be what you require, so you really need to explain what result you want in order for anyone to be in with a chance of helping you.

MF.