How to set 1000 Seperater for Interger and Decimal Values in Report

Akil_Reddy · January 23, 2015, 5:16pm

Hi All,

I Generate a Report In my Report One Gross Amount Field is their in that field Integer and Decimal Amount is their

so I want to print integer values as integer and decimal Values as Decimal With 1000 Seperator

Ex:- in my field 1456

2456.23

This are amounts when i Set Textbox properties it shows as

1,456.00

2.456.23

but 1456 is integer i want print like 1,456 and 2,456.23 is decimal as like i want to print

is their any property pls help me…[:’(]

faludigabor · January 24, 2015, 2:45pm

Hi Ramesh ,

Have a look at the FORMAT function and the FORMATSTR properties help .

Gábor

amol_salvi · January 26, 2015, 2:47am

Ramesh,

Always mention which version of navision you are using which will be easier for members to give your anwser

Akil_Reddy · January 26, 2015, 7:22am

Sorry Amol,

I never repeat this one i am using navision 2013 r2 and i got this error when i Generate reports

Akil_Reddy · January 26, 2015, 7:27am

Hi falufabor,

i already seen all the properties in MSDN can you provide any links to resolve this error…

Akil_Reddy · January 29, 2015, 8:43am

Any One Can Give Reply For This Post

amol_salvi · January 29, 2015, 8:46am

Check the properties of Textbox in RDLC Layout and there you can find Use 1000 separator

Akil_Reddy · January 29, 2015, 8:56am

Hi Amol Thanks For Giving Reply,

i Already used This 1000 separator property But i am not getting

means i want to display integer values as integer format like 1,235

and Decimal Values as 5,635.43

Finally What i Said that my Report as Amount Field is Their,i want to print Integer values as integer and Decimal Values as Decimal With 1000 Seperater

EX:-

Amount

1,235

5,635.43

4,215.43

4,126

Akil_Reddy · January 29, 2015, 8:57am

but it prints like this

Amount

1,235.00

5.635.43

4,215.43

4,126.00

mahesh_mahi · January 29, 2015, 9:30am

Hi

you mean that you want that values as it is…

Akil_Reddy · February 2, 2015, 5:40am

Yes…

postsaurav · February 3, 2015, 8:03am

Hi Ramesh,

Hope it helps.

Changed The Format Expression For -

1. Field - Unit Price

Expression - Code.BlankZero(Fields!UnitPrice_SalesInvLine.Value)

Format (Old) - =Fields!UnitPrice_SalesInvLineFormat.Value

Format (New) - =IIf(Int(Fields!UnitPrice_SalesInvLine.Value) = Fields!UnitPrice_SalesInvLine.Value,“0;(0)”,"#,0.00;(#,0.00)")

2. Field - Line Amount

Expression - Code.BlankZero(Fields!LineAmount_SalesInvLine.Value)

Format (Old) - =Fields!LineAmount_SalesInvLineFormat.Value

Format (New) - =IIf(Int(Fields!LineAmount_SalesInvLine.Value) = Fields!LineAmount_SalesInvLine.Value,“0;(0)”,"#,0.00;(#,0.00)")

Int Function Returns the Integer Part in a Number. If the Number will be Integer the condition will return True else False.

0;(0) - Format for Numeric Part.

#,0.00;(#,0.00) - Format for Decimal Part with Thousand Seprator

Hope it resolves the issue.

Akil_Reddy · February 3, 2015, 9:49am

Hi Saurav,

Thanks For reply…

it works Fine but integer values didn’t Get Thousand seprator…

Thanks and Regards,

ramesh.v

Akil_Reddy · February 3, 2015, 10:28am

yes i got the solution when i chage it like as

=IIf(Int(Fields!Ordre_Amount_G.Value) = Fields!Ordre_Amount_G.Value,"#,0;(#,0)","#,0.00;(#,0.00)")

Thanks Saurav…