Format lost in report

kanika
kanika Member Posts: 247
in NAV/Navision Classic Client
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!!

Best Answer

  • kanika
    kanika Member Posts: 247
    Answer ✓
    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")



Answers

  • kanika
    kanika Member Posts: 247
    the value is passed directly in the dataitem without transforming
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    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
    d52udfs7cpej.png
    l9m5jhy2h4ai.png

    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • kanika
    kanika Member Posts: 247
    Is in the footer like «Expr»
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    «Expr» means the format is not fixed but it is set using some expression. Edit it and see what it does.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • NavNab
    NavNab Member Posts: 181
    @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
    d52udfs7cpej.png
    l9m5jhy2h4ai.png

  • kanika
    kanika Member Posts: 247
    Answer ✓
    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")



Categories