locked
How to link tables(primary and Secondary tables) in Visual Linking Expert if value in secondary table is null or mismatches

    Question

  •  

    Hello,

     

    How to link tables(primary and Secondary tables) in Visual Linking Expert if value in secondary table is null or mismatches value in primary table AND display record in crystal report.

     

    my table tPLM_Master structure:
    PLM_Reference_ID PLM_Ref_Number PLM_CreatedDate PLM_ClosedDate PLM_JobNumber PLM_SubJobNumber PLM_Status PLM_Status_ID
           
    1 STOPLM000108 3/8/2008 0:00 3/8/2008 0:10 - N/A - - N/A - CANCELLED 3
    2 MISPLM000208 3/8/2008 9:14 NULL AU04    1 OPEN 1


    This Status_ID will be '1' if there is no PLM_ClosedDate (i.e., Status is 'OPEN')...else it will be 'CLOSED' or 'CANCELLED'.

    Here i am displaying records for Closed / cancelled, so i have this in my record selection formula.,
    {tPLM_Master.PLM_ClosedDate} IN {?Period}

    There are four tables, i linked In Visual Linking Expert. they are:
    *. PLM_Master (my master table , whose values to be displayed in crystalreport).
    *. PLM_Events (PLM_Master table and PLM_Events is linked with PLM_Ref_Number..so no issues here).
    *. vPLM_PR350100 (This has first column FNProjectNO. I linked this with PLM_JobNumber..
    *. vSCA_PL010100 (This table has a column named 'SupplierCode' which i have linked with 'PLM_SupplierCode' in my tPLM_Master table.).

    Now when u see in my table(refer tPLM_Master structure at the top), u ll notice that 'PLM_JobNumber' for "PLM_Reference_ID = 1" is "- N/A -" which does not match with values in FNProjectNO column of vPLM_PR350100 table ...

    My query is
    *. How to link two tables if value in one table (secondary table) is null / does not match.
    *. Here i want to display the record in crystal report (from tPLM_Master structure (PLM_Reference_ID = '1') even though PLM_JobNumber is '- N/A -' and doesnt match its primary source (vPLM_PR350100).


    hope ur clear and got my qn right..

    In my record selection formula, i have
    {tPLM_Master.PLM_ClosedDate} = {?Period} AND
    {vSCA_PL010100.SupplierCode} LIKE {?Supplier Code} AND
    {vPLM_PR350100.FNProjectNo} LIKE {?Project No}

    I have 3 parameters field,
    ?Period - which asks for start date and closed date,
    ?Supplier Code - which asks for a supplier code , * - is default (default selects all values)
    ?Project No - which asks for a Project No , * - is default (default selects all values)

    Thanks to help.

    Sunday, March 09, 2008 12:05 PM