Sample 15-B: Calculated Rows and Missing Relationships
This sample report is a simple summary of information in a North/South grouping, which is not part of the database outline. When relationships that you need for reporting are missing in the database outline, often the best solution is to use calculated rows (or columns).
Budget Payroll
Jan Feb Mar
==== ==== ====
Northern Cities
================
New_York 1,940 1,930 1,930
Boston 1,610 1,610 1,610
Chicago 1,630 1,630 1,630
San_Francisco 1,815 1,815 1,815
Seattle 1,415 1,409 1,409
Southern Cities
================
Denver 1,499 1,499 1,499
Los_Angeles 1,757 1,787 1,787
Dallas 1,002 1,002 1,002
Phoenix 900 900 900
Houston 834 834 834
Total Northern 8,410 8,394 8,394
Total Southern 5,992 6,022 6,022
Use the following script to create Sample 15-B:
// Declare Calculated Rows to Sum Southern and Northern Cities
{ CALCULATE ROW "Total Southern" OFF
// initially, set operation to OFF
CALCULATE ROW "Total Northern" OFF }
<PAGE(Product,Scenario,Accounts)
{ RENAME "" } Product // all products, so blank out
// the Product Label
Budget
Payroll
<COLUMN(Year)
Jan Feb Mar
<ROW(Market) // Northern Cities
{ SETROWOP "Total Northern" + // Accumulate for Northern
SKIP 3
IMMHEADING // Put out heading now so text
// will go after it
Text 0 "Northern Cities" UCHARACTERS
}
New_York Boston Chicago San_Francisco Seattle
//Southern Cities
{ SETROWOP "Total Southern" + } // Accumulate for Southern
{ SETROWOP "Total Northern" OFF } // Stop Accumulation for Northern
{ SKIP Text 0 "Southern Cities" UCHARACTERS }
Denver Los_Angeles Dallas Phoenix Houston
{ SKIP
PRINTROW "Total Northern" // output calculated rows
PRINTROW "Total Southern"
}
!
This report script, ROWCALC2.REP
, is available in the \
ARBORPATH
\App\Demo\Basic
directory.