Skip to Content
0

Hello to everyone, can anyone tell me how to display row level data for purchase layout

Feb 24, 2017 at 05:07 PM

54

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Rizki Wicaksana Feb 25, 2017 at 08:10 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded