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
|