dtrobert

I've read through the comments but what we're finding (latest Jasper Reports) is when we create an Excel file, the cell is assuming the value is a string and not a number. The field definition is long or some number but we get that error in Excel. In previous versions, that was handled by specifying the class in the textFieldExpression but not it's deprecated. Is the idea the Excel exporter relies on the class instead?

Hi, I have a horizontal bar chart in the summary band. When the number of bars is too large, the Y-axis becomes unreadable. I would like to force the chart to split when the number of returned bars is greater than some number. Does anyone know if this is possible or if there's another solution? I've set isStretchType to all the options (aside from NoStretch) on the report element for both the actual chart and a parent report's subreport element. Also tried to allow split on band and set element to 'Float' . The height of my band, subreport and chart element is somewhat arbitrary since I can't even know exactly how many categories there will be in the bar chart.

Hi, I'm trying to plot the average CPU usage of my computer over time. The timeseries takes inputs of time range and sampling rate. The data itself is collected every ~30 seconds. So when a user wants to see the CPU time for the last day plotted at hourly intervals, they chart selected has the 'hour' timeseries option but i need to plot the proper varable of cpu time. When I did here was create on, $V{averagecpu|} which has calculation Average and reset group 'timeGroup'. The timeGroup is defined as either the minute, hour, or day of the timestamp using $F{timestamp}.getMinutes() (this part I think is wrong). For a chart say of minute sampling over a day, my understanding with the way this would work is to group all the raw data values where the minute portion of the timestamp is the same. Now it' entirely possible hour after hour that there are duplicate values of the minute portion (e.g. 11:04am and 12:04pm) as well as the standard 11:04.12 11:04.54. I do want the average calculated over the case of 11:04.12 and 11:04.54 but am concerned that previous hour data might be introduced. The same problem can occur across days where Monday at 11am is grouped in with Tues at 11am. thoughts?

Hi, I am using hyperlink references in xls reports and have a tooltip as well. The problem is in the report, the mouseover is showing the hyperlink and not the tool tip. I am using Excel 2010 to read the report and jasper 3.6

Hmm, could be. I was hoping it was just say adding another total variable after my state variable since I just want to sum up the counts for all states for a particular model+devicepool.

Ugh, looks like my query was wrong on the join. Thanks for your help. Now that I have my report working generally, I do have one follow-up question. I have 2 groups for columns with totals at the end of each row. What I would like is a total for each group1 column. For example: group1(column)=model group2(column)=state group1(row)=devicepool my report has devicepool $V{model} total $V{state} $V{devicepool} $V{count} total a phone can be in one of several states. What I'm looking for is the total number of phones per model, something like devicepool model1 model2 total st1 st2 st3 tot st2 st3 tot mydp1 15 3 4 22 4 3 7 total do you know how/if this is possible?

