Skip to Content
0
Former Member
Jan 07, 2011 at 07:29 AM

how can i call make my field in crystal report link to WEB URL?

38 Views

Dear all expert,

i need to make one of the field link to a web url once end user click on it. But i duno how to use the concatenate function since the URL is quite long.

The example is as:

http://sbdevcrm.silverstone.com.my:8000/sap/bc/contentserver/020?get&

pVersion=0046&

contRep=CRMORDER&docId=DFAB31A583CDF1F1BD9E005056A1554D&

compId=Logo.jpg&

accessMode=r&

authId=CN%3DCR1&expiration=99991231235959&

secKey=MIH4BgkqhkiG9w0BBwKggeowgecCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGBxzCBxAIBATAZMA4xDDAKBgNVBAMTA0NSMQIHIBAHGQISUDAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMTEwMTA3MDYzMTA0WjAjBgkqhkiG9w0BCQQxFgQUrjTK9qbkl60OovmDRfUFYN5PBCMwCQYHKoZIzjgEAwQvMC0CFQC13oWG9qN9TtekzRCqLaOg7VsdHwIUWALOOyi7L0%2BxjriG34ULOmLlNeo%3D

How can i concatenate this? what i mean is like eg.: =concatenation("http://sbdevcrm.silverstone.com.my:8000/sap/bc/contentserver/020?get&pVersion=";concatenation(Replace({CRMORDERLOIO.VERSION});"&contRep";concatenation(Replace({CRMORDERLOIO.REP});"∁ID";concatenation(Replace({CRMORDERLOIO.LOG_ID});"accessMode=r&authid=";concatenation(Replace({CRMORDERLOIO.AUTHID});"&secKey";concatenation(Replace({CRMORDERLOIO.SECID}))