<p><span style="font-size:10pt;">Hi All,</span></p>
<p> </p>
<p><span style="font-size:10pt;">I have requirement in which I have to create hyperlink to only those data in excelsheet for which associated tab is available.</span></p>
<p> </p>
<p><span style="font-size:10pt;">For Example refer sample excelsheet report attached.</span></p>
<p> </p>
<p><span style="font-size:10pt;">In this excelsheet report there is mainpage and two linked sheets.</span></p>
<p> </p>
<p><span style="font-size:10pt;">In Mainpage you can see hyperlink for two cells data in </span><span style="color:#000000;"><span style="font-size:10pt;">AUTH_OPT_VAL </span></span><span style="font-size:10pt;">column because its corresponding sheets are </span><span style="font-size:8pt;">available</span><span style="font-size:10pt;"> for these two values, and rest of the other values there is no hyperlink.</span></p>
<p> </p>
<p><span style="font-family:'times new roman', serif;"><span style="font-size:10pt;">So to achieve this I have set hyperlink property of </span></span><span style="color:#000000;"><span style="font-family:'times new roman', serif;"><span style="font-size:10pt;">AUTH_OPT_VAL to "#"+row["AUTH_OPT_VAL"]+"!A1"</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:'times new roman', serif;"><span style="font-size:10pt;">But due to this I can see whole data in this column is hyperlinked and whenever I clicked on other data, I am getting error “reference is not validâ€</span></span></span></p>
<p><span style="color:#000000;"><span style="font-family:'times new roman', serif;"><span style="font-size:10pt;">So please let me know is there any way we can create hyperlink only to those data for which sheets are available.</span></span></span></p>
<p><span style="color:rgb(40,40,40);"><span style="font-family:'times new roman', serif;"><span style="font-size:9pt;">I am using BIRT 4.5.0 version</span></span></span>.</p>
