Skip to Content
avatar image
Former Member

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

Feb 24, 2017 at 05:07 PM | 54 Views | Last edit Sep 04, 2017 at 07:55 AM 3 rev.

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

SAP Crystal Reports
SAP Business One
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Rizki Wicaksana
    Feb 25, 2017 at 08:10 AM

    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
    10|10000 characters needed characters exceeded