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.

I am trying to run the following query in an jrxml file. I can run the query just fine using the same jrxml file with ireports. Both iReports and Jasper Reporting server are usinmg the same datasource. When I run the qury from Jasper Reporting Server I am getting the error below. At first thought I thought the issue was with the postgresql. But I found I am use the older driver and the query still works in iReports but not in Jasper Reporting. I am using the postgresql-8.3-604.jdbc3.jar. I have put this driver in C:Program Filesjasperserver-3.1apache-tomcatcommonlib This issue is holding us up to deploying Jasper Reporting Server into production. Please help!!!!! The query is <queryString> <![CDATA[sELECT * FROM public.sp_jcemployeeutilization_2() as jc_employeeutilization_rec( superempnum bigint, employeename varchar(25), empnum bigint, shift bigint, hr_totalhours bigint, supervisorname varchar(25), jc_totalhours bigint, jc_indirecthours bigint, jc_unaccountedhours bigint, jc_jobcost_percentage FLOAT, jc_indirect_percentage FLOAT, jc_unaccounted_percentage FLOAT) order by shift,superempnum, employeename;]]> </queryString> r Trace: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL statement for : JobCost-Employee Utilization net.sf.jasperreports.engine.JRException: Error executing SQL statement for : JobCost-Employee Utilization org.postgresql.util.PSQLException: ERROR: transaction is read-only Post Edited by larry conklin at 01/07/09 19:33

Yes the new driver is in Lib.. Why would it work in iReports and not in Jaspser Server?

I am back to getting this error. The jrxml works fine using iReports. When I which over to using jasper server I get the error below. at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: org.postgresql.util.PSQLException: ERROR: transaction is read-only at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) ... 100 more 15:18:19,656 ERROR JSErrorPage_jsp,http-8080-Processor23:329 - net.sf.jasperreports.engine.JRException: Error executing SQL statement for : JobCost-InvalidTime at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:127) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588)

I am looking for the file main_jsp.java which controls part of the look and feel of the jasper web page so I can add our company logo for our own branding. I can't locate the file in any of the source code I have downloaded. Please help. package org.apache.jsp.WEB_002dINF.decorators; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.jsp.*; public final class main_jsp extends org.apache.jasper.runtime.HttpJspBase implements org.apache.jasper.runtime.JspSourceDependent {

How do I send dates to a store proc in jrxml This works <queryString> <![CDATA[sELECT * FROM jobcosting.sp_jclogtimeexceptions('11/01/2008','11/30/2008') this does not <queryString> <![CDATA[sELECT * FROM jobcosting.sp_jclogtimeexceptions($P(LogInDate), $P(LogOutDate)) The error I am getting is Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$" I need the user to by able to enter the date range of the dataset he wants. I am using postgresql, my function looks like CREATE OR REPLACE FUNCTION "jobcosting"."sp_jclogtimeexceptions" (login date, logout date) RETURNS SETOF record The parm in jrxml is <parameter name="LogInDate" class="java.lang.String"/> Thank you

Hi I am new to jasper Reports. I had the same problem. The output pdf would show in iReports but not in jasper server. I noticed in iReports I was getting a font error but the report sill work. I corrected the font error and the report worked well in both iReports and Jasper Server. My take is after working with jaspersoft for the last two weeks is iReports will show things in default while Jasper server will not.

I have a report where the user can enter a field with a value to reduce the number of rows coming back from the DB. Can I have the same report return all rows if the user leaves the field blank/null? Wouldn't I need two queries in the same jrxml file? Can I have that much flow control in jrxml?

Yes I am using postgresql 8.1 with jasper resports server. I did need to download and install the newest postgresql jbdc driver. Otherwise I keep getting the error was the query was read only. Good luck.

I have resolved the issue myself. There are some inconsistencies between iReports and Jasper Report Server. iReports pull jpg from the directory where the jrxml is located. If using Jasper Reports Server and using the image folder you need to change the jrxml. <imageExpression class="java.lang.String"><![CDATA["PRYERLogo.jpg"]]></imageExpression> to <imageExpression class="java.lang.String"><![CDATA["repo:/images/PRYERLogo"]]></imageExpression> Post Edited by larry conklin at 12/05/08 15:16

Image error I have up loaded our logo in to the image folder. I have also uploaded the image during the report setup in jasper server. When I run the report from iReports I have no issues. When I run the report from jasper server I am receiving the error below. How do I get jasper report server to find my images? com.jaspersoft.jasperserver.api.JSExceptionWrapper: Byte data not found at location : PRYERLogo.jpg com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Byte data not found at location : PRYERLogo.jpg at net.sf.jasperreports.engine.util.JRLoader.loadBytesFromLocation(JRLoader.java