Special Functions For Reports: Difference between revisions
Jump to navigation
Jump to search
(Created page with '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.…') |
No edit summary |
||
| Line 1: | Line 1: | ||
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\<code>MModule</code>\Function.cs. They are called from the report xml file like this: | 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\<code>MModule</code>\Function.cs. They are called from the report xml file like this: | ||
<calculation id=" | <calculation id="DummyFunction" returns="PartnerNameAndKey" returnsFormat="text"> | ||
<query> | <query> | ||
<queryDetail> | <queryDetail> | ||
| Line 9: | Line 9: | ||
</query> | </query> | ||
</calculation> | </calculation> | ||
The <code>assign</code> 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 | |||
== Conference == | |||
== Finance == | |||
== Financial Development == | |||
== Partner == | |||
== Personnel == | |||
Revision as of 11:00, 6 July 2010
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