Example of including user defined output in a report
Complete these steps in this example to include user defined outputs in your
report:
- Create a detailed report and include the account code and the base amount in the output.
- Create a User Defined Output (UDO) and specify the name as sum.
-
Specify the formula as
{LA\Base Amount}+{LA\Transaction Amount}
- Select the Report Style tab.
- Select Designer. The Report Designer window is displayed.
- In the Output section, right-click Add All add all outputs to the layout. The UDO item is added to the grid as another output item.
-
Click OK to generate the
report.
This table shows the example report.
Account Code Base Amount sum 13000 -283.83 -780.53 13000 -771.94 -1543.88 13000 -335.46 -828.58 13000 -332.18 -664.36 13000 -643.54 -1287.08 13000 -289.43 -714.89 13000 -547.79 -1095.58 13000 -288.83 -58053.83 13000 -0.41 -0.82 13000 -111.86 -223.72 13000 -107.20 -21546.20 13000 -619.45 -1530.04 13000 -310.19 -62347.19 14000 -587.10 -1450.14 14000 -323.14 -64950.14 14000 -859.48 -1718.96 14000 -200.40 -40279.40 14000 -196.51 -393.02 14000 -332.52 -821.33 14000 -198.02 -544.55 14000 -409.84 -819.68 14000 -870.96 -1741.92 14000 -544.78 -1089.56 Total -9164.86 -264425.30