Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Figuring out table joins

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
dukeslater
Basic Member
Posts: 9
Basic Member
11/29/2010 3:30 PM
    Trying to replicate Crystal report that uses Object Services but using a command object instead. Here's the ado code:

    dmeROD=WEBUSER.PRODLINE&FILE=PORECLINE&FIELD=DESCRIPTION;ENT-REC-QTY;ENT-REC-UOM;ITEM;MANUF-ID;MANUF-NBR;MMDIST.ACCOUNT;MMDIST.ACCT-UNIT;POLINE.ENT-UNIT-CST;POLINE.EXTENDED-AMT;POLINE.VEN-ITEM;REC-DATE;VENDOR;VENDOR.VENDOR-VNAME;VEN-ITEM;POLINE.QUANTITY&SELECT=MMDIST.ACCT-UNIT%3E%3D4410000%26MMDIST.ACCT-UNIT%3C%3D4419999%26REC-DATE%3E%3D01%2f01%2f08&OTM=1&OTMMAX=639&_CMDTYPE=CGI


    This is a simple report showing PO receipts - I know I need POLINE, PORECLINE, APVENMAST, and MMDIST. The problem is that the accounting unit value comes from the MMDIST table, but I'm not seeing how to join that to any of the other tables. Any assistance in defining these joins is appreciated, or any help in decoding the Object Services query.
    Ruma Malhotra
    Veteran Member
    Posts: 412
    Veteran Member
    11/29/2010 8:01 PM
      What you are using is add-ins in Lawson where the relationships are predefined. If you want to recreate this report you would have to go through the lawson joins defined for each table. The ERDs(Entity Relatioship Diagram) site on this forum describes each table and how the different tables are joined.