Format lost in report

kanika

Hi experts!!

NAV2017.

In the sales invoice report I have le field "Sales Invoice header".Amount

in the table this field is decimal with value= 8.527,00
but the report shows 8527

Why the value has lost the format??

How to change it??

Thanks for all!!

kanika

Thank you for your answers.

In the properties of the text box was well configured, but still did not show the correct format.

I solved it by changing this code =Code.BlankZero(Code.GetData(60,1))

for this other

=First(Fields!ImporteTotal.Value, "DataSet_Result")

kanika

the value is passed directly in the dataitem without transforming

Slawek_Guzek

The formatting in the report is defined on the report, usually in the field's property.

While editing layout in Visual Studio right click on the field, click Text Box Properties, and you will find formatting in Number sectiom

kanika

Is in the footer like «Expr»

Slawek_Guzek

«Expr» means the format is not fixed but it is set using some expression. Edit it and see what it does.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

NavNab

@kanika

In your dataset, tou will find something like Amount_SalesInvoiceheader
and another one like Amount_SalesInvoiceheaderFormat

Use the first as your column source expression, and the second as Format source expression as explained by @Slawek_Guzek. Or simply select the cell and hit F4. This will open the text zone properties. Look for Format and set the correct value.

Slawek_Guzek wrote: »

The formatting in the report is defined on the report, usually in the field's property.

While editing layout in Visual Studio right click on the field, click Text Box Properties, and you will find formatting in Number sectiom

kanika

Thank you for your answers.

In the properties of the text box was well configured, but still did not show the correct format.

I solved it by changing this code =Code.BlankZero(Code.GetData(60,1))

for this other

=First(Fields!ImporteTotal.Value, "DataSet_Result")