Hai Kabali,
I don't know the way you make that crystal report. But I will give you advice to make simple layout with crystal report.
1. Try to display all column that you want in SQL. For example by creating stored procedure, as shown below :
CREATE PROCEDURE PO_LAYOUT
@DocKey int AS
BEGIN
Select
/* HEADER */
T0.CardCode,
T0.CardName,
T0.DocDate,
/* DETAIL */
T1.ItemCode,
T1.Dscription,
T1.Quantity,
T1.Price
FROM OPOR T0
INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.DocEntry = @DocKey
END
2. When you want to display this data in crystal report, choose the stored procedure you created --> PO_Layout (Not OPOR and POR1 table)
3. Desain crystal reports
4. Rename @DocKey parameter in crystal report to DocKey@
Good luck :)
Regards,
Rizki
Add comment