Hi,

Is there any provision that i can incorporte the below query in Cryatal reports with just using tables (i.e, not using command line or stored procedure).

Please find the query----------
-------------------------------
SELECT DISTINCT
          ISNULL(P.U_city, '')+ ' ' + ISNULL(P.U_state, ''),
          ISNULL(P.[name], ''),
          ISNULL(TL.empName,''),
          ISNULL(STL.empName,'')
FROM               [Plan]                    P
LEFT OUTER JOIN (SELECT empName,planId,PositionName FROM V_teamLeaders_1 WHERE PositionName LIKE 'Team Leader') TL ON P.planId = TL.placeId
LEFT OUTER JOIN (SELECT empName,planId,PositionName FROM V_teamLeaders_1 WHERE PositionName LIKE 'Site Team Leader') STL ON P.planId = STL.planId

Thanks in advance,

Edited by pparukola - 30 Dec 2009 at 2:41am