I have a report where I wish the user to be able to click from the data in the report to another web page.
The field is and Int (7), my format formula for the hyperlink is:
'https://mantis.corp.MyCompanyName.com/mantis/view.php?id='+ToText({mantis_bug_table1.id},0,"")
The hyperlink generated is:
javascript:parent.bobj.event.publish('hyperlinkClicked','CrystalReportViewer1__UI','target=_self&url=https%3a%2f%2fmantis.corp.MyCompanyName.com%2fmantis%2fview.php%3fid%3d5091')
The browser opens with:
https://mantis.corp.MyCompanyName.com/mantis/view.php?id
Somehow the =5091 is being lost as the link does properly show the %3D5091
The exact same code works correctly under VS2008 crystal reports.