Adds rowMbr to the report and creates a new calculated row whose default name is rowMbr, but which may be renamed with an optional name, rowCalcName, enclosed in quotation marks.
The command automatically stores the data associated with rowMbr, and this data can be referenced by CALC ROW, CALC COLUMN, PRINTROW, or any other command that can reference a calculated row.
When this command is used, the calculation operator for that command is set to OFF, so that its contents are not be affected unless the user explicitly turns the operator back on.
SAVEANDOUTPUT both captures data and outputs the result, whereas SAVEROW captures the output but suppress it.
Syntax
{ SAVEANDOUTPUT [ "rowCalcName" ] } rowMbr !
Parameter | Description |
---|---|
"rowCalcName" | Optional. Name, enclosed by quotation marks, for the calculated data row created by the SAVEROW command. rowCalcName can be multi-part, separated by a tilde (~), as in the CALCULATE ROW and CALCULATE COLUMN syntax. |
rowMbr | Row member that determines the row name for the calculated data row. |
Notes
A member and a calculated row can have the same name. Report Writer considers them separate entities even though they have the same name.
Example
The following example is based on Demo Basic.
{ TEXT 18 "Expenses as % of Sales for January" } Jan Boston Audio Actual Budget { SAVEANDOUTPUT } Sales ! { CALCULATE COLUMN " Actual%" = 1 % "Sales" 1 CALCULATE COLUMN "Budget%" = 2 % "Sales" 2 } COGS Misc Payroll Marketing !
This example produces the following report:
Expenses as % of Sales for January Jan Boston Audio Actual Budget ======== ======== Sales 1,985 2,150 Jan Boston Audio Actual Budget Actual% Budget% ======== ======== ======== ======== Cost_of_Goods_Sold 941 1,007 47 47 Miscellaneous 4 0 0 0 Payroll 542 530 27 25 Marketing 134 130 7 6
See Also