Options

How to change the Format of Decimal field in report?

chandrurecchandrurec Member Posts: 560
Hi all,

I am displaying a totoal decimal field in report.But it is getting displayed in format which we set in regional settings.But If I want to change the format as per the Indian version(ex:1,23,500), can I change it using the "Format" Keyword.If possible ,Kindly give me the syntax for achieving this.

Thanks in advance.

Regards,
chandru.

Comments

  • Options
    Purvesh_MaisuriaPurvesh_Maisuria Member Posts: 71
    Hello,

    Steps
    1. Open Report in Visual Studio RDLC
    2. Go in Property of Textbox On Which U Apply Format U Want Like (ex:1,23,500) By Right Click->Property.
    3. Go In Format Tab.
    4. In Format Codes: Click The Assist Edit Button Beside The fx Button.
    5. In Standard: Select Whatever Format U Want, For Ur Ex. Select Second.

    Hope This Will Solve Ur Problem.

    Thanks & Regards,
    Purvesh Maisuria
  • Options
    chandrurecchandrurec Member Posts: 560
    Hi Purvesh Maisuria,

    I want to do it in Classic report layout and not in rtc report layout.

    Thanks & Regards,
    chandru.
  • Options
    Purvesh_MaisuriaPurvesh_Maisuria Member Posts: 71
    Hi

    Check This

    MESSAGE(FORMAT(12500.0, 10,0));

    For More Referance : http://msdn.microsoft.com/en-us/library/dd301059.aspx

    Thanks & Regards
    Purvesh Maisuria.
Sign In or Register to comment.