joannem

Thank you! I have tried this but I get an error when I try to put <b>... </b> in my expression. I defined a style and chose "Styled Text". I set this style for my variable and in the expression I put <b>$F{datefrm_label}</b> + ": " + $F{datefrm_repsel} I get an error. Am I missing something?

Hello, I am using an xml file as my datasource. One of my fields is a comma delimited list which I split and put into an array.... I have a variable assigned for each array element... so, $V{hr1} = $V{vends}[0]... $V{hr2} = $V{vends}[1].... I want to take some of my variables and add them together. $V{hr1} + $V{hr2} + $V{hr3} My array is defined as a string. I've tried a couple of different options of defining my variables hr1, hr2, hr3.... as integers..... as well as I've tried them as string but nothing works to be able to add them together. I can get it to concatenate the values of hr1, hr2 and hr3 but I cannot get them to add. I have a variable $V(hr_int4) where the expression is Integer.valueOf($V{hr1} + $V{hr2} + $V{hr3}) when I view this I see the concatenated values of the fields as if they were strings. I've tried Integer.parseInt($V[hr1} + $V{hr2} + $V{hr3}) it didn't work..... I get an error "Incompatible conditional types int + Integer". I've also gotten the error "The operator + is undefined for the argument type(s) java.lang.Integer, java.lang.Integer. If anyone can tell me what I am missing doing, it would be greatly appreciated. Thanks you in advance.

Thank you so much! That worked perfectly! I didn't realize I could just add the [] at the end of java.lang.String!!!

Hi, I am using an xml datasource which contains a field I need to reference. The field value is a comma delimited list (0,0,1,0,2,255,0). I need to be able to separate the values as each entry in the list represents an hourly value. I can use split to put the value in an array but then I'm not sure how to access the individual array values. Anyone know a way for me to do this? Thanks!

