• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Figuring out table joins

 1 Replies
 0 Subscribed to this topic
 24 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:

dme:PROD=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.