Greetings,
Basics: Using OLE DB and accessing Lawson tables for a Crystal Report. Windows, Lawson 9, CR2008 SP2. From within CR I open the database expert, add command, alias the tables I need, pick the fields...then go on to the next table. Total joins=4 on 5 tables, all left outer joins with ACTRANS as the 'master'.
I'm trying to pull information for budget details based on activities and need to join ACBUDDTL and ACTRANS...and I need all activities from both tables, so need a full outer join...which is not supported under DME as I understand it. What are my options to pull all the columns/fields I need from both tables?
Thanks,
Darin
My guess from your description of the problem you are having is that if the activity in question has no transactions posted to it (ACTRANS) then you are not pulling your budget information across (ACBUDDTL). What I would suggest is that you may want to start with the ACACTIVITY table and join both ACTRANS and ACBUDDTL to it.
Great idea! I had gotten so far down the rabbit hole on this that I forgot there was another way to get to the info. I'll certainly try this on Monday & post results.