Formatting decimal values

Comments

• -=Oleg=-

  June 2010 edited 11:57AM

  Hi.
  
  Use format string:
  %2.2f
  or
  %2.2n
  
  Oleg.
• Antti Kurenniemi

  June 2010 edited 11:57AM

  Hiya,
  
  
  I have tried both of those (in the fcCube.DefaultFormat.FloatFormat), but nothing happens. Even if I try something else, it doesn't change the formatting at all. I've tried casting the numeric field to DECIMAL(9,2) or NUMERIC(9,2), and it affects the display in the DBGrid but not the fcGrid which just cuts off the decimals.
  
  FYI: in FastReports that same formatting works ok, I've used it for a few years already.
• -=Oleg=-

  June 2010 edited 11:57AM

  Hi.
  
  fcCube.DefaultFormat is used for creating fields when the data are loaded from a database.
  When the cube is opened fcCube.DefaultFormat is not used.
  If You load cube from file or stream, is used saved format.
  
  You can change format in slice fields or measures directly.
  
  Oleg.
• Antti Kurenniemi

  June 2010 edited 11:57AM

  Ok - but could you give me an example, please (I'm a bit thick today <g>). For example if I add this field in code:
  
  fcSlice1.AddFieldTo('rowsum', 'Row sum', rf_CapFacts, af_Sum);
  
  How do I set the displayformat for it to be '%2.2f' ?
  
  
  TIA!
• -=Oleg=-

  June 2010 edited 11:57AM

  Hi.
  
  var AIndex: integer;
  begin
  ...
  AIndex := fcSlice1.AddFieldTo('rowsum', 'Row sum', rf_CapFacts, af_Sum);
  fcSlice1.BeginUpdate;
  fcSlice1.CapFactsFieldsAbs[AIndex].DisplayFormat.Kind := fkNumeric;
  fcSlice1.CapFactsFieldsAbs[AIndex].DisplayFormat.FormatStr := '%2.2f';
  fcSlice1.EndUpdate;
  
  And see demo "FastCube examples".
  
  Oleg.
• Antti Kurenniemi

  June 2010 edited June 2010

  Works like a champ, thank you !
  
  ...and now that you mentioned, I found the formatting stuff in the examples. Thanks for that too!
• jasonflord25 California

  July 2010 edited 11:57AM

  wrote: »

  Hi.
  
  var AIndex: integer;
  begin
  ...
  AIndex := fcSlice1.AddFieldTo('rowsum', 'Row sum', rf_CapFacts, af_Sum);
  fcSlice1.BeginUpdate;
  fcSlice1.CapFactsFieldsAbs[AIndex].DisplayFormat.Kind := fkNumeric;
  fcSlice1.CapFactsFieldsAbs[AIndex].DisplayFormat.FormatStr := '%2.2f';
  fcSlice1.EndUpdate;
  
  And see demo "FastCube examples".
  
  Oleg.

  
  
  thanks for this.have the same question.