Hi, I am trying to make a cross tab (based upon an Excel pivot table) which shows phone models by location. My sql collects all phones and their location and I've created a cross tab using the wizard with row label = site name (aka devicepool) colum name = model_name data = count of the device_id The first problem is that, the device_id are strings so count somehow just returned one of the device ids for all entries. The element type was actually set to string for a count. I then modified the 'measure' (looks like just a variable to me) and changed the type to java.lang.Integer and now at least it's reporting what seem to be counts. The problem is that the counts do not change from row to row. Any help is greatly appreciated. Thanks Code:<?xml version="1.0" encoding="UTF-8" ?><!-- Created with iReport - A designer for JasperReports --><!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"><jasperReport name="DeviceSummary2" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="792" pageHeight="612" columnWidth="792" columnSpacing="0" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenNoDataType="AllSectionsNoDetail" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <reportFont name="Verdana_Normal" isDefault="true" fontName="Verdana" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <reportFont name="Verdana_Bold" isDefault="false" fontName="Verdana" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <queryString><![CDATA[select dp.name as devicepool, d.* from device dinner join device_pool dp on d.device_pool_id = d.device_pool_idorder by dp.name]]></queryString> <field name="devicepool" class="java.lang.String"/> <field name="device_id" class="java.lang.String"/> <field name="name" class="java.lang.String"/> <field name="ip_address" class="java.lang.String"/> <field name="authentication_mode" class="java.lang.String"/> <field name="authentication_string" class="java.lang.String"/> <field name="auto_select_line_enable" class="java.lang.String"/> <field name="build_in_bridge" class="java.lang.String"/> <field name="certificate_operation" class="java.lang.String"/> <field name="cti_enabled" class="java.lang.Boolean"/> <field name="date_discovered" class="java.sql.Timestamp"/> <field name="description" class="java.lang.String"/> <field name="device_protocol" class="java.lang.String"/> <field name="device_security_mode" class="java.lang.String"/> <field name="disable_speaker" class="java.lang.Boolean"/> <field name="disable_speaker_and_headset" class="java.lang.Boolean"/> <field name="display_idle_timeout" class="java.lang.String"/> <field name="extension_mobility" class="java.lang.Boolean"/> <field name="forwarding_delay" class="java.lang.String"/> <field name="garp" class="java.lang.String"/> <field name="http_supported" class="java.lang.Boolean"/> <field name="ignore_presentation_indicators" class="java.lang.Boolean"/> <field name="key_size" class="java.lang.Integer"/> <field name="last_registration_date" class="java.sql.Timestamp"/> <field name="login_duration" class="java.lang.String"/> <field name="login_time" class="java.lang.String"/> <field name="login_user_id" class="java.lang.String"/> <field name="mlpp_domain_id" class="java.lang.Integer"/> <field name="mlpp_indication_status" class="java.lang.String"/> <field name="mlpp_preemption" class="java.lang.String"/> <field name="model_number" class="java.lang.Integer"/> <field name="model_name" class="java.lang.String"/> <field name="network_locale" class="java.lang.String"/> <field name="network_moh_audio_source" class="java.lang.String"/> <field name="number_of_add_on_modules" class="java.lang.Integer"/> <field name="operation_completes_time" class="java.lang.String"/> <field name="packet_capture_duration" class="java.lang.String"/> <field name="packet_capture_mode" class="java.lang.String"/> <field name="pc_port" class="java.lang.String"/> <field name="phone" class="java.lang.Boolean"/> <field name="phone_load" class="java.lang.String"/> <field name="primary_call_manager" class="java.lang.String"/> <field name="privacy" class="java.lang.String"/> <field name="registration_state" class="java.lang.Integer"/> <field name="retry_video_call_as_audio" class="java.lang.Boolean"/> <field name="rtp_info_supported" class="java.lang.Boolean"/> <field name="settings_access" class="java.lang.String"/> <field name="span_to_pc_port" class="java.lang.String"/> <field name="subnet_mask" class="java.lang.String"/> <field name="user_locale" class="java.lang.String"/> <field name="user_moh_audio_source" class="java.lang.String"/> <field name="video_capability" class="java.lang.String"/> <field name="voice_vlan_access" class="java.lang.String"/> <field name="web_access" class="java.lang.String"/> <field name="web_access_disabled" class="java.lang.Boolean"/> <field name="web_info_extracted" class="java.lang.Boolean"/> <field name="xml_supported" class="java.lang.Boolean"/> <field name="directory_services_url_1" class="java.lang.String"/> <field name="directory_services_url_2" class="java.lang.String"/> <field name="voice_mail_url_1" class="java.lang.String"/> <field name="voice_mail_url_2" class="java.lang.String"/> <field name="idle_url" class="java.lang.String"/> <field name="idle_timeout" class="java.lang.String"/> <field name="proxy_url" class="java.lang.String"/> <field name="authentication_url" class="java.lang.String"/> <field name="e911_location" class="java.lang.String"/> <field name="phone_user_name" class="java.lang.String"/> <field name="device_mobility_mode" class="java.lang.String"/> <field name="logged_into_hunt_group" class="java.lang.Boolean"/> <field name="last_status_update_time" class="java.sql.Timestamp"/> <field name="phone_web_fetch_required" class="java.lang.Boolean"/> <field name="aar_calling_search_space_id" class="java.lang.String"/> <field name="calling_search_space_id" class="java.lang.String"/> <field name="device_pool_id" class="java.lang.String"/> <field name="location_id" class="java.lang.String"/> <field name="network_segment_id" class="java.lang.String"/> <field name="softkey_template_id" class="java.lang.String"/> <field name="media_resource_group_list_id" class="java.lang.String"/> <field name="phone_template_id" class="java.lang.String"/> <field name="phone_web_info_id" class="java.lang.String"/> <field name="common_profile_id" class="java.lang.String"/> <field name="aar_group_id" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="0" isSplitAllowed="false" > </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="200" isSplitAllowed="true" > <crosstab > <reportElement x="0" y="0" width="792" height="200" key="crosstab-1"/> <crosstabHeaderCell> <cellContents mode="Transparent"> <box></box> </cellContents> </crosstabHeaderCell> <rowGroup name="devicepool" width="100" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{devicepool}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="30" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{devicepool}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="100" height="30" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["devicepool total"]]></textFieldExpression> </textField> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="model_name" height="25" totalPosition="End" headerPosition="Center"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{model_name}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="25" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{model_name}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="25" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["model_name total"]]></textFieldExpression> </textField> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="name_Count" class="java.lang.Integer" calculation="Count"> <measureExpression><![CDATA[$F{name}]]></measureExpression> </measure> <crosstabCell width="50" height="30"> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="30" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{name_Count}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" height="30" columnTotalGroup="model_name"> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="30" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{name_Count}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" height="30" rowTotalGroup="devicepool"> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="30" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{name_Count}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" height="30" rowTotalGroup="devicepool" columnTotalGroup="model_name"> <cellContents mode="Transparent"> <box></box> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="50" height="30" key="textField"/> <box></box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{name_Count}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <whenNoDataCell> <cellContents mode="Transparent"> <box></box> </cellContents> </whenNoDataCell> </crosstab> </band> </summary></jasperReport>

