How to display same item in a different line in Crystal Report

[former_member320372]

Hi All,

           There is some process we have in Subcontract purpose. So when we have place the inventory transfer, We separate as two line item for  a single item. For Ex. Item code 10001.

           We put inventory transfer for this material in,

                                                                                      line one 10001 - 1 QTY

                                                                                      line two 10001 - 1 QTY.

But in crystal report in doesn't show as two item.It just showing as a single item with single QTY. I want to print as two line item with respective QTY.

Cheers!

Prabakaran R

[kothandaraman_nagarajan]

Hi,

Please post complete query here to check.

Thanks

[former_member320372]

Hi,

           This is my Query,

SELECT T0.[DocNum],T0.[DocDate],T0.[DocDueDate], T0.[CardName], T0.[Address2],t0.Address, T0.[NumAtCard],

t1.PriceBefDi,

T0.[BPLId],T0.[U_BPNAME],T0.[DocTotal],T1.[Dscription],T1.[BaseAtCard], T1.[Quantity],T2.PymntGroup,

isnull(T0.[U_Despatchedthrough],'')Despatched,T0.[U_Destination],

-- (SELECT TOP 1 R.DocDate FROM  wtr1 D ON D.BASEENTRY=R.DOCENTRY

--WHERE D.DocEntry =D.BaseEntry) 'ORDER DATE',

--(select isnull(SUM(I.TaxSum),0) from dln4 i where i.DocEntry =t0.DocEntry  and i.staType=-90)BED12 ,

-- (select top 1 i.TaxRate from dln4 i where i.DocEntry =t0.DocEntry  and i.staType=-90)BED12Rate ,

--(select isnull(SUM(I.TaxSum),0) from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=-60)ECESS,

--(select top 1 i.TaxRate from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=-60)ECESSrate,

--(select isnull(SUM(I.TaxSum),0) from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=-55)HSC,

-- (select top 1 i.TaxRate from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=-55)HSCRate,t1.unitmsr,

--(select isnull(SUM(I.TaxSum),0) from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=4)CST

--,(select top 1 i.TaxRate from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=4)cstrate,

--(select isnull(SUM(I.TaxSum),0) from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=1)VAT

--,(select top 1 i.TaxRate from DLN4 i where i.DocEntry =t0.DocEntry  and i.staType=1)cstVrate,

--(select isnull(SUM(I.TaxSum),0) from DLN4 i where i.DocEntry =t0.DocEntry)TAXAMOUNT ,

--(select top 1 Weight from dln7 d where d.DocEntry =t0.DocEntry )weight,

--(select top 1 PackageNum from dln7 d where d.DocEntry =t0.DocEntry )'package no',

(SELECT TOP 1 C.TaxId0 FROM CRD7 C inner join ocrd t0 on c.cardcode =t0.cardcode) 'PAN',

(SELECT TOP 1 C.TaxId1 FROM CRD7 C inner join ocrd t0 on c.cardcode =t0.cardcode)'CST NO',

(SELECT TOP 1 C.TaxId2 FROM CRD7 C inner join ocrd t0 on c.cardcode =t0.cardcode)'VAT NO'

,T1.[LineTotal],T1.[currency],t0.RoundDifSy 

FROM owtr  T0  INNER JOIN wtr1  T1 ON T0.[DocEntry] = T1.[DocEntry]

left outer JOIN OCTG T2 ON T0.[GroupNum] = T2.[GroupNum] 

where T0.DocEntry={?Dockey@}

group by T0.[DocNum], t0.DocEntry,T0.[DocDate], T0.[DocDueDate], T0.[CardName],T0.[U_BPNAME],T0.[DocTotal] ,t1.unitmsr,

T0.[Address], T0.[NumAtCard], T0.[BPLId], T1.[Dscription],T1.[BaseAtCard], T1.[Quantity],

T2.PymntGroup,T0.[U_Despatchedthrough],T0.[U_Destination],T1.[LineTotal],T1.[currency],

t0.RoundDifSy,t1.BaseEntry,t0.Address2,t1.PriceBefDi

[former_member185296]

Hi,

Check whether any group by function is added in the query.

Regards,

Vinoth

[former_member320372]

Hi Vinoth,

                 Yes we have using group by function. we are using the below query,

group by T0.[DocNum], t0.DocEntry,T0.[DocDate], T0.[DocDueDate], T0.[CardName],T0.[U_BPNAME],T0.[DocTotal] ,t1.unitmsr,

T0.[Address], T0.[NumAtCard], T0.[BPLId], T1.[Dscription],T1.[BaseAtCard], T1.[Quantity],

T2.PymntGroup,T0.[U_Despatchedthrough],T0.[U_Destination],T1.[LineTotal],T1.[currency],

t0.RoundDifSy,t1.BaseEntry,t0.Address2,t1.PriceBefDi