The NOROWREPEAT command prevents row member names from being repeated on each line of the report if the row member name does not change on the next line. This is the default.
{ NOROWREPEAT }
NOROWREPEAT is the default; you need only use this command after using ROWREPEAT.
This command prevents row member names from being repeated on each line of the report if the row member name does not change on the next line. NOROWREPEAT is only used to cancel the effects of the ROWREPEAT command. The ROWREPEAT command causes all row member names to be displayed on every line of the report even if the names for some members are the same.
The following example is based on the Sample Demo database.
The following report is an example of the default behavior for row names not repeating. The names only print when they change.
<PAGE (Market, Accounts)
Chicago Sales
<COLUMN (Scenario)
Actual
<ROW (Year, Product)
{ NOROWREPEAT }
<ICHILDREN Qtr1
<ICHILDREN Audio!
{ ROWREPEAT }
<ICHILDREN Qtr2 !
Which produces the following report:
Chicago Sales Actual Jan Stereo 923 Compact_Disc 1,120 Audio 2,043 Feb Stereo 834 Compact_Disc 1,050 Audio 1,884 Mar Stereo 834 Compact_Disc 980 Audio 1,814 Qtr1 Stereo 2,591 Compact_Disc 3,150 Audio 5,741
Chicago Sales Actual Apr Stereo 821 Apr Compact_Disc 985 Apr Audio 1,806 May Stereo 821 May Compact_Disc 1,014 May Audio 1,835 Jun Stereo 834 Jun Compact_Disc 1,022 Jun Audio 1,856 Qtr2 Stereo 2,476 Qtr2 Compact_Disc 3,021 Qtr2 Audio 5,497
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.