Sql convert decimal format to string (id num)

[adimiz123]

Hi

I have field in the format of Decimal.

The field Is Customer ID. ex: 123123123123123123

When im extracting him from the Database, he became like this: 1.2223984732987234e+16

What conversion\format should i amply on the field to set him in the right format? thx.

[arjakumar]

Hi Adi,

Please refer below given solution to this one. Need to check the document override settings. Change the number to integer then it will show properly.

[vishsaggi]

Try like:

Num#(Text([Customer ID])) AS [Customer ID]