Seems like something obvious but I just started using iReport 3.7 (was using the old 3.0) and I'm seeing that every time I try to open a template, it's defaulting to C:\Documents and Settings\Administrator\ (home dir). With iReport 3.0, it appeared to remember the last template directory. Is there a way to a) have it default to the last used directory or b) always look in a particular directory? Thanks

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? Thanks Code:<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>

Does anymore know how I can automatically turn on filtering for an Excel report (column headers with the drop down for selection, ascending, descending, etc). Thanks

I have a problem where I have a single text field and want the content to wrap around if it goes further than the width. What is happening is it is increasing the width of the field (and entire report) instead. The field is in the same summary band as everything else (3 graphs). Any thoughts?

I have a similar problem. I have a single text field and want the content to wrap around if it goes further than the width. What is happening is it is increasing the width of the field (and entire report) instead. The field is in the same summary band as everything else (3 graphs). Any thoughts?

Lucian, I'm not familiar with export parameters. Can you please give me a simple example?

I know time series offers options like Day, Month, Hour, Week etc. I would like to allow users to control the sampling rate however and want to have this value determined at runtime. When I try to use a parameter in my template, it won't work. Any other ideas? Thanks

Hi, A while back we encountered problems with XLS output where long numbers (phone numbers) would be converted into sci-fi notation so we disabled the auto-formatting of all reports. However, now we see that it has a negative impact when it comes to say timestamps because, when sorting in Excel, it just performs a basic alphanumerical sort instead of intelligently knowing these are timestamps (10:01 sorts because 9:54 because 1 < 9 ). Does anyone know of a way to enable/disable this behavior per textfield? Thanks!

Hmm, well maybe getting closer but still no good (not like 3.0.0). I just installed iReport 3.6.1. I have my templates all located in a directory called C:/Program Files/Clarus/tomcat/shared/classes/content/reports/templates The compiled (.jasper) get stored in C:/Program Files/Clarus/tomcat/shared/classes/content/reports/templates/compiled I open a jrxml template which contains links to a subreport. The subreport expression is $P{reportsPath} + "templates/compiled/ResultSummary.jasper" When I attempt to right-click, open my subreport jrxml file, I get an error Unable to open the subreport: C:/Program Files/Clarus/tomcat/shared/classes/content/reports/templates/compiled/MySubreport.jrxml not found. It is true, there is no .jrxml file in that compiled directory, just in the templates/ directory. iReport 3.0.0 (and prior) handled this just fine however. I'm not sure what logic it is using but it's always able to find the right subreport. Thanks

Hi, I'm trying to plot the number of records that are concurrent from a table which has ID, starttime, endtime In other words, let's say I have ID starttime endtime 1 11:00 11:03 2 11:01 11:05 3: 11:02 11:03 4: 11:04 11:07 and want the concurrency at a minute interval. I would get time numberOfConcurrent 11:00 1 11:01 2 11:03 2 11:04 2 Does anyone know how I can do this in jasper reports, maybe with a variable and reset group where my group is like minutes? Thanks

Tried the latest iReport (3.6.0) but still having the same issue.

Thanks but my main point is the behavior from 3.0.0 is different and I have hundreds of templates so I'd prefer to not have change and re-QA them all just to use the latest iReport. I remember a developer saying he changed the behavior so it would work as good as 3.0.0 but looks like still not quite.

Just tried with iReport 3.6.0 and same issue although I thought it was fixed. When I right click to open subreport I get error: "Unable to open subreport: The subreport expression returned null. I'm unable to open the subreport jrxml :-(" My subreport expression is: $P{reportsPath} + "templates/compiled/RoutePlan_CallHandling_List2.jasper" where $P{reportsPath} gets passed in at runtime. Again, this works perfectly fine with iReport 3.0.0.

To be more specific, I upgrade my xerces.jar file to use the one included in the JasperReports distribution.

I think you might try <parameter name="ID" class="java.lang.Integer"> <defaultValueExpression><![CDATA[new java.lang.Integer(2)]]></defaultValueExpression> Are you passing this parameter in from a parent report?

Teodor, I can reproduce this easily with Jasper Report 3.5.3 and poi 3.2. Let me know what you would like to reproduce it. How can I get you a report with hardcoded content? (ours pulls from postgres).

The error message is fine but there is still a feature regression from the old iReport (3.0.0). Right click should attempt to look in the current working directory for the template if it is a parameterized path. For example, I might have defined the subreport as $P{reportPath} + "/templates/compiled/myreport.jasper" In iReport 3.0.0, right-click on the parent report would open this subreport even though $P{reportPath} was unknown and provided by the application.

Found the problem was me running an older version of xerces. Using the one packaged with jasper reports dist resolved it.