Strange cross-databases connection in Segate Crystal Reports

[RL624]

CREATE PROCEDURE dbo.dt_po
AS
SELECT JPUS.dbo.POP10110.PONUMBER AS PONUMBER,
JPUS.dbo.POP10110.ORD AS ORD,
JPUS.dbo.POP10110.ITEMNMBR AS ITEMNUMBER,
JPUS.dbo.POP10110.ITEMDESC AS ITEMDESCRIPTION,
JPUS.dbo.POP10110.VENDORID AS VENDORID,
JPUS.dbo.POP10110.QTYORDER AS QTYORDER,
JPUS.dbo.POP10110.PRMSHPDTE AS PRMSHPDTE,
JPUS.dbo.POP10110.REQDATE AS REQDATE,
JPUS.dbo.POP10110.UNITCOST AS UNITCOST,
JPUS.dbo.POP10110.EXTDCOST AS EXTCOST,
JPUS.dbo.POP10100.USER2ENT AS CONTACT,
JPUS.dbo.POP10100.PYMTRMID AS PAYMETHOD,
JPUS.dbo.PM00200.VENDNAME AS VENDORNAME,
JPUS.dbo.PM00200.VNDCNTCT AS VENDORCONTACT,
JPUS.dbo.PM00200.ADDRESS1 AS STREET,
JPUS.dbo.PM00200.CITY AS CITY,
JPUS.dbo.PM00200.STATE AS STATE,
JPUS.dbo.PM00200.ZIPCODE AS ZIP,
JPUS.dbo.PM00200.PHNUMBR1 AS PHONE,
JPUS.dbo.PM00200.FAXNUMBR AS FAX,
JPUS.dbo.PM00200.SHIPMTHD AS SHIPMETHOD,
dbo.tblPoFile.FILENUMBER AS FILENUMBER,
dbo.GP6purline.application AS APP,
dbo.GP6purline.manufacturer AS MANUF,
dbo.GP6purline.tagNumber AS TAGNUMBER,
dbo.GP6purline.inspector AS INSPECTOR,
dbo.GP6purline.inspection_date AS INSPECTIONDATE,
dbo.GP6purline.condition AS CONDITION,
DYNAMICS.dbo.SY01400.USERID AS USERID,
DYNAMICS.dbo.SY01400.USERNAME AS USERNAME
FROM JPUS.dbo.POP10110 FULL JOIN JPUS.dbo.POP10100 ON JPUS.dbo.POP10110.PONUMBER = JPUS.dbo.POP10110.PONUMBER
FULL JOIN DYNAMICS.dbo.SY01400 ON JPUS.dbo.POP10100.USER2ENT = DYNAMICS.dbo.SY01400.USERID
FULL JOIN dbo.tblPoFile ON JPUS.dbo.POP10100.PONUMBER = dbo.tblPoFile.PONUMBER
FULL JOIN dbo.GP6purline ON dbo.tblPoFile.PONUMBER = dbo.GP6purline.docNumber
FULL JOIN JPUS.dbo.PM00200 ON JPUS.dbo.POP10110.VENDORID = JPUS.dbo.PM00200.VENDORID
GO
I am trying to establish a cross-databases(3) connection in Crystal Reports using the above Stored Procedure. The werid part is that, only the fields from both tblPoFile and GP6purline won't show in the result query. These two tables(tblPoFile, GP6purline) are from another database which is different from other two (K, JPUS, DYNAMICS). I can get datat from JPUS and DYNAMICS databases at the same time dynamically, but I just can't get data from K database with the key filed match in other two databases. What seems to be the problem?? Thanks for any of your ideas or opinion....