Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
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