| Field Name |
Class |
Needed? |
Data
Type |
Formula |
Report |
| Amount |
Calc |
Yes |
N |
QUANTITY * PROD_PRICE |
Basic Columnar Report.rsw |
| Amount |
Calc |
Yes |
N |
QUANTITY * PROD_PRICE |
Grouped Columnar Report.rsw |
| Amount |
Calc |
Yes |
N |
QUANTITY * PROD_PRICE |
Summary Columnar Report.rsw |
| AnnlTotal |
Calc |
Yes |
N |
Sls5YrTot + Sls4YrTot + Sls3YrTot +
Sls2YrTot + Sls1YrTot |
Cross Tabulation Report.RSW |
| aver_ord |
Total |
Yes |
N |
Average(RRPRICES.PROD_NAME, Grand,
RRORDERS.CUSTNO, Running) |
Summary Columnar Report.rsw |
| avg_amt |
Total |
Yes |
N |
Average(RRORDERS.Date_rr(), Grand,
RRORDERS.CUSTNO, Running) |
Summary Columnar Report.rsw |
| BegDate |
Param |
Yes |
D |
{03/02/2000} |
Sales by Salesperson Report.RSW |
| CityCtry |
Calc |
Yes |
C |
CITY - ", " + COUNTRY |
Form Letter with Bursting
Report.RSW |
| CityStZIP |
Calc |
Yes |
C |
CITY - ", " + STATE - " " + CODE |
Form Letter with Bursting
Report.RSW |
| cmonth |
Calc |
Yes |
C |
cmonth(ORDRDATE) |
Cross Tabulation Report.RSW |
| CourseName |
Calc |
Yes |
C |
CASE(item,'SLS01','Sales
Fundamentals','SLS02','Negotiation
Skills','SLS03','Strategies for Success','') |
Sales by Salesperson Report.RSW |
| ctry |
Calc |
Yes |
C |
IIF(country="","USA",country) |
Export Report.RSW |
| ctry |
Calc |
Yes |
C |
IIF(country="","USA",country) |
Multi-Line Columnar Report.rsw |
| cumul_tot |
Total |
Yes |
N |
Sum(RRORDERS.OrderEndDt(),
RRORDERS.CUSTNO, Every composite, Running) |
Summary Columnar Report.rsw |
| CustName |
Calc |
Yes |
C |
TITLE - " " + FIRST_NAME - " " +
LAST_NAME |
Form Letter with Bursting
Report.RSW |
| CustOrders |
Total |
Yes |
N |
Sum(RRORDERS.RepName_rr(),
RRORDERS.CUSTNO, Every composite, Pre-Processed) |
Form Letter with Bursting
Report.RSW |
| CustPctTtl |
Calc |
Yes |
N |
CustOrders / GrnTotOrds |
Form Letter with Bursting
Report.RSW |
| CustRank |
Total |
Yes |
N |
Count(RRCUST.Sls1PrdTot, Grand,
RRORDERS.CUSTNO, Running) |
Form Letter with Bursting
Report.RSW |
| DailyTotal |
Calc |
Yes |
N |
Sls5DayTot + Sls4DayTot + Sls3DayTot +
Sls2DayTot + Sls1DayTot |
Cross Tabulation Report.RSW |
| Date_rr |
Calc |
Yes |
D |
Date() |
Basic Columnar Report.rsw |
| Date_rr |
Calc |
Yes |
D |
DATE() |
Catalog with Variable
Graphics.RSW |
| Date_rr |
Calc |
Yes |
D |
DATE() |
Cross Tabulation Report.RSW |
| Date_rr |
Calc |
Yes |
D |
date() |
Grouped Columnar Report.rsw |
| Date_rr |
Calc |
Yes |
D |
DATE() |
Multi-Line Columnar Report.rsw |
| Date_rr |
Calc |
Yes |
D |
DATE() |
Sales by Salesperson Report.RSW |
| EndDate |
Param |
Yes |
D |
{01/31/2001} |
Sales by Salesperson Report.RSW |
| EndofYear |
Calc |
Yes |
D |
CtoD("12/31/" + Str(SalesYear, 4,
0)) |
Form Letter with Bursting
Report.RSW |
| EvenProdNo |
Calc |
Yes |
L |
Mod(Val(PROD_CODE), 2) = 0 |
Catalog with Variable
Graphics.RSW |
| final |
Total |
Yes |
N |
Sum(RRORDERS.Date_rr(), Grand,
RRORDERS.CUSTNO, Running) |
Summary Columnar Report.rsw |
| FLAG |
Calc |
Yes |
C |
IIF(qty_sum<100, "Low volume customer.
Review discount offered.","") |
Summary Columnar Report.rsw |
| Greeting |
Calc |
Yes |
C |
"Dear " + TITLE - " " + LAST_NAME -
"," |
Form Letter with Bursting
Report.RSW |
| GrnTotOrds |
Total |
Yes |
N |
Sum(RRORDERS.RepName_rr(), Grand, Every
composite, Pre-Processed) |
Form Letter with Bursting
Report.RSW |
| GrpLvl1 |
Calc |
Yes |
N |
Case(SlsDispLvl, "D", OrderYear, "M",
OrderYear, "Y", OrderYear, OrderDay) |
Cross Tabulation Report.RSW |
| GrpLvl2 |
Calc |
Yes |
N |
Case(SlsDispLvl, "D", OrderMonth, "M",
OrderMonth, "Y", OrderYear, OrderDay) |
Cross Tabulation Report.RSW |
| GrpLvl3 |
Calc |
Yes |
N |
Case(SlsDispLvl, "D", OrderDay, "M",
OrderMonth, "Y", OrderYear, OrderDay) |
Cross Tabulation Report.RSW |
| IF_CODE |
Calc |
Yes |
C |
IIF(COUNTRY="",CODE,"") |
Mailing Labels Report.rsw |
| IF_STATE |
Calc |
Yes |
C |
IIF(COUNTRY="",STATE,COUNTRY) |
Mailing Labels Report.rsw |
| item_tot |
Total |
Yes |
N |
Sum(RRITEMS.Sls5PrdTot, RRORDERS.data,
Every composite, Running) |
Summary Columnar Report.rsw |
| large_amt |
Total |
Yes |
N |
Maximum(RRORDERS.Date_rr(), Grand,
RRORDERS.CUSTNO, Running) |
Summary Columnar Report.rsw |
| large_qty |
Total |
Yes |
N |
Maximum(RRPRICES.PROD_NAME, Grand,
RRORDERS.CUSTNO, Running) |
Summary Columnar Report.rsw |
| MthlyTotal |
Calc |
Yes |
N |
Sls5MthTot + Sls4MthTot + Sls3MthTot +
Sls2MthTot + Sls1MthTot |
Cross Tabulation Report.RSW |
| NextYear |
Calc |
Yes |
N |
OrderYear + 1 |
Form Letter with Bursting
Report.RSW |
| NO_PRINT |
Calc |
Yes |
L |
.f. |
Sales by Salesperson Report.RSW |
| NxtYrDisc |
Calc |
Yes |
N |
Round(Max((CustPctTtl * 3) - 0.12, 0),
2) |
Form Letter with Bursting
Report.RSW |
| ORD_TOT |
Total |
Yes |
N |
Sum(RRORDERS.Amount(), RRORDERS.CUSTNO,
Every composite, Running) |
Basic Columnar Report.rsw |
| order_gran |
Total |
Yes |
N |
Sum(RRITEMS.Sls5PrdTot, Grand, Every
composite, Running) |
Summary Columnar Report.rsw |
| ORDER_SUM |
Total |
Yes |
N |
Sum(RRORDERS.ORD_TOT(), Grand,
RRORDERS.CUSTNO, Running) |
Basic Columnar Report.rsw |
| order_tot |
Calc |
Yes |
N |
PROD_PRICE * QUANTITY |
Grouped Columnar Report.rsw |
| order_tot |
Calc |
Yes |
N |
PROD_PRICE * RRITEMS.item_tot |
Summary Columnar Report.rsw |
| OrderBegDt |
Param |
Yes |
D |
{01/01/2002} |
Basic Columnar Report.rsw |
| OrderDay |
Calc |
Yes |
N |
Day(ORDRDATE) |
Cross Tabulation Report.RSW |
| OrderEndDt |
Param |
Yes |
D |
{12/31/2003} |
Basic Columnar Report.rsw |
| OrderMonth |
Calc |
Yes |
N |
Month(ORDRDATE) |
Cross Tabulation Report.RSW |
| ORDERTOT |
Calc |
Yes |
N |
QUANTITY * PROD_PRICE |
Form Letter with Bursting
Report.RSW |
| OrderYear |
Calc |
Yes |
N |
Year(ORDRDATE) |
Cross Tabulation Report.RSW |
| OrderYear |
Calc |
Yes |
N |
Year(ORDRDATE) |
Form Letter with Bursting
Report.RSW |
| Page_rr |
Calc |
Yes |
N |
Page() |
Basic Columnar Report.rsw |
| Page_rr |
Calc |
Yes |
N |
PAGENO() |
Catalog with Variable
Graphics.RSW |
| Page_rr |
Calc |
Yes |
N |
PAGENO() |
Cross Tabulation Report.RSW |
| Page_rr |
Calc |
Yes |
N |
PAGENO() |
Grouped Columnar Report.rsw |
| Page_rr |
Calc |
Yes |
N |
PAGENO() |
Multi-Line Columnar Report.rsw |
| Page_rr |
Calc |
Yes |
N |
PAGENO() |
Sales by Salesperson Report.RSW |
| PerBegDt |
Param |
Yes |
D |
{01/01/2002} |
Grouped Columnar Report.rsw |
| PerEndDt |
Calc |
Yes |
D |
AddMons(PerBegDt, PerTrans) |
Grouped Columnar Report.rsw |
| PerTrans |
Calc |
Yes |
N |
Case(RptgPer, "M", 1, "Q", 3, "S", 6,
"Y", 12, 3) |
Grouped Columnar Report.rsw |
| PROD_QTY |
Total |
Yes |
N |
Sum(RRITEMS.QUANTITY, RRORDERS.CUSTNO,
Every composite, Running) |
Basic Columnar Report.rsw |
| ProdAmtTot |
Total |
Yes |
N |
Sum(RRORDERS.CUST_NO, RRORDERS.CUSTNO,
Every composite, Running) |
Grouped Columnar Report.rsw |
| ProdDesc |
Calc |
Yes |
M |
Case(PROD_CODE, "901", data, "902", spsh,
"903", word, "904",draw, "905",proj, "906",publ,
"907",comm, "908",util, "909",dvlp, dvlp) |
Catalog with Variable
Graphics.RSW |
| ProdQtyTot |
Total |
Yes |
N |
Sum(RRCUST.Sls1PrdTot, RRORDERS.CUSTNO,
Every composite, Running) |
Grouped Columnar Report.rsw |
| ProdTotal |
Calc |
Yes |
N |
Sls5PrdTot + Sls4PrdTot + Sls3PrdTot +
Sls2PrdTot + Sls1PrdTot |
Cross Tabulation Report.RSW |
| qty_sum |
Total |
Yes |
N |
Sum(RRITEMS.QUANTITY, Grand, Every
composite, Running) |
Basic Columnar Report.rsw |
| qty_sum |
Total |
Yes |
N |
Sum(RRITEMS.ORDER_NO, RRORDERS.CUSTNO,
RRORDERS.data, Running) |
Summary Columnar Report.rsw |
| Repname_rr |
Calc |
Yes |
C |
REPNAME() |
Cross Tabulation Report.RSW |
| Repname_rr |
Calc |
Yes |
C |
RepName() |
Grouped Columnar Report.rsw |
| Repname_rr |
Calc |
Yes |
C |
Repname() |
Multi-Line Columnar Report.rsw |
| Repname_rr |
Calc |
Yes |
C |
REPNAME() |
Sales by Salesperson Report.RSW |
| RepName_rr |
Calc |
Yes |
C |
RepName() |
Basic Columnar Report.rsw |
| RptgPer |
Param |
Yes |
C |
"Q" |
Grouped Columnar Report.rsw |
| SaleAmount |
Calc |
Yes |
N |
QUANTITY * PROD_PRICE |
Cross Tabulation Report.RSW |
| SalesName |
Calc |
Yes |
C |
SALEFNAME - " " + SALELNAME |
Form Letter with Bursting
Report.RSW |
| SalesName |
Calc |
Yes |
C |
SALELNAME - ", " + SALEFNAME |
Grouped Columnar Report.rsw |
| SalesYear |
Param |
Yes |
N |
2002 |
Form Letter with Bursting
Report.RSW |
| SCANEDU |
Calc |
Yes |
L |
scantbl="SCANEDU" |
Sales by Salesperson Report.RSW |
| ShoAnn3 |
Calc |
Yes |
L |
SlsDispLvl = "Y" |
Cross Tabulation Report.RSW |
| ShoDay3 |
Calc |
Yes |
L |
SlsDispLvl = "D" |
Cross Tabulation Report.RSW |
| ShoMth3 |
Calc |
Yes |
L |
SlsDispLvl = "M" |
Cross Tabulation Report.RSW |
| Sls1DayTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.GrpLvl3, Every composite, Pre-Processed, If
SALESPERSO = 101) |
Cross Tabulation Report.RSW |
| Sls1MthTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(), RRORDERS.data,
Every composite, Pre-Processed, If SALESPERSO = 101) |
Cross Tabulation Report.RSW |
| Sls1PrdTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRPRICES.PROD_NAME, Every composite, Running, If
SALESPERSO = 101) |
Cross Tabulation Report.RSW |
| Sls1YrTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.CUSTNO, Every composite, Pre-Processed, If
SALESPERSO = 101) |
Cross Tabulation Report.RSW |
| Sls2DayTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.GrpLvl3, Every composite, Pre-Processed, If
SALESPERSO = 176) |
Cross Tabulation Report.RSW |
| Sls2MthTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(), RRORDERS.data,
Every composite, Pre-Processed, If SALESPERSO = 176) |
Cross Tabulation Report.RSW |
| Sls2PrdTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRPRICES.PROD_NAME, Every composite, Running, If
SALESPERSO = 176) |
Cross Tabulation Report.RSW |
| Sls2YrTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.CUSTNO, Every composite, Pre-Processed, If
SALESPERSO = 176) |
Cross Tabulation Report.RSW |
| Sls3DayTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.GrpLvl3, Every composite, Pre-Processed, If
SALESPERSO = 213) |
Cross Tabulation Report.RSW |
| Sls3MthTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(), RRORDERS.data,
Every composite, Pre-Processed, If SALESPERSO = 213) |
Cross Tabulation Report.RSW |
| Sls3PrdTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRPRICES.PROD_NAME, Every composite, Running, If
SALESPERSO = 213) |
Cross Tabulation Report.RSW |
| Sls3YrTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.CUSTNO, Every composite, Pre-Processed, If
SALESPERSO = 213) |
Cross Tabulation Report.RSW |
| Sls4DayTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.GrpLvl3, Every composite, Pre-Processed, If
SALESPERSO = 435) |
Cross Tabulation Report.RSW |
| Sls4MthTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(), RRORDERS.data,
Every composite, Pre-Processed, If SALESPERSO = 435) |
Cross Tabulation Report.RSW |
| Sls4PrdTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRPRICES.PROD_NAME, Every composite, Running, If
SALESPERSO = 435) |
Cross Tabulation Report.RSW |
| Sls4YrTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.CUSTNO, Every composite, Pre-Processed, If
SALESPERSO = 435) |
Cross Tabulation Report.RSW |
| Sls5DayTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.GrpLvl3, Every composite, Pre-Processed, If
SALESPERSO = 760) |
Cross Tabulation Report.RSW |
| Sls5MthTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(), RRORDERS.data,
Every composite, Pre-Processed, If SALESPERSO = 760) |
Cross Tabulation Report.RSW |
| Sls5PrdTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRPRICES.PROD_NAME, Every composite, Running, If
SALESPERSO = 760) |
Cross Tabulation Report.RSW |
| Sls5YrTot |
Total |
Yes |
N |
Sum(RRORDERS.SaleAmount(),
RRORDERS.CUSTNO, Every composite, Pre-Processed, If
SALESPERSO = 760) |
Cross Tabulation Report.RSW |
| SlsAmtTot |
Total |
Yes |
N |
Sum(RRORDERS.ORD_TOT(), RRORDERS.data,
Every composite, Running) |
Grouped Columnar Report.rsw |
| SlsDispLvl |
Param |
Yes |
C |
'M' |
Cross Tabulation Report.RSW |
| SlsQtyTot |
Total |
Yes |
N |
Sum(RRCUST.Sls1PrdTot, RRORDERS.data,
Every composite, Running) |
Grouped Columnar Report.rsw |
| small_amt |
Total |
Yes |
N |
Minimum(RRORDERS.Date_rr(), Grand,
RRORDERS.CUSTNO, Running) |
Summary Columnar Report.rsw |
| small_qty |
Total |
Yes |
N |
Minimum(RRPRICES.PROD_NAME, Grand,
RRORDERS.CUSTNO, Running) |
Summary Columnar Report.rsw |
| sysdate |
Calc |
Yes |
D |
DATE() |
Summary Columnar Report.rsw |
| Time_rr |
Calc |
Yes |
C |
Time() |
Basic Columnar Report.rsw |
| Time_rr |
Calc |
Yes |
C |
TIME() |
Cross Tabulation Report.RSW |
| Time_rr |
Calc |
Yes |
C |
Time() |
Grouped Columnar Report.rsw |
| Time_rr |
Calc |
Yes |
C |
Time() |
Multi-Line Columnar Report.rsw |
| Time_rr |
Calc |
Yes |
C |
TIME() |
Sales by Salesperson Report.RSW |
| TOTCOURSE |
Total |
Yes |
N |
Count(RRORDERS.CUST_NO, RRORDERS.CUSTNO,
Every composite, Running) |
Sales by Salesperson Report.RSW |
| TOTORDER |
Total |
Yes |
N |
Count(RRORDERS.IMAGE_LOC,
RRORDERS.CUSTNO, Every composite, Running, If
.not.SCANEDU) |
Sales by Salesperson Report.RSW |
| TotPages |
Calc |
Yes |
N |
LASTPAGE() |
Basic Columnar Report.rsw |
Total of 68 Calculated, 8 ParameteRR and 44 Total
fields
|
