How to change the Format of Decimal field in report?

chandrurec

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.

Purvesh_Maisuria

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

chandrurec

Hi Purvesh Maisuria,

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

Thanks & Regards,
chandru.

Purvesh_Maisuria

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.