Skip to Content
avatar image
Former Member

i need help in subreport in crystal report

it have a table call arinvt where both raw material and main material stored.

if it is purchased order raw material is stored and if it is sales order main material is stored.

i want to display raw material of po and find the rawmaterial of main material through sub report and display all raw material in main report

when i try to do it , it can found the raw material but what happened is the raw material returned by subreport is displayed on next record instead of current record. i did not have grouping in my report

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 12 at 02:53 PM

    material-projection.png

    Thanks for the reply.

    i have resolved that problem. now i want to group by raw material, which is a formula field.

    ========================================

    formula name :RawMat

    shared StringVar MaterialNo;

    if {V_ARINVT_AVAIL_PROJECTED_DTL.SOURCE}='PO' then

    {ARINVT.ITEMNO}

    else

    MaterialNo

    ======================================

    MaterialNo is returned from sub report. I am not able group it out. is there any way to do?

    thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12 at 02:56 PM

    Thanks for the reply. i have resolved that problem. now i want to group by raw material, which is a formula field. ========================================

    formula name :RawMat

    shared StringVar MaterialNo;

    if {V_ARINVT_AVAIL_PROJECTED_DTL.SOURCE}='PO' then

    {ARINVT.ITEMNO}

    else

    MaterialNo

    ======================================

    material-projection.pngMaterialNo is returned from sub report. I am not able group it out. is there any way to do? thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 10:31 PM

    It would help to see a screenshot of Design tab and Preview

    Add comment
    10|10000 characters needed characters exceeded