lconklin

In the pdf doc the link just changes to a hand when you move the cursor over the text. In Excel it appears as a normal column with text data only. Yes the jpgs are on my local file system where I am running jaspersoft

Sherman I have tried using hyperlinkType="Reference". I get the behavior described below. If I use the sample in the doc's with hyperlinkType="Reference I can bring up the google web site. But I can''t bring up a jpg picture.

Sherman Can you give me a little more to go on? I have tried the following.... <hyperlinkReferenceExpression><![CDATA[$F{partimg}]]></hyperlinkReferenceExpression> </textField> In both cases if i use the hard coded string or the partimg. It acts like a hyper link for a PDF report but it can't bring up the image. If I export to excel it never acts like a hyper link. I am creating a part list with thousands of parts one part in a detail row, each part has its own jpg. I need the user to have the ability to click on the hyperlink to see the image. I want the path to show in the report as text which is working I just need the click on the hyperlink to bring up the image. Thank you

I need to know how create a hyperlink in a data row that will allow a user to click on a text link that will bring up a jpg picture in a seperate window. The code below doesn't work. <textField hyperlinkType="LocalAnchor" hyperlinkTarget="Blank"> <reportElement x="618" y="0" width="850" height="11"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{partimg}]]></textFieldExpression> <hyperlinkReferenceExpression><![CDATA["C:\images\01b-100.jpg"]]></hyperlinkReferenceExpression> </textField> I want to use text string in partimg that will be the actual image the users will see. Each data row will have a different jpg associated with it. Post Edited by larry conklin at 03/17/09 14:17

I am creating an analyis view for the first time. I am getting the following error. com.jaspersoft.jasperserver.api.JSException: java.lang.StringIndexOutOfBoundsException: String index out of range: -24com.jaspersoft.jasperserver.api.JSException: java.lang.StringIndexOutOfBoundsException: String index out of range: -24 Where do I start to find out what is causing the out of range error? Thank you Code:Select{[MEASURES].[EMPLOYEES]} ON COLUMNS, {[EMPLOYEES].[ALL SUPERVISOR], [EMPLOYEES].[ALL EMPLOYEE]} FROM [JobCostTime]My Cube is attached

In printing a PDF report I get one row of data. If I try to export the report to Excel I get two rows of data. What causes the difference between PDF and Excel formatting? yyyyyyyy,yyyyy 69 4 1 xxxx,xxxxxx 64 1 93 6 1 The employee name (yyyyyyyy,yyyyy), 69 and 4 shoud be on the same line as supervisor (xxxx,xxxxxx). The formating problem seems to be with each format except PDF and Flash. My detail xml in jrxml file is as follows... <detail> <band height="18" isSplitAllowed="false"> <frame> <reportElement style="Detail" x="38" y="-3" width="764" height="20"/> </frame> <textField hyperlinkType="None"> <reportElement x="39" y="0" width="26" height="14"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{shift}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="177" y="-1" width="99" height="14"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{employeename}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="279" y="-1" width="52" height="14"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{hr_totalhours}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="334" y="0" width="56" height="14"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{jc_totalhours}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="400" y="-1" width="49" height="14"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{jc_indirecthours}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" hyperlinkType="None"> <reportElement x="467" y="0" width="63" height="14"/> <textElement> <font fontName="Arial"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{jc_unaccountedhours}]]></textFieldExpression> </textField> <textField pattern="###0 " hyperlinkType="None"> <reportElement x="621" y="0" width="84" height="14"/> <textElement/> <textFieldExpression class="java.lang.Float"><![CDATA[$F{jc_indirect_percentage}]]></textFieldExpression> </textField> <textField pattern="###0 " hyperlinkType="None"> <reportElement x="544" y="0" width="74" height="14"/> <textElement/> <textFieldExpression class="java.lang.Float"><![CDATA[$F{jc_jobcost_percentage}]]></textFieldExpression> </textField> <textField hyperlinkType="None"> <reportElement x="65" y="0" width="112" height="14"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{supervisorname}]]></textFieldExpression> </textField> <textField pattern="###0 " hyperlinkType="None"> <reportElement x="705" y="0" width="82" height="14"/> <textElement/> <textFieldExpression class="java.lang.Float"><![CDATA[$F{jc_unaccounted_percentage}]]></textFieldExpression> </textField> </band> </detail>

