liveReports: html code & sql question

[tatyttrb]

hi all,

i've got a LiveReport & in the 'sql' section there is some html code:

select avp.TEST_PROJECT_NO "Project#", (select name from dtree where dataid = dt.ownerid) as "Project Name", '!~<a href="

https://alink/./...">Folder</a>'

as "link", .....

in LL v 9.5 the link showed up properly but after the conversion to 9.7.1 it just displays the following under the link column;

!~<a href="

https://alink/./.">Folder</a>

is there a way to add html code to the sql section in livereports so that this will render correctly ?

thank you

 

[appnair]

the shell escape character that you show

!~

comes form altering standard weblingo code to handle href's in livereports for some years.With advent of webreports you don't need it amended.I will take alook at this article for a solution if you do not have webreports

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2420182&objAction=view&show=2

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[tatyttrb]

thanks very much;

the info in the link worked as specified; for anyone else that needs the solution you just need to modify the 'autoreport-run.html' in the report_2_2_0 module with the info found in Appnair's link above;


thanks again