Special Functions For Reports

From OpenPetra Wiki
Jump to navigation Jump to search

Here is list of the special functions that can be called from the reports. These functions compute the data on the server side and return them into the returnvalue of the report. The functions usually stay in: ICT\Petra\Server\lib\MReporting\MModule\Function.cs. They are called from the report xml file like this:

<calculation id="DummyFunction" returns="PartnerNameAndKey" returnsFormat="text">
  <query>
    <queryDetail>
      <value text="NO-SQL"/>
      <value function="assign(PartnerNameAndKey, {PartnerKey})"/>
      <value function="assign(Amount, add({Amount1},{Amount2}))"/>
    </queryDetail>
  </query>
</calculation>

The assign function is of special use because it assigns a value of another function to a parameter. So it is used in almost every call.

General Functions

These function are usefull for all kinds of reports:

  • eq, ne: Test if two values are equal or not equal
  • lt, le, gt, ge: Test if two values are less than, less equal, greater than, greater equal
  • sub: Parmeter1 - Parameter2
  • add: Parameter1 + Parameter2
  • addItems: Adds a list of parameters. The first parameter defines how many values need to be added
  • mul: Parameter1 * Parameter2
  • div: Parameter1 / Parameter2
  • mod: Parameter1 % Parameter2
  • floor: returns floor integer
  • round: returns rounded integer
  • not: invert boolean value
  • iif: condition, value_if_true, value_if_false )
  • or, and: Logical operatior


Conference

Finance

Financial Development

Partner

Personnel