Format Number like this XX-XX-XXXX-XX

[Sudha]

This might be a dumb question, but i tried and failed. Please help me out
I have a number which comes from DB2 DataBase, which needs to be formatted in this way XX-XX-XXXX-XX
Is there a way to set using the dataformat while reporting in ReportStudio.

I tried to explore using this tip from SupportLink Doc. <Please refer Page 53 in this link>
http://support.cognos.com/supported/supportlink/15n2/pdf/SL_vol15n2_100_full.pdf

Any ideas/help is really appreciated.
Thanks
S

[mikegreen]

That solution won't work as it is using decimals to place the dash "-"

I would (either in Framework Manager or ReportStudio...) convert it to a text field, then do LEFT(column1,2) + "-" + MID(column1,3,2) + etc etc and build a text string that way.

Regards,

Mike