Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Cory Vendrely

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...