What causes a data row to be split into two lines for csv or excel. I have a report I created that we publish everyday in PDF format. Some users also want the same report published in csv or excel format. My problem is that the the csv/excel format splits a data row into two lines in the csv report. In PDF format I have one complete data row. I have uploaded a small poration of the csv file.

Good morning clhubert Is this what you are doing??? I am still getting xml errors. $F{extprice}

I have a data base table that has part number and a jpg image of that part number. I need to have my jasper report show the image whn user clicks on the url along with other text concerning the part no. The path I am going down is something like .... <textField pattern="#,##0.00" hyperlinkType="None"> <reportElement x="476" y="0" width="63" height="11"/> <textElement/> <textFieldExpression class="java.lang.Double"><![CDATA[$F{jcperhour}]]></textFieldExpression> </textField> <textField pattern="#,##0.00" hyperlinkType="None"> <reportElement x="559" y="0" width="59" height="11"/> <textElement/> <textFieldExpression class="java.lang.Double"><![CDATA[$F{extprice}]]></textFieldExpression> </textField> <reportElement x="634" y="0" width="168" height="11"/> <textElement/> <text><![CDATA[<image scaleImage="RealSize"><reportElement x="0" y="0" width="150" height="40" style="imageBox"/><imageExpression>"http:\HOMEPRYERDATADRAWINGSPICTURE1ND-36207-1.JPG"</imageExpression></image>]]></text> </band> </detail> Each part will have it's own jpg. Right now I hard coded on image as a proof of concept. Do I need to make this static? In the doc's I am seeing it use static. But I need a new image for each row. Code:from demo jrxml<staticText> <reportElement x="160" y="0" width="390" height="40"/> <textElement/> <text><![CDATA[<image scaleImage="Clip" onErrorType="Icon" isLazy="true"><reportElement x="0" y="0" width="150" height="40"/><imageExpression class="java.lang.String">"http://jasperreports.sourceforge.net/jasperreports.png"</imageExpression></image>]]></text> </staticText>

Yea!!! I got it to work. In the context.xml file in webapps I put the following code. <Resource name="jdbc/postgres" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="postgres" password="xxxxxx" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/dm_JobCosting/defaultReadOnly=false"/> I have test this connection and it will allow me to call an store proc that has a create temp table statement in it. This work around solves my problem with jdbc connections being read only.

In my $TOMCAT/conf/Catalina/localhost/ (C:Program Filesjasperserver-3.1apache-tomcatconfCatalinalocalhost) directory all I have is host-manager.xml & manager.xml Ok now if I understand you correctly 1. I am going to create a file called jasperserver.xml in this directory. 2. In this file I am going to put resource name and resource parms pointing to my jdbc connection. 3. in jasperreporting server create a jndi connection that has the resource name. 4. where does defaultReadOnly="false" go? in jasperserver appended to the resource name or in the resource file as a parm along with user, password, etc?

Lucian Great picture of a dog. Is it a border collie? I have a border collie for search and resuce. On the JNDI can I use that without LDAP?

Sherman I tried both of these url's for the JDBC connection jdbc:postgresql://localhost:5432/dm_JobCosting/jasperserver?defaultAutoCommit=false jdbc:postgresql://localhost:5432/dm_JobCosting/defaultAutoCommit=false I am still getting the transaction read-only error. Both connection string work when I click on the test connection button. My biggest frstration is that this query works in iReports. Isn't iReports are of Jasper? Why would it work there but not in the jasper reporting server?

Does anyone know how to make a obdc connnection in Jasper Reports that will allow writes? My query is a store proc that creates temp tables. I am getting an error back that says my connection is read-only. I need my JDBC connection to allow writes. I am using POSTgreSQL as my datasource.

Sherman, you are correct in that I am creating a temp table to perform certain sql data manipulations. I then select everything out of my temp table for printing. I am doing alot of sql data manipulations to my data to get it ready for printing. I am using JDBC. I have assigned permissions to the datasource as adminstr in hopes to get around this issue. but it hasn't helped.