Hello, I have a field expression where I am displaying more then one field value in it. For example $F{g_route} + ": " + $F{routecode| Is there a way to set the $F{g_route} to print in bold but the $F{routecode} not be bold? Thanks in advance!

Hi, I am trying to create a subreport to include in my master report but when I preview the master report I dod not see the data from the subreport. I am using an xml datasource. If I preview the subreport by istelf and I see my data. If I preview the mastereport which contains the subreport I get no data being displayed, just an empty space where the subreport is supposed to be. When defining the subreport I have tried the option to use the same datasource as the sub report and also "Use Datasource Expression" and entering $P{REPORT_DATA_SOURCE} for the expression, but neither work. If anyone can assist me, I would greatly appreciate it.

Hello, I have a java program that I'm trying to run to process a report but I keep getting the following error and can not figure out what is wrong. Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xpath/CachedXPathAPI at net.sf.jasperreports.engine.util.xml.XalanXPathExecuter.<init>,XalanXPathExecuter.java:49) at net.sf.jasperreports.engine.util.xml.XalanXPathExecuterFactory.getXPathExecuter<XalanXPathExecuterFactory.java:43) ...... I have a file Main.class that is located in the org/apache/xpath directory. When I do a search for the file CachedXPathAPI, it comes up with this Main.class. No matter what I try I keep getting this same error. I must be missing something! Any help would be greatly appreciated. I am fairly new to java so this has been a bit of a challenge for me.

I'm having the same issue where I do not get any data to display on my subreport. I have tried everything and used every advice I could find and still I do not see my data. I'm using the same xml datasource for both the master report and sub report.

I would like to make a band bigger but I can't get it larger then 147. Is there a way to set the band size bigger than that?

Perfect! Thank you very much!

Hello, Every time I compile my .jrxml file a java file is created in the same directory. Should these files be automatically deleted or do I need to delete these myself manually.

Hello, I have 2 separate reports that use the same xml datasource. I would like to put the one report in the other as a sub-report. I have tried every possibility I could think of but no matter what I do not see my subreport data, however if I view the reports separately the one being used as the subreport displays data. I have copied my jrxml file from the master report. If anyone sees something I'm doing wrong, I would greatly appreciate the input. Thanks in advance! <?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="netrecloc_2" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="792" pageHeight="612" columnWidth="732" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" 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.*" /> <queryString language="xPath"><![CDATA[/smartxml/repdata]]></queryString> <field name="routecode" class="java.lang.String"> <fieldDescription><![CDATA[routecode]]></fieldDescription> </field> <field name="routeorig" class="java.lang.String"> <fieldDescription><![CDATA[routeorig]]></fieldDescription> </field> <field name="locationcode" class="java.lang.String"> <fieldDescription><![CDATA[locationcode]]></fieldDescription> </field> <field name="locationadd1" class="java.lang.String"> <fieldDescription><![CDATA[locationadd1]]></fieldDescription> </field> <field name="routedescr" class="java.lang.String"> <fieldDescription><![CDATA[routedescr]]></fieldDescription> </field> <field name="storenumber" class="java.lang.String"> <fieldDescription><![CDATA[storenumber]]></fieldDescription> </field> <field name="totvends" class="java.lang.Double"> <fieldDescription><![CDATA[totvends]]></fieldDescription> </field> <field name="slsactivity" class="java.lang.Double"> <fieldDescription><![CDATA[slsactivity]]></fieldDescription> </field> <field name="totcomm" class="java.lang.Double"> <fieldDescription><![CDATA[totcomm]]></fieldDescription> </field> <field name="tottax" class="java.lang.Double"> <fieldDescription><![CDATA[tottax]]></fieldDescription> </field> <field name="totcost" class="java.lang.Double"> <fieldDescription><![CDATA[totcost]]></fieldDescription> </field> <field name="totadj" class="java.lang.Double"> <fieldDescription><![CDATA[totadj]]></fieldDescription> </field> <field name="locname" class="java.lang.String"> <fieldDescription><![CDATA[locname]]></fieldDescription> </field> <field name="netrec" class="java.lang.Double"> <fieldDescription><![CDATA[netrec]]></fieldDescription> </field> <field name="label_route" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-route/label]]></fieldDescription> </field> <field name="reportname" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/general/reportname]]></fieldDescription> </field> <field name="sysname" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/general/sysname]]></fieldDescription> </field> <field name="username" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/general/username]]></fieldDescription> </field> <field name="reporttime" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/general/reporttime]]></fieldDescription> </field> <field name="reportdate" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/general/reportdate]]></fieldDescription> </field> <field name="entlogo" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/general/entlogo]]></fieldDescription> </field> <field name="page_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-page/label]]></fieldDescription> </field> <field name="of_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-of/label]]></fieldDescription> </field> <field name="label_routecode" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/routecode]]></fieldDescription> </field> <field name="label_locationcode" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/locationcode]]></fieldDescription> </field> <field name="label_totvends" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/totvends]]></fieldDescription> </field> <field name="label_slsactivity" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/slsactivity]]></fieldDescription> </field> <field name="label_totcomm" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/totcomm]]></fieldDescription> </field> <field name="label_tottax" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/tottax]]></fieldDescription> </field> <field name="label_totcost" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/totcost]]></fieldDescription> </field> <field name="label_totadj" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/totadj]]></fieldDescription> </field> <field name="label_netrec" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/netrec]]></fieldDescription> </field> <field name="label_net" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-blank5/label]]></fieldDescription> </field> <field name="label_servicedt" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-blank6/label]]></fieldDescription> </field> <field name="label_venddt" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-blank7/label]]></fieldDescription> </field> <field name="label_detail" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-detail/label]]></fieldDescription> </field> <field name="label_summary" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-summary/label]]></fieldDescription> </field> <field name="label_storenumber" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/labels/storenumber]]></fieldDescription> </field> <field name="label_reptot" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-reptot/label]]></fieldDescription> </field> <field name="label_totfor" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-totfor/label]]></fieldDescription> </field> <field name="subrepfile" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/general/user]]></fieldDescription> </field> <field name="notavail_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/genlabels/g-blank2/label]]></fieldDescription> </field> <field name="datefrm_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-datefrm/label]]></fieldDescription> </field> <field name="datefrm_repsel" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-datefrm/repsel]]></fieldDescription> </field> <field name="dateto_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-dateto/label]]></fieldDescription> </field> <field name="dateto_repsel" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-dateto/repsel]]></fieldDescription> </field> <field name="route_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-route/label]]></fieldDescription> </field> <field name="route_repsel" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-route/repsel]]></fieldDescription> </field> <field name="location_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-location/label]]></fieldDescription> </field> <field name="location_repsel" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-location/repsel]]></fieldDescription> </field> <field name="detsum_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-detsum/label]]></fieldDescription> </field> <field name="detsum_repsel" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-detsum/repsel]]></fieldDescription> </field> <field name="dtetype_label" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-dtetype/label]]></fieldDescription> </field> <field name="dtetype_repsel" class="java.lang.String"> <fieldDescription><![CDATA[/smartxml/lang/selections/s-dtetype/repsel]]></fieldDescription> </field> <sortField name="routecode" /> <sortField name="locationcode" /> <variable name="full_route" class="java.lang.String" resetType="Group" resetGroup="Route" calculation="Nothing"> <variableExpression><![CDATA[$F{routecode} + ", " + $F{routedescr}]]></variableExpression> </variable> <variable name="rte_vends" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[$F{totvends}]]></variableExpression> </variable> <variable name="tot_vends" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{totvends}]]></variableExpression> </variable> <variable name="loc_vends" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[$F{totvends}]]></variableExpression> </variable> <variable name="loc_slsactivity" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[$F{slsactivity}]]></variableExpression> </variable> <variable name="rte_slsactivity" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[$F{slsactivity}]]></variableExpression> </variable> <variable name="tot_slsactivity" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{slsactivity}]]></variableExpression> </variable> <variable name="loc_totcost" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[$F{totcost}]]></variableExpression> </variable> <variable name="rte_totcost" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[$F{totcost}]]></variableExpression> </variable> <variable name="tot_totcost" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{totcost}]]></variableExpression> </variable> <variable name="loc_totadj" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[$F{totadj}]]></variableExpression> </variable> <variable name="rte_totadj" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[$F{totadj}]]></variableExpression> </variable> <variable name="tot_totadj" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{totadj}]]></variableExpression> </variable> <variable name="loc_tottax" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[$F{tottax}]]></variableExpression> </variable> <variable name="rte_tottax" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[$F{tottax}]]></variableExpression> </variable> <variable name="tot_tottax" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{tottax}]]></variableExpression> </variable> <variable name="loc_totcomm" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[$F{totcomm}]]></variableExpression> </variable> <variable name="rte_totcomm" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[$F{totcomm}]]></variableExpression> </variable> <variable name="tot_totcomm" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{totcomm}]]></variableExpression> </variable> <variable name="loc_netrec" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[$F{netrec}]]></variableExpression> </variable> <variable name="rte_netrec" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[$F{netrec}]]></variableExpression> </variable> <variable name="tot_netrec" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{netrec}]]></variableExpression> </variable> <variable name="loc_totnet" class="java.lang.Double" resetType="Group" resetGroup="Location" calculation="Sum"> <variableExpression><![CDATA[new java.lang.Double( ($F{netrec}.doubleValue()) -($F{totcomm}.doubleValue()) )]]></variableExpression> </variable> <variable name="rte_totnet" class="java.lang.Double" resetType="Group" resetGroup="Route" calculation="Sum"> <variableExpression><![CDATA[new java.lang.Double( ($F{netrec}.doubleValue()) -($F{totcomm}.doubleValue()) )]]></variableExpression> </variable> <variable name="tot_totnet" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[new java.lang.Double( ($F{netrec}.doubleValue()) -($F{totcomm}.doubleValue()) )]]></variableExpression> </variable> <variable name="MyPgCount" class="java.lang.Integer" resetType="Report" incrementType="Report" calculation="Nothing"> <variableExpression><![CDATA[$V{PAGE_NUMBER}]]></variableExpression> </variable> <group name="Route" > <groupExpression><![CDATA[$F{routecode}]]></groupExpression> <groupHeader> <band height="16" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="3" y="1" width="636" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font pdfFontName="Helvetica-Bold" size="10" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_route} + ": " + $F{routecode} + ", " + $F{routedescr}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="30" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="#,##0;(#,##0)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="149" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_vends}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="222" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_slsactivity}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.000000;(#,##0.000000)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="295" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_totcost}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="368" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_totadj}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="441" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_tottax}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="514" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_netrec}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="587" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_totcomm}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="660" y="9" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{rte_totnet}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="2" y="9" width="146" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_totfor} + " " + $F{label_routecode}+ " " + $F{routecode} + ":"]]></textFieldExpression> </textField> </band> </groupFooter> </group> <group name="Location" > <groupExpression><![CDATA[$F{locationcode}]]></groupExpression> <groupHeader> <band height="14" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="10" y="1" width="647" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font pdfFontName="Helvetica" size="8" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{locationcode} + ", " + $F{locname}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="13" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="24" y="0" width="125" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[( ($F{storenumber} != null && $F{storenumber}.length() > 0) ? $F{label_storenumber} + ": " + $F{storenumber} : $F{label_storenumber} + ": " + $F{notavail_label} )]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0;(#,##0)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="149" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_vends}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="222" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_slsactivity}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.000000;(#,##0.000000)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="295" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_totcost}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="368" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_totadj}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="441" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_tottax}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="587" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_totcomm}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="514" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_netrec}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="660" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{loc_totnet}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="98" isSplitAllowed="true" > <subreport isUsingCache="true"> <reportElement x="10" y="10" width="706" height="69" key="subreport-1"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA["c:/Temp/netrecloc_criteria.jasper"]]></subreportExpression> </subreport> </band> </title> <pageHeader> <band height="47" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="157" y="2" width="414" height="18" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{sysname}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="157" y="20" width="414" height="18" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{reportname}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="592" y="20" width="135" height="18" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{username}]]></textFieldExpression> </textField> <image evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="3" y="2" width="82" height="39" key="image-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <graphicElement stretchType="NoStretch"/> <imageExpression class="java.lang.String"><![CDATA[$F{entlogo}]]></imageExpression> </image> <line direction="TopDown"> <reportElement x="2" y="43" width="728" height="0" key="line-1"/> <graphicElement stretchType="NoStretch"/> </line> </band> </pageHeader> <columnHeader> <band height="22" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="24" y="5" width="114" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_storenumber}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="147" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_totvends}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="220" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_slsactivity}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="293" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_totcost}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="368" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_totadj}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="441" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_tottax}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="514" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Top"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_net}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="587" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Top"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_totcomm}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="660" y="5" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{label_netrec}]]></textFieldExpression> </textField> <line direction="TopDown"> <reportElement x="3" y="20" width="728" height="0" key="line-2"/> <graphicElement stretchType="NoStretch"/> </line> </band> </columnHeader> <detail> <band height="0" isSplitAllowed="true" > </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="27" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="5" y="13" width="100" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{reporttime}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="5" y="3" width="100" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{reportdate}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="524" y="13" width="147" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER} + " " + $F{of_label}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="673" y="13" width="58" height="13" key="textField-4"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font size="8"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <lastPageFooter> <band height="50" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="#,##0.000000;(#,##0.000000)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="295" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-Bold" size="8" isBold="true"/> </textElement> <textFieldExpression class="java.lang.Double"><![CDATA[$V{tot_totcost}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="368" y="0" width="70" height="13" key="textField"/> <box topBorder="None" topBorderColor="

Hello, I am trying to use a hyperlink in a chart to drilldown to more detailed data but I'm not sure how the hyperlink knows what to open to drilldown. What I would like is that when the report is run, a chart is created showing sales figures for delivery routes. If the user clicks on a specific delivery route I would like to open a new chart that displays the sales figures for the locations within that delivery route. I have my initial chart set up but I'm not sure how I go about the second one and where I link the first one to the second one. Anyone has some information to help me out would be greatly appreciated. Thanks!

Hello, Thank you! I don't have any parameters that I'm passing. I'm using an xml file for my datasource and they both use the same one. Is there something else I'm supposed to be doing? I'm new to this and for some reason I just don't seem to be able to get my subreport to display.

Hi, Thank you for the response. I looked at that tutorial have deleted my subreport element in my master report, tried adding new so it looked similar to the tutorial but I don't get anything showing up for my subreport. At least I'm not getting that error anymore.

Hello, I have a master report where I'm trying to insert a sub report into the Title band. Am I supposed to be using the .jasper file or the .jxml file? I've tried both with no success in getting any data to display from my subreport I get the following error when I execute the report with the subreport set to the .jrxml. Filling report... Locale: English (United States) Time zone: Default Error filling print... Error loading object from file : .netrecloc_criteria.jrxml net.sf.jasperreports.engine.JRException: Error loading object from file : .netrecloc_criteria.jrxml at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:92) at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:257) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:308) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:257) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:311) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:247) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:1049) at java.lang.Thread.run(Unknown Source) Caused by: java.io.StreamCorruptedException: invalid stream header at java.io.ObjectInputStream.readStreamHeader(Unknown Source) at java.io.ObjectInputStream.<init>(Unknown Source) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:87) ... 14 more Print was not filled. Try using an EmptyDataSource... Any assistance in where I'm going wrong would be greatly appreciated. Thanks in advance!

