Decimal Places of Decimal Field in RTC Report

Comments

• Options

  mohana_cse06 Member Posts: 5,503

  2011-08-19

  Did you set Format property for that field in footer?

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• Options

  Belias Member Posts: 2,998

  2011-08-19

  if you have done "create layout suggestion", NAV has automatically set the format property in the fields that have been automatically created (e.g. that one in your body section).
  If you add more fields manually, the property settings automatically done by NAV are (obviously) not retained (padding, formatting, alignment...).
  Check out the format property of your working field (that will probably have a value like "mydecimalfield_Format" or so). As you cannot use the same value in the footer section, because "mydecimalfield_Format" is part of the dataset, you can:
  -check what's its value in the "about this report" function and copy that value in the format property of the new field.
  - familiarize the format property and set it as you prefer (i never remember what are the exact characters for that property :whistle: )

  -Mirko-
  "Never memorize what you can easily find in a book".....Or Mibuso
  My Blog

  0
• Options

  Alagar Member Posts: 100

  2011-08-20

  Hi mohana_cse06,
  No ](*,)

  0
• Options

  manikandan Member Posts: 160

  2011-08-20

  Hi Alagar,
  Using ROUND(Amount, 0.01, '>') in Source Expression Instead of Amount
  
  I hope this clarifies. :thumbsup: :thumbsup: :thumbsup:

  0
• Options

  mohana_cse06 Member Posts: 5,503

  2011-08-20

  Alagar wrote:

  Hi mohana_cse06,
  No ](*,)

  
  As Mirko said, Assign <fieldName>_Format field in Format property

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• Options

  Alagar Member Posts: 100

  2011-08-20

  Hi All,
  I got it result Using ROUND(Amount, 0.01, '>') in Source Expression Instead of Amount
  Tks for manikandan,mohana_cse06 and Belias.

  0
• Options

  mrQQ Member Posts: 239

  2011-09-16

  this is a bug. Even with create layout, and the Format property assigned, it still does not format them like it's supposed to.

  0
• Options

  kabroco Member Posts: 111

  2012-03-30

  Maybe something like this does work:
  (this is for a transfooter with using functions with a hasttable see: [report properties], [code]
  See the blog of "Transfooter and Transheader functionality in RDLC(SSRS) reports)
  The 2 presents the number behind the comma).
  
  Value field: expression:
  ="Transport " & FormatNumber(Code.SetRunningTotal( Sum(ReportItems!Sales_Invoice_Line__Line_Amount_.Value), Globals!PageNumber),2)

  0