If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Memo field

running crystal 2008
using maximo as my database
my problem is my report I am can get the memo field to show up not issues my problem is when the memo field has no data in it (blank) the line item does not show up.

I cut alot of data out of my report to get rid of possible errors and get to the meet of the report
here is the sql statement. I have tried left outer join but that gives me a failure - when the ld.text is in the report i get only line items that have a ld.text. but I want all items w/ or without ld.text in the long description
SELECT "POLINE"."PONUM", "POLINE"."POLINENUM",
"POLINE"."DESCRIPTION",
"LONGDESCRIPTION"."LDTEXT"
FROM "MAXIMO"."POLINE" "POLINE",
"MAXIMO"."LONGDESCRIPTION" "LONGDESCRIPTION"
WHERE ("POLINE"."LDKEY"="LONGDESCRIPTION"."LDKEY") AND "POLINE"."PONUM"='3386-053'