Disabling Hyperlinks for PDF or Excel output

[jriley]

Hi All,
I have seen several topics on hyperlinks in Excel output and trying to make them active links.  But I haven't seen anything about disabling the link for other than HTML output.  Our goal is to remove the underline and disable the link (so there it does not appear to be clickable) for PDF and Excel output.  I've experimented with style variables, conditional variables, etc. to attempt to affect these changes for PDF or Excel with no luck so far.

Does anyone have script or some further instruction on how to make this happen in Cognos?  I've done it in other reporting tools but have not succeeded thus far in Cognos.  We are at version 10.2.1. 

Thanks in advance.
Joe

[jriley]

I devised a workaround for this issue. 


-Create an identical column without the drillthrough definition or the HTML tags, etc. removed.   

-Create a Conditional variable such as:  ReportOutput () in ('singleXLS','XLS', 'spreadsheetML') to check for Excel  Output selected.

-Then using Conditional Explorer,  click Yes under the condition set above.  Set the column properties (at List Column level) for Column with Hyperlinks with links to Box Type=None.  Note the column disappears.  Click Green column to return.

-For the copied column without Hyperlinks, do the opposite.  Uncer Conditional Explorer,  click No, then set Box Type=None.

Now for Excel output, the hyperlinked column will not appear.  The column without linking will appear.

Not the greatest solution, but it works.

Thanks,
Joe