Skip to Content
0

i need help in subreport in crystal report

Jan 11 at 06:27 PM

46

avatar image
Former Member

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

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

3 Answers

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

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.


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 12 at 02:56 PM
0

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.


Share
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
Jan 11 at 10:31 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded