Data Dictionary Table Pairs Supplement
Contents
1. i s sS S S Non Matched Skip controlingrecord Match Type E Match Length 0 Help Remove Edit Close Join Parameters Tab Link Type Description for the coded value of link methodology for the table pair Description Coded Value Exact Lookup E Scan 1 many R Approximate Failure Action Description for the coded value for the action R amp R takes if it is unable to achieve a link between records in the two tables Description Coded Value Related Blank B Skip Controlling S Terminate run T R amp R ReportWorks Infinity Edition Page 11 R amp R Data Dictionary Table Pairs Supplement User Manual Match Type Description for the coded value of a character based match between the controlling table field value and the index key value Description Coded Value Full entire value F Partial first n positions P Match Length The number of character positions of the index key that the controlling field value must match Egtable Pair Join Detail xBase x Controlling Table RRITEMS DBF Related Table RRPRICES DBF Generalinfo doin Method oin Parameters C Usage amp Notes Usage E Notes a Help Remove Edit Close Usage Notes Tab Usage Available for editing Free text field of 250 characters to briefly describe typical usage for this table pair Text will word wrap and the box can be scrolled Notes Available for editing Memo field for unlimited desc2. cataloging your application s data table and fields You could add descriptions and other information to those tables and fields through R amp R s Data Dictionary Editor module Data dictionary table pairs operate differently R amp R does not automatically catalog joins as they are defined in Report Designer R amp R doesn t do so because a join defined during report creation may not reflect the actual join specifications one would want added to the table pairs data dictionary Instead since R amp R catalogs to Report Librarian each report s contents when the report is saved and that cataloging includes table joins R amp R s Data Dictionary module relies on the join data saved in Report Librarian From the Maintenance and Utilities menu in Data Dictionary Editor we have added a button named Join Load This button will present a prompting screen to launch a new utility program that reads Report Librarian entries for the selected user and adds them to the that user s data dictionary table pairs database Ef Maintenance and Utilties Help Dict Load If a join in Report Librarian references a data table that is not already in that user s data dictionary the utility will add it to that database but will not incorporate all fields To add all of that data table s field to the data dictionary create a new report within Report Designer that uses that data table as the master table so R amp R will catalog its conten
3. the specified table the other table in the pair Action Buttons Fields Click this button to proceed to the next screen to specify other aspects of the table pair including the fields used to join the Controlling and Related tables See screen below Abort Click this button to stop the process of defining a new table pair and return to the SQL Table Pair Summary screen Ef Add Table Pair Fields Definition SQL i x Controlling LEFT primary field Related RIGHT primary field RRITEMS DBF l RRPRICES DBF IMAGE_LOC ON_HAND PROD_NAME PROD_PRICE Join Type Failure Action E Exact Lookup 1 1 H High approximate L Low approximate Help Details Abort The tables specified as the Controlling left side and Related right side of the table pair are displayed at the top of the screen Primary Fields Select the controlling table field and the related table field that begin the join process If there are additional fields you may specify them on the next screen Join Type Select the method this table pair uses to join from the list of option Failure Action Select the action R amp R will take during the run of a report that uses this join if R amp R is unable to find related records between the tables Action Buttons Details Click this button to view edit the complete specs for the new table pair Abort Click this button to stop the process of adding a new table pair
4. Ef Table Pair Join Detail xBase 4 xj Controlling Table RRITEMS DBF Related Table RRPRICES DBF Dogensa Join Method Join Parameters Usage amp Notes M l ach Controlling Table record might find MANY Related Table record 4 Related Table record may not ex g for each Controlling Table record Application assures Related Table record match integrity Help Remove Edit Close Table Pair Join Detail Screen xBase Controls and Data Elements for Table Pair xBase Detail View Edit Screen The entire window may be moved around the background by clicking and holding the window title bar The window must be closed to view any former window or menu Edit This button allows you to the make changes to the user editable fields for the table pair record When clicked its legend will change to Save and the Close button will change to revert R amp R ReportWorks Infinity Edition Page 9 R amp R Data Dictionary Table Pairs Supplement User Manual Remove This button will only be active for User IDs with administrator rights and then only from Data Dictionary Editor Close This button will exit the screen and return to the Table Pair Summary grid screen Data Elements Controlling Table Name Related Table Name Always visible at the top of the window General Info Tab Join Description User editable brief description for the table pair Natural Relation Select the code value with descript
5. L only RFIELD2 Character 50 Related table second linking field if applicable SQL only RFIELD3 Character 50 Related table third linking field if applicable SQL only XFIELD Character 50 Controlling table linking field xBase only XFORM Character 250 Linking field formula if applicable xBase only RTINDEX Character 15 Related table index file name xBase only RTTAG Character 15 Related table index tag name if applicable xBase only RTKEY Character 200 Index key expression formula xBase only LINKTYPE Character 1 Linking type see manual for coding NATLINK Character 1 Natural relation from controlling table to related table see manual RTRECREQ Logical 1 Flag to indicate if a related table record is required for the pair MATCHTYPE Character 1 Character link match type F full P partial xBase only MATCHLEN Numeric 3 Character link partial match length if applicable xBase only FAILACT Character 1 Failure action if no link possible DESCRIPT Character 100 User maintained description of the table pair USAGE Character 250 User maintained free text explanation of when how to use this join NOTES Memo Memo field for free text unlimited explanation of the table pair R amp R ReportWorks Infinity Edition Page 23
6. R amp R Data Dictionary Table Pairs Supplement User Manual Ef table Pair Join Detail SQL xj Controlling Table RRITEMS DBF Related Table RRORDERS DBF Generalinfo doinFields doin Parameters a sage amp Notes Usage a id Notes a z Help Remove Edit Close Usage Notes Tab Usage Available for editing Free text field of 250 characters to briefly describe typical usage for this table pair Text will word wrap and the box can be scrolled Notes Available for editing Memo field for unlimited description and history of the particular table pair Text will word wrap and the box can be scrolled Adding a Table Pair Entry SQL Clicking the Add button from the SWL Table Pairs Summary will present the screen below to begin the specification of the table pair Efadd Table Pair Definition SQL x Define relation of RRITEMS DBF C As Related Table R amp R sample data customer file R amp R sample data order line items file R amp R sample data order header file R amp R sample data inventory items prices file Fields R amp R ReportWorks Infinity Edition Page 18 R amp R Data Dictionary Table Pairs Supplement User Manual Pair Mode Radio Select the radio button to define the specified table as the Controlling left side table in the pair or as the Related right side table Paired Table Select from the list of tables in the same Data Source as
7. R amp R Data Dictionary Table Pairs Supplement User Manual R amp R ReportWorks Infinity Edition October 2008 Table of Contents IMPFOCUGUION kasa sates tetra eee lcd ced ead ak Wes A a ated 3 Access Data Dictionary Table Pairs 0 eesccccceeeeeeeeeeeeeeeeeeeeeeeeeseneaeeeeeeeeeeeeeeees 5 Initial Population of Data Dictionary Table Pairs c cceceeeeeeeeeeeeeeeeeeeeeeeeeees 6 xBase Table Pairs Screens cccccccceeeeeeeeseeneeeeeeeeeeeeeaeeeeeeeeeeensaeeaaeeeeeeeeeeenaes 8 SOL Tabl PairsS Screens vans varhsenisevs sosdbs ands dndenads dnoccedsssevssenpens 14 Table P airs Report paki h eae tat iliac er rere ea ai aai iaa italia vel 20 Installation Backing Up and Future Upgrades eeeeeeeeeeeeeeeeeeeeeeeeeeneeeeeeees 21 Table Pairs Data Dictionary sn225 cnsitectceceanhaee si nelacidndlandileel ce decethendbeeticeeheabiee vine 23 c 2008 Liveware Publishing Inc All rights reserved R amp R Report Writer is a registered trademark of Liveware Publishing Inc R amp R ReportWorks is a trademark of Liveware Publishing Inc registration pending Computer screen images presented in this document are the property of Liveware Publishing Inc and are covered under copyright Liveware Publishing Inc carries no warranty either express or implied for any use or misuse of the information in this document Windows is a trademark of Microsoft Corporation Other software pr
8. and return to the Table Pairs summary screen R amp R ReportWorks Infinity Edition Page 19 R amp R Data Dictionary Table Pairs Supplement User Manual Table Pairs Dictionary Report We have added a new report to the menu below for a summary of table pairs for a selected table E pata Dictionary Reports x Table Dictionary Calc Fields by Table Index Dictionary User Listing User defined Key List Report Info View a list of Table Pairs for a selected table After selecting the Table Pair Dictionary report file ddpairs rrw from the list and clicking Run you will be presented with the R amp R Runtime prompt screen for the report where you input the table name and indicate whether you want to view notes about the joins ParameteRR Yalue Entry Screen xj m Select the ParameteRR to modify Name Selected data table name Do you want to see index note Yes Current Value Comments Instructions Enter a full data table name with file extension e g DBF if stored that way in the dictionary Selected data table name OOOO OOOK rrr Enter up to 254 characters You do not need to add quotes or delimiters OK Cancel Help R amp R ReportWorks Infinity Edition Page 20 R amp R Data Dictionary Table Pairs Supplement User Manual The report will present all table pairs for the selected table whether it is the Controlling left
9. ents to Librarian or Data Dictionary that require modification of the user maintained data tables these upgrades will include conversion routines that either run automatically upon installation or include a separate utility to move out Librarian Data Dictionary data to the new structures For the current release no such changes are needed At that time instructions and a description of the changes will be provided in the README file accompanying the upgrade R amp R ReportWorks Infinity Edition Page 22 R amp R Data Dictionary Table Pairs Supplement User Manual Table Pairs Data Dictionary Below is a listing of the table pairs data table fields This is for assistance in designing your own reports based on Data Dictionary data DICTPAIR DBF FieldName Type Size Comments TABL_TYPE Character 1 X for xbase dictionary table pairs S for SQL dictionary table pairs CTABLE Character 50 Controlling left side table in the join RTABLE Character 50 Related right side table in the join DATASRC Character 50 ODBC data source name for the table SQL only OWNER Character 10 Data Dictionary User ID owning this table pair record CFIELD1 Character 50 Controlling table first linking field SQL only CFIELD2 Character 50 Controlling table second linking field if applicable SQL only CFIELD3 Character 50 Controlling table third linking field if applicable SQL only RFIELD1 Character 50 Related table first linking field SQ
10. ion adjacent for the natural relation between the tables This represents what one would expect to find under normal circumstances between the controlling table s records and the related table s records This is either 1 1 0 1 many M or 1 maybe 7 Relation assure flag Check the box if the source applications assures inferential integrity between the two tables That is if there will always be a vailid relation between the controlling amp related table records Egtable Pair Join Detail xBase xj Left Controlling Table field JPRODUCT_NO Right Related Table index rrprices IDX Tag Name Linking field formula Index key expression Jprod_code Help Remove Edit Close Join Method Tab Controlling Table field Displays the field name for the controlling table field that is used to start the xBase join Related Table Index Displays the index file name for the related table used in the join R amp R ReportWorks Infinity Edition Page 10 R amp R Data Dictionary Table Pairs Supplement User Manual Tag Name Displays the tag name within the related table index if applicable Linking field formula If the controlling table field is a calculated field its formula is displayed Index key expression Displays the index file tag key formula Eg table Pair Join Detail xBase General Info Join Method Ton Join Parameters Usage amp Notes Link Type Exactor
11. ion programs data structures and your custom reports If you wish to re install to the same directories folders as the original R amp R Report Works installation save the follow Librarian Data Dictionary files to a safe place first REPORTS DBF CDX FPT Main Librarian Catalog data file index and memo files RPTABLES DBF CDX Related Tables data file and index RPTFIELD DBF CDX Report Fields data file and index OWNERS DBF CDX Librarian Data DictionaryUser IDs data file and index DICTTABL DBF CDX FPT Data Dictionary Tables data index and memo files DICTFLD DBF CDX FPT Data Dictionary Fields data index and memo files DICTINDX DBF CDX F PT Data Dictionary Index data index and memo files DICTPAIR DBF CDX FPT New Table Pairs data index and memo files After reinstallation copy these files back to the RL folder and the data will be restored If R amp R is reinstalled to a new directory these data files can be copied from the old RL folder to the new RL folder To make a backup of the Librarian Data Dictionary databases the files listed above are the only ones that undergo changes worth protecting Regular network backups that cover the R amp R folders should be sufficient for most network installations for local installation a periodic copy of these files via Window Explorer to a diskette or another folder will suffice Future Upgrades In the likely event that future R amp R versions includes enhancem
12. ionary Table Pairs Supplement User Manual Accessing R amp R Data Dictionary Table Pairs Table pairs screens are an adjunct to the table detail screens both through the full Data Dictionary Editor and Table View program accessed through Report Designer A button entitled Joins has been added to the table detail screen for the Data Dictionary Editor x Table Detail and Other Information General Info Application Additional Info Notes Table Name RRITEMS DBF Owner ADMIN Directory Description Help Remove Edit Close Similarly for the Table View program the Joins button is on the table detail screen but in a slightly different location Ef Table Detail i Zj Table Name RRITEMS DBF User ID DMN General Info Application Additional Info l Notes Directory Description Help Edit Close R amp R ReportWorks Infinity Edition Page 5 R amp R Data Dictionary Table Pairs Supplement User Manual Initial Population of Data Dictionary Table Pairs All data dictionary files are empty when first installed R amp R populates data dictionary table field and xBase index tables automatically as you select tables indexes for use within Report Designer Data dictionary tablesmay also be pre populated with your application s data dictionary entries if supplied by your application s publisher Therefore as you use R amp R s Report Designer R amp R is
13. le Pairs Help Update Close For both of the items described above the User ID used in Data Dictionary Editor must have administrator rights R amp R ReportWorks Infinity Edition Page 7 R amp R Data Dictionary Table Pairs Supplement User Manual Table Pairs Screens Upon clicking the Joins button from the table detail screen Data Dictionary will present the Join Summary screen for that table as shown below xBase and SQL page 14 present slightly different screens throughout and Data Dictionary will know whether the table in question is referenced from xBase or SQL Report Designer use EgxBase Table Pair Join Summary x xBase Table Pairs C s Contraling Table As Related Table Table Name RRITEMS DBF Owner somn femea poe peronea furktwvoughindex firo macn Je eReRIceS Der e __ PRODUCTNO____revicesiox roriersaot e forono forores fRrercesa fe proue no fress C E a DoS TT Y Y T D O a A DoS TT Y Y T Table Pairs xBase Summary Controls The entire window may be moved around the background by clicking and holding the window title bar The window must be closed to view any former window or menu The Table Name and User ID appear at the top of the grid As Controlling Table Tab This grid on this tab shows the table pairs where the selected Table specified above the grid is the controlling left side table in the join All table pairs appear in alphabetical order not ca
14. mp R ReportWorks Infinity Edition Page 3 R amp R Data Dictionary Table Pairs Supplement User Manual below These Dictionary buttons were added in R amp R ReportWorks Infinity Edition containing Report Designer Runtime v12 21x Master Table x Lookin datai l VK dhelptxt DBF Sa fidload dbf rrsqldct DBF Uiii dbf Fa dictFLo DeF Sh ODecLIsST DeF S4yRRUNOUT DBF acta dbf safe Sh dictindx DBF Sh owners DBF a txtload dbf rrsl semp dbf uploadtst Ya reports DBF treust dbf dcontrol dbf h dicttabl dbf a rptables DBF EART ddstd dbf Shdsnfid DeF Xarptfield DBF rorders dbf rrprices dbf El I Create Report without Master Table File name dictpair dbf OK Cancel Hel Dictionary Help Dictionary 4 SQL Report Designer table selection dialog xBase Report Designer table selection dialog box with new box with new Dictionary button Dictionary button Both Report Designers Dictionary buttons launch a window with the table dictionary information for the selected table provided that R amp R has already cataloged the contents of the table If not R amp R presents a message box indicating so The table detail screens are described in the R amp R Data Dictionary document pages 24 27 One may have more than one table dictionary window open at a time in case a user must reference detail associated with more than one table R amp R ReportWorks Infinity Edition Page 4 R amp R Data Dict
15. ncludes key elements of the table pair See the Table Pair Detail help for explanations Use the scroll bar to view portions of the related table grid The columns may be resized by clicking and holding on the lines to the right of the column headings The grid will return to standard sizes upon screen refresh Click on the record line of the grid to select that table pair Then click the Detail button to view additional information for the selected table pair R amp R ReportWorks Infinity Edition Page 14 R amp R Data Dictionary Table Pairs Supplement User Manual Add Click this button to define a new table pair for the selected table This option is only active in Data Dictionary Editor not Report Designer Table View utility and only for User IDs with Administrator rights Details Click this button to present the Table Pair Detail screen for the index selected in the grid If no table pairs are specified for the table it will be gray Close Click this button to exit the screen and return to the Table Detail screen Table Pair Join Detail Screen SQL Ef Table Pair Join Detail SQL General Info Join Fields Join Parameters Usage amp Notes Join Description Order line item to its order header record Natural Relation fO Each Controlling Table record should always find ONE Related Table record Each Controlling Table record might find MANY Related Table record Related Table record may no
16. od described in the box For adding SQL table pairs the process is much simpler and less robust as well so Data Dictionary Editor does provide a screen to define those table pairs see page 18 but the process described in the notice box is also applicable to SQL table pair definitions as well R amp R ReportWorks Infinity Edition Page 13 R amp R Data Dictionary Table Pairs Supplement User Manual Table Pairs SQL Summary Controls The entire window may be moved around the background by clicking and holding the window title bar The window must be closed to view any former window or menu The Table Name and User ID appear at the top of the grid Egsou Table Pair Join Summary xi SQL Table Pairs As Controlling Table Table Name RRITEMS DBF Owner apna Controlling Table Mode Link from field Link to field lt no match RRORDERS DBF E ORDNO ORDER_NO Details As Controlling Table Tab This grid on this tab shows the table pairs where the selected Table specified above the grid is the controlling left side table in the join All table pairs appear in alphabetical order not case sensitive by related table name As Related Table Tab This grid on this tab shows the table pairs where the selected Table specified above the grid is the controlling right side table in the join All table pairs appear in alphabetical order not case sensitive by controlling table name Table Pair Grid I
17. oducts names mentioned in this volume may be trademarks held by these products publishers and are referred to for indication purposes only R amp R Data Dictionary Table Pairs Supplement User Manual Introduction For nearly all persons new to the concepts and processes associated with report design and creation the topic of how to link one or more data tables to form the required result set is the most difficult concept to master Not only one must have a thorough understanding of one s data structures and table contents but also the minds eye vision to perceive the result of two tables becoming in essence one new table This is true whether the report joins just two tables or many more since each new join one defines is in actuality the joining of the selected table to all of those already bound as a single table Most of the time a table join can be viewed as the link on a common data element from a controlling left side table which has already been specified within the report and the related right side table being added to the report definition All joins within R amp R thus constitute a table pair An end user instructs R amp R to use the contents of the controlling table s data field or fields or in some cases a formula to match the contents of the related table data field or fields and thereby create a new record in the result set comprising the contents of the records from both tables Naturally the
18. on folder DATADICT EXE Data Dictionary Editor application program TBLVIEW EXE Table Dictionary Viewer program called from Report Designer DDPAIRS RRW New R amp R runtime report summarizing table pairs DICTPAIR DBF CDX FPT New Table Pairs data index and memo files DHELPTXT DBF FPT New help screen files for Data Dictionary Editor Table View DDSTD DBF New reports listing for Data Dictionary Editor In all cases it is wise to run the table pairs Join Load utility see page 7 immediately after reinstalling R amp R and copying previous installation Librarian Data Dictionary files or when adding table pairs files to an existing R amp R ReportWorks Infinity installation Reinstallation and Backing Up From time to time it may become necessary to reinstall R amp R due to the license file becoming damaged errors on the disk and similar circumstances If reinstalling to the same directory R amp R will simply overwrite all of the Librarian Data Dictionary files including the New Table Pairs and related programs are not licensed for use with any R amp R version prior to R amp R ReportWorks Infinity and could cause problems if you attempt to use them with any prior version R amp R ReportWorks Infinity Edition Page 21 R amp R Data Dictionary Table Pairs Supplement User Manual new ones for table pairs This is not a good thing since the Catalog would probably contain much critical information about your applicat
19. process is much more complex than that actuating the myriad possibilities a robust reporting tool such as R amp R will address Over the years as R amp R s publishers but also as consultants and trainers to users at all levels we have found that the best way to learn how to join tables for one s application is by learning from previous examples If you re the first one building reports in R amp R and are new to the set of target data tables you would be kind of out of luck But there is always someone who would understand the relationship between data tables better than the trailblazer your system s developer Any party familiar with how tables should link within the system should be able to leave behind a set of instructions breadcrumbs as it were for those who follow them to pick up and learn from That s the concept behind our latest addition to R amp R s Data Dictionary module and it is one we certainly hope our large and dedicated user base and we hope those just finding R amp R will discover as a very useful addition to R amp R s reporting suite This document is a supplement to the standard Data Dictionary help file last published in association with R amp R ReportWorks that contained Report Designer Runtime v11 Since that time the only addition to R amp R s Data Dictionary module functionality has been the program TBLVIEW EXE that launched from the table selection dialog boxes xBase and SQL shown R a
20. ription and history of the particular table pair Text will word wrap and the box can be scrolled R amp R ReportWorks Infinity Edition Page 12 R amp R Data Dictionary Table Pairs Supplement User Manual Adding a Table Pair Entry xBase Clicking the Add button from the xBase Table Pairs Summary will present the following screen with special instructions related to populating xBase table pairs to the R amp R Data Dictionary Ef Recommendation for Adding xBase Table Pairs Adding xBase Table Pairs The best method for populating the xBase Table Pairs table is to do the following 1 Create a report in xBase designer with the controlling table as the master table 2 If necessary define any calculated field that you will need to perform the join 3 Create a new relation using the related table dialog and the applicable prompts Test the join so that you are confident that it is correctly defined Define additional joins within the report as needed 4 Save the report so that Libriarian will catalog its contents 5 Run the Data Dictionary Join Load utility program from the Maintenance menu The process to specify all of the elements of an xBase table pair as R amp R would define it is too complex to present a series of screens with all of the applicable items R amp R s Report Designer module offers a far better method for defining table pairs via its New Relation dialog box so we recommend the meth
21. se sensitive by related table name As Related Table Tab This grid on this tab shows the table pairs where the selected Table specified above the grid is the controlling right side table in the join All table pairs appear in alphabetical order not case sensitive by controlling table name R amp R ReportWorks Infinity Edition Page 8 R amp R Data Dictionary Table Pairs Supplement User Manual Table Pair Grid Includes key elements of the table pair See the Table Pair Detail help for explanations Use the scroll bar to view portions of the related table grid The columns may be resized by clicking and holding on the lines to the right of the column headings The grid will return to standard sizes upon screen refresh Click on the record line of the grid to select that table pair Then click the Detail button to view additional information for the selected table pair Add Click this button to view a screen with instructions on how to add an xBase Table Pair entry by defining it within xBase Report Designer and saving the report This option is only active in Data Dictionary Editor not Report Designer Table View utility and only for User IDs with Administrator rights Details Click this button to present the Table Pair Detail screen for the index selected in the grid If no table pairs are specified for the table it will be gray Close Click this button to exit the screen and return to the Table Detail screen
22. side table or Related right side table and whether that table is used in SQL or xBase joins Installation Table Pairs is anew component of R amp R Data Dictionary and is automatically installed whenever R amp R is installed from the distribution CD or via electronic file distribution When at installation If you already have R amp R v10 0 or later version and you are not installing R amp R ReportWorks Infinity v12 or later on your computer or server allow R amp R to install normally but to a new folder Note you may have to change desktop icons and un install re install workstation setups based on the new R amp R location Then copy these files from your former R amp R v10 0 or later installation REPORTS DBF CDX FPT Main Librarian Catalog data file index and memo files RPTABLES DBF CDX Related Tables data file and index RPTFIELD DBF CDX Report Fields data file and index OWNERS DBF CDX Librarian Data DictionaryUser IDs data file and index DICTTABL DBF CDX FPT Data Dictionary Tables data index and memo files DICTFLD DBF CDX FPT Data Dictionary Fields data index and memo files DICTINDX DBF CDX FPT Data Dictionary Index data index and memo files If you already have R amp R ReportWorks Infinity v12 0 or later installed you do not need to reinstall R amp R to utilize the new table pairs capabilities You only need to copy the following files into the RL folder under your R amp R installati
23. t existing for each Controlling Table record vd Application assures Related Table record match integrity Controls and Data Elements for Table Pair SQL Detail View Edit Screen The entire window may be moved around the background by clicking and holding the window title bar The window must be closed to view any former window or menu Edit This button allow you to the make changes to the user editable fields for the table pair record When clicked its legend will change to Save and the Close button will change to revert Remove This button will only be active for User IDs with administrator rights and then only from Data Dictionary Editor Close This button will exit the screen and return to the Table Pair Summary grid screen R amp R ReportWorks Infinity Edition Page 15 R amp R Data Dictionary Table Pairs Supplement User Manual Data Elements Controlling Table Name Related Table Name Always visible at the top of the window General Info Tab Join Description User editable brief description for the table pair Natural Relation Select the code value with description adjacent for the natural relation between the tables This represents what one would expect to find under normal circumstances between the controlling table s records and the related table s records This is either 1 1 0 1 many S or 1 maybe 7 Relation assure flag Check the box if the source applications assures inferen
24. tial integrity between the two tables That is if there will always be a vailid relation between the controlling amp related table records Ef Table Pair Join Detail SQL General Info OT einFields Join Parameters Usage amp Notes Left Controlling Table Fields Right Related Table Fields ORDER_NO ORDNO Help Remove Edit Close Join Fields Tab First controlling table field and related table field are shown but cannot be changed Second and third fields for both table are shown and may be edited by selecting from the list of fields when editing the table pair R amp R ReportWorks Infinity Edition Page 16 R amp R Data Dictionary Table Pairs Supplement User Manual Ef table Pair Join Detail SQL xj Controlling Table RRITEMS DBF Related Table RRORDERS DBF Generalinfo JoinFietts ein Parameters Usage amp Notes Link Type Exact lookup Non Matched skip controlling record Help Remove Edit Close Join Parameters Tab Link Type Description for the coded value of link methodology for the table pair Description Coded Value Exact Lookup E Approx High H Approx Low L Failure Action Description for the coded value for the action R amp R takes if it is unable to achieve a link between records in the two tables Description Coded Value Skip Controlling S Related Blank R Controlling Blank l R amp R ReportWorks Infinity Edition Page 17
25. ts As with the rest of R amp R s Data Dictionary module each user ID records its own table pairs entries As that User ID is input into Report Librarian and then from there that User ID launches Report Designer Report Designer will reference that User ID s data dictionary entries for tables fields and table pairs and catalog reports and any new tables under that User ID The default Data Dictionary and Librarian User ID is still ADMIN if a user launches Report Designer executables RRW EXE RSW EXE from outside of Report Librarian R amp R ReportWorks Infinity Edition Page 6 R amp R Data Dictionary Table Pairs Supplement User Manual E update Table Pairs Entries from Librarian x Current User ID apna Current User Name fuser Master Update Table Pair entries for User ID komm Help Update Close The pull down list on this screen will show all User IDs as defined within Report Librarian and table pair entries are updated for one User ID at a time Clicking the Update button will begin the table pairs cataloging process Also as with other data dictionary entries table pair entries may be shared among User IDs We have added a button on the Share Dictionary screen see below to update one User s entries to any other user Current User ID apna Current User Name User Master Update data dictionary entries from User ID bora JV Update Indexes JV Update Fields JV Update Tab
Download Pdf Manuals
Related Search