Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Including HTML code in a LiveReport
Washington_D.C._Office_(DC_OFFICE_(Delete)_2546016
We are creating a LiveReport in which we would like to include some HTML, but the report protects all of the HTML characters (e.g. " " is converted to " " and "
" is converted to "<a>"). Is there any way to get around this?
Find more posts tagged with
Comments
John W. Simon, Jr.
Yes you can do it. You can also put more than one link a LiveReport. Below is the SQL we have in a LiveReport. The links call crystal reports in a new window. Let me know if you want to see the whole LiveReport and I will extract it and send it to you.The key to putting links in LiveReports is to change autoreport-run.html located in the modules/report_2_1_5 directory. I just saw some other posts about how to change this file...you should be able to find them with a search on the knowledge center.SQL:select cc.name "Location", Dtree.name "PHA Name", lower('!~
Total
') "Total", lower('!~
Recomm
')"Recomm", lower('!~
Title
')"Title", lower('!~
Sessions
')"Sessions" from Dtree, dtree aa, dtree cc where aa.dataid = -1*Dtree.parentid and cc.dataid = aa.parentid and Dtree.subtype = 2550 and %1 order by cc.name asc, Dtree.name ascRegards,John Simon