cancel
Showing results for 
Search instead for 
Did you mean: 

PO PREVIEW PROBLEM

Former Member
0 Kudos
58

Dear friends

Happy New Year 2013

I create Crystal Layout for purchase Order , in that Layout i create two sub report for Tax & fright & My first PO no. start from 958

When i run the CR layout outside it works properly But when i import it in SAP b1 8.82 PL 6 & after i preview the PO then it directly doesn't show the preview

it display enter the PO No manually after entering the PO No it show proper result

So how i avoid the  entering the PO no manfully ,i want it show direct preview 

for that first i create record selection like below

{OPOR.DocNum} ={?DocEntry@}    --------for subreport also

but after when i preview the PO it view directly but no result.

After That i change the record formula

{OPOR.DocNum} ={?DocNum@}   -----for Sub report ALSO

BUT I HAVE TO ENTER MANUALLY  PO NO BUT GOT RESULT

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Jay,

The parameter you have defined is wrong. SAP doesn't recognize it. You need to define the parameter Dockey@ instead of DocEntry@.

You said, you are using two subreports in your report. You need to pass the parameter from the main report to the subreports. Right click each subreport, say 'change subreport links'. Choose the parameter to pass and say filter records in the subreport. This will pass the parameter from the main report to the subreport and shall also filter the subreport records for the passed parameter value. Do this for each of the subreport.Choose to filter the records of the subreport by docentry and not docnum.

Same for main report. You need to filter your records by docentry and not docnum.

i.e. it should be like {OPOR.DocEntry} ={?Dockey@}

Now, when you preview in B1, SAP recognizes that docentry for the doc has to be passed to the parameter Dockey@. It passes the value internally, and you directly get to see the preview instead of manually keying in the no.