SAVEANDOUTPUT

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 enclosed in quotation marks.

Syntax

{ SAVEANDOUTPUT [ "rowCalcName" ] } rowMbr !

"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.

Default Value

Creates a new calculated row whose default name is rowMbr, and automatically stores the data associated with rowMbr. You can rename with an optional name, rowCalcName, enclosed in quotes.

The calculation operator for that command is set by default to OFF.

Description

This command creates a new calculated row. 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 will capture the output but suppress it.

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

CALCULATE COLUMN
CALCULATE ROW
CLEARROWCALC
CLEARALLROWCALC
OFFCOLCALCS
OFFROWCALCS
ONCOLCALCS
ONROWCALCS
OUTPUT
PRINTROW
REMOVECOLCALCS
SAVEANDOUTPUT
SAVEROW
SUPOUTPUT

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com