Skip to Content
1
Former Member
Feb 16, 2011 at 01:03 AM

crystal report 2008 for B1 hyperlink to purchase order window

1051 Views

HI all,

I am developing a crystal report in sap business one 8.8. I read SAP document '"How to working with crystal report in sap business one" I know we could link report field to Item master data window use 'http://$b1$/link?table=OITM&key='+{POR1.ItemCode}

I also can use 'http://$b1$/link?table=OCRD&key='+{OPOR.CardCode} to link to business partner window.

But I have trouble use purchase DocNum to link to purchase order window. First I get error of formular require string when use

'http://$b1$/link?table=OCRD&Key='+{OPOR.DocNum}

I did some search and found ('http://$b1$/link?table=OINV&key=' & totext({OINV.DocNum},0)). I add totext into my formular

'http://$b1$/link?table=OPOR&Key='+totext({OPOR.DocNum},0)

I run that report and get IE open when click DocNum with http://$b1$/link?table=OPOR&Key=9,917 rather than open purchase order window.

Please help me crystal report experts. I know I must miss something in there.