SAP Knowledge Base Article - Public

1549750 - Hyperlink Inconsistency

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

Product

Crystal Reports Server XI R2