on 2013 Jan 03 12:08 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
112 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.