Calculated Columns - Can I Declare Variables in Expressions

Comments

• ipong

  October 2016 edited 3:13AM

  read FRNetUserManual-en.pdf, script section and example, is that what you wanted?
• CarlosC

  October 2016 edited 3:13AM

  ipong wrote: »

  read FRNetUserManual-en.pdf, script section and example, is that what you wanted?

  
  Not exactly: in this case I was looking at the possibility to do this at the data source level, in the expression of a Calculated Column.
  
  I can create a calculated Column named StkPrev, and assign the expression as:
  [EXIST.STKREAL]+[EXIST.QTDENCFOR]-[EXIST.QTDENCCLI]
  
  What I would like to know if I can declare and use variables at this level, or if the use of variables is reserved to the script level.
  
  
  
  
  
  
  
• ipong

  October 2016 edited October 2016

  There are two methods for calculated columns :
  
  1. in textobject, the formula is enclosed by square brackets, create expression like this :
  
  EXIST.STKREAL] + [EXIST.QTDENCFOR] - [EXIST.QTDENCCLI
  
  
  2. use script, more flexible, with c# you can code anything :
  

  namespace FastReport
  {
    public class ReportScript
    {
      private decimal StkPrev;
  
      private void Data1_BeforePrint(object sender, EventArgs e)
      {
        StkPrev = (Decimal)Report.GetColumnValue("EXIST.STKREAL") + (Decimal)Report.GetColumnValue("EXIST.QTDENCFOR") - (Decimal)Report.GetColumnValue("EXIST.QTDENCCLI");
      }
    }
  }
  </ScriptText>
  

  
  then create textobject with expression [StkPrev] , variable StkPrev in script can be used as an expression in textobject.