Hello all, first of all if this topic has already beeing slved, then I'm sorry, but I didn't found it.

I'm trieying to get the Delievery Adress into a Crystal report.

The only thing i can get into this report is the Delivery Adress code, but I need to get it translated into the Name and adress.

I don't get it out of tccom013.

Does anybody have an Idea? Thanks in advance.

OMG, BaaN is a nightmare for getting the Delivery Address because you can have different delivery addresses per line. I created a view to get this info.

If there is a Delivery Address specified on the line it will grab that, and if not it will look for an address on the Order, if not there it will use what is the default in the Customer table

SELECT TOP (100) PERCENT dbo.ttdsls040600.t_orno AS OrderNum, dbo.ttdsls040600.t_cuno AS CustID,
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN 'Use Default Delivery' ELSE 'Use Line Delivery' END) ELSE 'Use Order Delivery' END AS [What Method], dbo.ttdsls041600.t_pono AS Line,
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_nama ELSE [Line Delivery].t_nama END) ELSE [Order Delivery].t_nama END AS Name,
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_namb ELSE [Line Delivery].t_namb END) ELSE [Order Delivery].t_namb END AS Attention,
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_namc ELSE [Line Delivery].t_namc END) ELSE [Order Delivery].t_namc END AS [Address 1],
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_namd ELSE [Line Delivery].t_namd END) ELSE [Order Delivery].t_namd END AS [Address 2],
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_name ELSE [Line Delivery].t_name END) ELSE [Order Delivery].t_name END AS [City State Zip],
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_namf ELSE [Line Delivery].t_namf END) ELSE [Order Delivery].t_namf END AS Email,
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_pstc ELSE [Line Delivery].t_pstc END) ELSE [Order Delivery].t_pstc END AS Postal,
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN [Specific Addresses].t_ccty ELSE [Line Delivery].t_ccty END) ELSE [Order Delivery].t_ccty END AS Country,
CASE WHEN ttdsls040600.t_cdel = '' THEN (CASE WHEN ttdsls041600.t_cdel = '' THEN LEFT([Specific Addresses].t_pstc, 5) ELSE LEFT([Line Delivery].t_pstc, 5) END) ELSE LEFT([Order Delivery].t_nama, 5) END AS [ZIP 5]
FROM dbo.ttccom010600 AS [Default Delivery] RIGHT OUTER JOIN
dbo.ttdsls041600 INNER JOIN
dbo.ttdsls040600 ON dbo.ttdsls041600.t_orno = dbo.ttdsls040600.t_orno LEFT OUTER JOIN
(SELECT t_orno, t_nama, t_namb, t_namc, t_namd, t_name, t_namf, t_ccty, t_fovn, t_lvdt, t_pstc, t_cadr, t_crte, t_trtm, t_geoc_l, t_Refcntd, t_Refcntu
FROM dbo.ttdsls042600
WHERE (t_pono = 0)) AS [Specific Addresses] ON dbo.ttdsls040600.t_orno = [Specific Addresses].t_orno LEFT OUTER JOIN
dbo.ttccom013600 AS [Order Delivery] ON dbo.ttdsls040600.t_cuno = [Order Delivery].t_cuno AND dbo.ttdsls040600.t_cdel = [Order Delivery].t_cdel ON [Default Delivery].t_cuno = dbo.ttdsls040600.t_cuno LEFT OUTER JOIN
dbo.ttccom013600 AS [Line Delivery] ON dbo.ttdsls041600.t_cuno = [Line Delivery].t_cuno AND dbo.ttdsls041600.t_cdel = [Line Delivery].t_cdel