I found my error! I had taken the detail band away as I was doing just summarized data based on 2 groupings. I had put my fields in the first group footer and put my variables in the second group footer and the band for my report totals. Because I didn't have the variables in the first group footer but was using the fields, it was only giving me the last value from the data and not the calculated value. Thanks! Post edited by: joannem, at: 2007/11/28 13:00

Hello, I'm trying to create variables for my group totals but they are not calculating the way I thought they should. 1. I did "Add" a variable. 2. Called it rte_vends. 3. The Class type is java.lang.double 4. The calc type is Sum 5. The reset group is Route 6. The variable expression is $F{totvends} The amounts under the totvends column when I display the report is 9.00 381.00 2.00 70.00 19.00 The Group total I get is 1882.00 If anyone can assist me with what I am doing wrong, I would greatly appreciate it. Thanks!

Hello, This may be a silly question but I don't seem to be able to create an expression in iReport to concatenate 2 string fields. For example if you have string fields from your data source, last name and first name and you want to put them into one expression so it displays value of lastname, firstname (with the comma separating the 2). Any suggestions on what I'm missing to get this to work? Thanks in advance!

Thank you for your assistance, it helped me. I was missing a step.

Hello, I have created a very simple template that with an xml data source connection. I have put some fields from the xml file in the template, however I'm unsure of how I'm to preview the report. I can compile with no errors. When I choose Execute (empty data source) I get null values. When I choose Execute (active connection) I get a blank page. Can anyone assist me with what I am doing wrong? Thanks!

Hello, I am very new to iReports and Jasper. I am trying to create a report template using an xml datasource. I entered my datasource information under Connections/Datasource but am a little confused as to what I'm supposed to enter for the following options 1. Use the report XPath when filling in the report OR 2. Create a data source using this expression I'm assuming I don't have something entered correctly since I can't find any fields from my xml file to put into the report template. Can anyone assist me? Thanks!