How to display Numeric to Word in SSRS Report throught Field Expression

Finance and Operations/AX Developer Forum
1

How to display Numeric to Word in SSRS Report throught Field Expression

2 
With in Field Expression, Use common functions - Conversion - CStr

or 

To avoid Field Expressions,

You can aslo setup the query as: assue Field i was int.

--Method 1 : Use CAST function

SELECT CAST(@i as varchar(10))

--Method 2 : Use CONVERT function
SELECT CONVERT(varchar(10),@i)

--Method 3 : Use STR function
SELECT LTRIM(STR(@i,10))
3

Dear Khalid

i had try all the methods you had mansion, it is just converting integer to string.

i need to convert the number to the word

ex: 1000 have to convert “One Thousand”

4

Hi Abdul,

You need to write the method and call that method in Expression in Visual studio for Number to Words.

As per my concern the easiest way is convert in AX and pass to Visual studio.

Regards,

Mahesh Amundla.

5

Hi Mahesh,

Thanks for your response even in your busy schedule.Can you please guide me the step wise procedure to the above call method in Visual Studio in Expression please.

Regards and Thanks

Abdul

6

Anyone knows please help me in this

7

Whethter it is possible in SSRS Reports