FMS Query

Dear all,

I have created foll query:

SELECT T0.CARDNAME [CUSTOMER NAME],T0.DOCNUM [INVOICE NO],T0.DOCDATE [INVOICE DATE],

T0.DOCTOTAL [INVOICE AMT],T6.DocDate [INCOMING PAYMENT DATE],

T4.DEPOSDATE [DEPOSIT DATE],

DATEDIFF(DD,T0.DOCDATE,T6.DOCDATE) [REALIZATION DAYS TO WITHOUT PDC],

DATEDIFF(DD,T6.DOCDATE,T4.DEPOSDATE) [REALIZATION DAYS TO WITH PDC],

DATEDIFF(DD,T0.DOCDATE,T4.DEPOSDATE) [TURNAROUND DAYS]

FROM OINV T0

LEFT JOIN RCT2 T5 ON T0.DocEntry = T5.DocEntry

LEFT JOIN ORCT T6 ON T6.DocEntry=T5.DocNum

left JOIN RCT1 T2 ON T2.DOCNUM=T6.DOCNUM

left JOIN OCHH T3 ON T3.Checknum=T2.checknum AND T3.CARDCODE=T0.CARDCODE left JOIN ODPS T4 ON T3.DpstAbs=T4.DeposId

WHERE T0.CARDCODE =[%1] and T0.DOCDATE between [%2] and [%3]

At Parameter screen it will show Cardcode ,From Date and to Date.

When we click on CFL of Cardcode it just showing me cardcode & count. but can we show corresponding Cardname of cardcode.

So user can search Cardname wise.