Each page of this report contains Sales information for a given Market. The report page contains members for both Product and Year as groups of rows down the page. This script creates a four-page report because the page dimensions and their member selections are the same as in Sample 3: Nesting Columns. The row and column layout is switched because the row and column dimensions are different. This section shows a representative part of the output.
Sales East Actual Budget Variance ======== ======== ======== Stereo Qtr1 7,839 8,350 (511) Qtr2 7,933 8,150 (217) Qtr3 7,673 8,350 (677) Qtr4 10,044 10,400 (356) Year 33,489 35,250 (1,761) Compact_Disc Qtr1 10,293 9,950 343 Qtr2 9,702 9,750 (48) Qtr3 9,965 10,050 (85) Qtr4 11,792 12,550 (758) Year 41,752 42,300 (548) Audio Qtr1 18,132 18,300 (168) Qtr2 17,635 17,900 (265) Qtr3 17,638 18,400 (762) Qtr4 21,836 22,950 (1,114) Year 75,241 77,550 (2,309) Television Qtr1 13,404 13,400 4 Qtr2 12,115 12,900 (785) Qtr3 15,014 14,200 814 Qtr4 17,861 17,300 561 Year 58,394 57,800 594 VCR Qtr1 11,721 11,600 121 Qtr2 10,999 11,100 (101) Qtr3 13,217 11,800 1,417 Qtr4 14,386 14,900 (514) Year 50,323 49,400 923 Camera Qtr1 7,722 8,190 (468) Qtr2 7,581 8,210 (629) Qtr3 8,181 8,630 (449) Qtr4 10,853 11,550 (697) Year 34,337 36,580 (2,243) Visual Qtr1 32,847 33,190 (343) Qtr2 30,695 32,210 (1,515) Qtr3 36,412 34,630 1,782 Qtr4 43,100 43,750 (650) Year 143,054 143,780 (726) Product Qtr1 50,979 51,490 (511) Qtr2 48,330 50,110 (1,780) Qtr3 54,050 53,030 1,020 Qtr4 64,936 66,700 (1,764) Year 218,295 221,330 (3,035) Sales West Actual Budget Variance ======== ======== ======== Stereo Qtr1 11,633 11,200 433 Qtr2 11,191 11,050 141 Qtr3 11,299 11,650 (351) Qtr4 14,018 14,500 (482) Year 48,141 48,400 (259) Compact_Disc Qtr1 14,321 13,500 821 Qtr2 14,016 13,500 516 Qtr3 14,328 14,300 28 Qtr4 17,247 16,700 547 Year 59,912 58,000 1,912 Audio Qtr1 25,954 24,700 1,254 Qtr2 25,207 24,550 657 Qtr3 25,627 25,950 (323) Qtr4 31,265 31,200 65 Year 108,053 106,400 1,653 Television Qtr1 14,629 14,300 329 Qtr2 14,486 13,800 686 Qtr3 14,580 14,000 580 Qtr4 20,814 19,400 1,414 Year 64,509 61,500 3,009 VCR Qtr1 13,854 13,050 804 Qtr2 13,156 12,600 556 Qtr3 15,030 13,750 1,280 Qtr4 18,723 17,950 773 Year 60,763 57,350 3,413 Camera Qtr1 10,756 11,550 (794) Qtr2 10,573 11,400 (827) Qtr3 10,735 11,550 (815) Qtr4 13,906 15,000 (1,094) Year 45,970 49,500 (3,530) Visual Qtr1 39,239 38,900 339 Qtr2 38,215 37,800 415 Qtr3 40,345 39,300 1,045 Qtr4 53,443 52,350 1,093 Year 171,242 168,350 2,892 Product Qtr1 65,193 63,600 1,593 Qtr2 63,422 62,350 1,072 Qtr3 65,972 65,250 722 Qtr4 84,708 83,550 1,158 Year 279,295 274,750 4,545 /pre> Sales South Actual Budget Variance ======== ======== ======== Television Qtr1 8,881 9,600 (719) Qtr2 8,627 9,300 (673) Qtr3 8,674 9,300 (626) Qtr4 12,919 12,600 319 Year 39,101 40,800 (1,699) VCR Qtr1 9,551 9,600 (49) Qtr2 9,049 9,300 (251) Qtr3 9,998 10,000 (2) Qtr4 12,923 13,600 (677) Year 41,521 42,500 (979) Camera Qtr1 6,641 7,200 (559) Qtr2 6,765 7,350 (585) Qtr3 6,798 7,500 (702) Qtr4 9,486 10,200 (714) Year 29,690 32,250 (2,560) Visual Qtr1 25,073 26,400 (1,327) Qtr2 24,441 25,950 (1,509) Qtr3 25,470 26,800 (1,330) Qtr4 35,328 36,400 (1,072) Year 110,312 115,550 (5,238) Product Qtr1 25,073 26,400 (1,327) Qtr2 24,441 25,950 (1,509) Qtr3 25,470 26,800 (1,330) Qtr4 35,328 36,400 (1,072) Year 110,312 115,550 (5,238) Sales Market Actual Budget Variance ======== ======== ======== Stereo Qtr1 19,472 19,550 (78) Qtr2 19,124 19,200 (76) Qtr3 18,972 20,000 (1,028) Qtr4 24,062 24,900 (838) Year 81,630 83,650 (2,020) Compact_Disc Qtr1 24,614 23,450 1,164 Qtr2 23,718 23,250 468 Qtr3 24,293 24,350 (57) Qtr4 29,039 29,250 (211) Year 101,664 100,300 1,364 Audio Qtr1 44,086 43,000 1,086 Qtr2 42,842 42,450 392 Qtr3 43,265 44,350 (1,085) Qtr4 53,101 54,150 (1,049) Year 183,294 183,950 (656) Television Qtr1 36,914 37,300 (386) Qtr2 35,228 36,000 (772) Qtr3 38,268 37,500 768 Qtr4 51,594 49,300 2,294 Year 162,004 160,100 1,904 VCR Qtr1 35,126 34,250 876 Qtr2 33,204 33,000 204 Qtr3 38,245 35,550 2,695 Qtr4 46,032 46,450 (418) Year 152,607 149,250 3,357 Camera Qtr1 25,119 26,940 (1,821) Qtr2 24,919 26,960 (2,041) Qtr3 25,714 27,680 (1,966) Qtr4 34,245 36,750 (2,505) Year 109,997 118,330 (8,333) Visual Qtr1 97,159 98,490 (1,331) Qtr2 93,351 95,960 (2,609) Qtr3 102,227 100,730 1,497 Qtr4 131,871 132,500 (629) Year 424,608 427,680 (3,072) Product Qtr1 141,245 141,490 (245) Qtr2 136,193 138,410 (2,217) Qtr3 145,492 145,080 412 Qtr4 184,972 186,650 (1,678) Year 607,902 611,630 (3,728)
Use the following script to create Sample 4:
<PAGE (Accounts, Market) Sales <ICHILDREN Market { PAGEONDIMENSION Market } { SUPMISSINGROWS } <COLUMN (Scenario) <CHILDREN Scenario <ROW(Product3, Year) <ICHILDREN Year <IDESCENDANTS Product !
This report script, ROWGROUP.REP, is available in the \ARBORPATH\App\Demo\Basic directory, and is displayed in Enterprise View in Administration Services.