Cross-reference Database Links

The database links (i.e. joins or relations) documented below are used in the following reports:

  1. Basic Columnar Report.rsw
  2. Catalog with Variable Graphics.RSW
  3. Cross Tabulation Report.RSW
  4. Export Report.RSW
  5. Form Letter with Bursting Report.RSW
  6. Grouped Columnar Report.rsw
  7. Mailing Labels Report.rsw
  8. Multi-Line Columnar Report.rsw
  9. Sales by Salesperson Report.RSW
  10. Summary Columnar Report.rsw
To Table From Table From Field Link Type To Field Match Length Failure Action Report
rrcust rrorders CUSTNO Join = CUST_NO Skip Basic Columnar Report.rsw
rrcust rrorders CUSTNO Join = CUST_NO Skip Form Letter with Bursting Report.RSW
rrcust RRORDERS CUSTNO Join = CUST_NO Skip Grouped Columnar Report.rsw
RRCUST RRORDERS CUSTNO Join = CUST_NO Skip Summary Columnar Report.rsw
rritems rrorders ORDNO Join = ORDER_NO Skip Basic Columnar Report.rsw
rritems rrorders ORDNO Join = ORDER_NO Skip Cross Tabulation Report.RSW
RRITEMS RRORDERS ORDNO Join = ORDER_NO Skip Grouped Columnar Report.rsw
RRITEMS RRORDERS ORDNO Join = ORDER_NO Skip Summary Columnar Report.rsw
rrorders rritems ORDER_NO Join = ORDNO Skip Form Letter with Bursting Report.RSW
rrprices rritems PRODUCT_NO Join = PROD_CODE Skip Basic Columnar Report.rsw
rrprices rritems PRODUCT_NO Join = PROD_CODE Skip Cross Tabulation Report.RSW
rrprices rritems PRODUCT_NO Join = PROD_CODE Skip Form Letter with Bursting Report.RSW
RRPRICES RRITEMS PRODUCT_NO Join = PROD_CODE Skip Grouped Columnar Report.rsw
RRPRICES RRITEMS PRODUCT_NO Join = PROD_CODE Skip Summary Columnar Report.rsw
rrslsemp rrorders SALESPERSO Join = SALESNO Skip Cross Tabulation Report.RSW
rrslsemp rrorders SALESPERSO Join = SALESNO Skip Form Letter with Bursting Report.RSW
rrslsemp RRORDERS SALESPERSO Join = SALESNO Skip Grouped Columnar Report.rsw

Prepared on: 2006-04-25 at 17:54:03
*Note: Joins in User-SQL reports are not included. Match Length applies only to R&R Xbase relations on character fields.