Decimal point alignment for numbers

Comments

• AzzaAzza69

  July 2004 edited 7:13AM

  Any ideas anyone? Alex?
• AlexTZ

  July 2004 edited 7:13AM

  Use Format function, for example
  Format('%-5.2f', [1.23])
  will produce left-aligned number with two trailing spaces. 5 is whole width, 2 is number of digits after decimal point. Such string can be shown in the "Text" object with align=right and will look decimal point-aligned.
• AzzaAzza69

  July 2004 edited 7:13AM

  Thanks Alex but that isn't what I wanted!
  
  When there are numbers with no numbers after the decimal point (ie. 00) I don't want them displayed (see the number 2 in my original post).
  
  Also:
  a. certain items will have a different amount of decimal places, either none, 2 or 4.
  b. I don't want to use a fixed width font as it will look out-of-place with all other reports/fonts.
• AlexTZ

  July 2004 edited 7:13AM

  In this case you should use OnBeforePrint event of the "Text" object with a number. Event handler should form a string that contains a number and needed amount of spaces.
• AzzaAzza69

  July 2004 edited 7:13AM

  Thanks for reply but, again, as I stated:
  "b. I don't want to use a fixed width font..."
  to see what I mean:
  1. drop 2 text objects on the FR
  2. set both left value to same
  3. enter "1234.5678" in first text box
  4. enter "<3 spaces>0.123456" into second (obviously using space characters and not the text spaces>!
  5. see the decimal point and the trailing numbers don't line up!!!
  
  So, as it looks like I can't align to decimal point, can I make a request to add this to the "wish list" (either FR2 or 3)?
  
  PS. Can you also add (to FR3 or the wish list) the <STRIKE>...</STRIKE> html tag to the HTML support to set the fsStrikeout Style of the Font.
  
  Thanks,
  Azza
  
• gordk St.Catherines On. Canada.

  July 2004 edited 7:13AM

  Hi Azza
  you are talking about decimal align like a spreadsheet.
  here is how I work arround it currently in 2.5#
  but it would be nice to have in 3
  use 2 memos of a fixed size side by side right align the left memo left align the rightmemo.
  convertvalue of field to string copy the whole number portion to the left memo
  copy the decimalportion including decimal separator to rightmemo.
  regards
  
• AzzaAzza69

  July 2004 edited 7:13AM

  Thanks, Gord.
  Just as I thought, a workaround. Looks like I'll have to stick to our existing solution. Hopefully Alex will include this in an early 3.0x version?!