Dear All,
I am trying to create layout for purchase order through crystal reporter , i used "Dockey@" parameter, tried to view header level data and it displays. But when i add fields from POR1 to details section and try to view data , then all data include header are not displaying. Can anyone could guide to solve.
Regards:
kabali
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