Symptom
Hyperlink to another report in Enterprise does not work for some records in the report
Environment
Crystal Reports 2008
BOE XI 3.1
Cause
Hyperlink is a result of concatenation formula. If one of the URL components is NULL, then the whole concatenation formula returns NULL, URL=NULL and the hyperlink does not work.
Resolution
check "Convert Database NULL Values to Default" in File > Report Options
or
use IsNull function to modify formula and avoid NULL result
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To