Amount in Text issue in RDLC report

Amolkbhad23Amolkbhad23 Member Posts: 46
edited 2012-11-20 in NAV Three Tier
Hi all,

i need help from you.
i create one report in classic and RDLC ( Same Report in RDLC).
when i run report in classic amount "110.00" is showing " One Hundred Ten and Zero only" but when same report i run in RDLC
it show me " One Hundred ten and 0/100 only"
i want to know why this happen. and how to solve this. ](*,)

Plz Help me. :?:

Regards,
Amol

Comments

  • clauslclausl Member Posts: 455
    2 Things:

    1. Look in "About this Report" to see the actual value you are sending to Report Viewer.

    2. And then use the format value which is found in your dataset in Visual Studio. Select the textbox with your value, then select the "Format" property, and then set the expression to the correct format value.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
  • anand_murthuanand_murthu Member Posts: 30
    Hi Amol

    You can do one thing ...Just go to Source Expr of the text in Classic Report and use FORMAT function there.
    For exp.. if the Source Expr is Amount, then Change it to FORMAT(Amount).


    Thanks,
    Anand
Sign In or Register to comment.