dtrobert Posted April 6, 2010 Share Posted April 6, 2010 Hi, I am running Jasper 3.7.1 and attempting to embed hyperlinks inside XLS reports. I can generate an html or PDF report just fine but with XLS, the cells do not contain the links and appear as just plain text. Has anyone successfully done this?ThanksCode:<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="Reference" hyperlinkTarget="Self" > <reportElement x="25" y="0" width="100" height="15" forecolor="#000000" key="DN"/> <box leftPadding="5" rightPadding="5"> <pen lineWidth="0.75"/> <topPen lineWidth="0.75"/> <leftPen lineWidth="0.75"/> <bottomPen lineWidth="0.75"/> <rightPen lineWidth="0.75"/></box> <textElement textAlignment="Left"> <font reportFont="Verdana_Normal" size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{directorynumbername}]]></textFieldExpression> <anchorNameExpression><![CDATA[$F{registrationstate}.intValue() == 2 ? "http://" + $P{csipcip} + "/clarusipc/infoportal/launchRemoteHands.do?phoneId=" + String.valueOf($P{system}.getSystemId()) + "_" + $F{devicename} + "&userName=" + $P{userid} + "&password=" + $P{password} : null]]></anchorNameExpression> <hyperlinkReferenceExpression><![CDATA[$F{registrationstate}.intValue() == 2 ? "http://" + $P{csipcip} + "/clarusipc/infoportal/launchRemoteHands.do?phoneId=" + String.valueOf($P{system}.getSystemId()) + "_" + $F{devicename} + "&userName=" + $P{userid} + "&password=" + $P{password} : null]]></hyperlinkReferenceExpression> </textField> Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now