debet, credit, saldo in fast report

Comments

• gordk St.Catherines On. Canada.

  March 2011 edited 6:50PM

  use a variable in the balance memo
  write code in obp event of band to set the variables value.
  Balance := Balance + ((<datasetname."debit">) - (<datsetname."credit">));
  declare your variable at the top of the code page not within in the procedure.
  you will also need to initialize the variable in a group header band.
• Mick.pl

  March 2011 edited 6:50PM

  I've found another example how to make it by using FR agregate functions.
  The documentaction (I use one of 4.6 dated 2008) says about it in chapter 3.6 "Agregate functions".
  
  If you use (see there are only TWO actual params to function SUM):
  
  [SUM(<Groups."ItemsTotal">, MasterData1)]
  
  then you get result like in the first picture. But if you use (see there are THREE actual params to function SUM):
  
  [SUM(<Groups."ItemsTotal">, MasterData1,2)]
  
  then you get result like in the second picture.
  
  
  Mick
  

  1._Sum_without_flag_or_flag___0.jpg 17.1K

  2._Sum_with_flag___2.jpg 12.8K
• gordk St.Catherines On. Canada.

  March 2011 edited 6:50PM

  Mick you are showing him how to use it in a group footer not in each line of the masterdata
• Mick.pl

  March 2011 edited 6:50PM

  Thanks GordK, you're right :-)
  I didn't notice this should be print on masterband :-(
  
  Mick
• Peterbride4545

  March 2011 edited 6:50PM

  I just have the same problem.Hope can be solved soon.