Hi, I am trying to create a hyperlink in my report header th...

[Cory Vendrely]

Hi,

I am trying to create a hyperlink in my report header that will work when I run the report to Excel. If I create a define field using the code below, and point to that define field in my header, it works fine when I run an HTML report.

'<a href="https://www.google.com/" target="_blank">Google Link</a>'

How can I do something similar for Excel reports I am working in InfoAssist 8.2.03 right now. Any help is appreciated.

Thanks,

Cory

[David Beagan]

This should work for EXL2K, PDF and HTML. Not sure if XLSX works.

TABLE FILE ggsales

SUM UNITS

BY REGION

HEADING

"Google <+0>click here"

" "

ON TABLE PCHOLD FORMAT EXL2K

ON TABLE SET STYLE *

TYPE=REPORT, HEADALIGN=BODY,$

TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=2,

TARGET='_blank', URL=http://www.google.com,$

ENDSTYLE

END

[Cory Vendrely]

Thanks David. For this request, we are working inside the InfoAssist GUI. Im wondering if we can do this same thing just in InfoAssist

[SATHEESH B]

You can choose web page option in the GUI.

 

image.png780591 28.6 KB

[Cory Vendrely]

Hi Satheesh. I tried using this method, but the URL has an ampersand &. The report is trying to figure out what the parameter is but there is none. I tried adding the pipe symbol after the ampersand, but it still wouldnt work. Thats why I tried using the html code in the report header instead of the drill down. But if theres a way to fake out the ampersand in the drill down menu, that might be the way to go

[SATHEESH B]

You can create a define field for the parameter values and add the parameter manually and point to the field.

 

image.png775595 35.8 KB