title: Error in publishing jasper Report
body: <p>Can any one tell me the solution of error which is i'm facing about publishing report.</p>
  
  <p><strong>I'm using ubuntu 14.04 and jasper Studio 5.6</strong></p>
  
  <p>I'm having main report which contain 10 sub-reports and in that one sub-report contain one more sub-report. while publishing main report the sub-report which is present under sub-report is get exclude by jasper studio. I don't understand why?  </p>
  
  <p>I don't understand its an error or i'm missing anything in report.
  When i'm publishing my report it says 'Successfully done!' but in jasper server it gives and error ie: </p>
  
  <blockquote>
    <p>The server has encountered an error. Please excuse the inconvenience.</p>
    
    <p>Error Message</p>
    
    <p>com.jaspersoft.jasperserver.api.JSException: Error filling report</p>
    
    <p>Error Trace</p>
    
    <p>com.jaspersoft.jasperserver.api.JSException: Error filling report at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1178) at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:211) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:135) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:859) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:821) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1622) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1005) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:881) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: Resource not found at : POS_Billing_DSR_Subreport_Type2.jasper at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:255) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:328) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:361) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:286) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:459) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2044) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeader(JRVerticalFiller.java:639) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeaders(JRVerticalFiller.java:561) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:286) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) ... 9 more</p>
    
    <p>Error Message</p>
    
    <p>net.sf.jasperreports.engine.JRException: Resource not found at : POS_Billing_DSR_Subreport_Type2.jasper</p>
    
    <p>Error Trace</p>
    
    <p>net.sf.jasperreports.engine.JRException: Resource not found at : POS_Billing_DSR_Subreport_Type2.jasper at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:255) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:328) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:361) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:286) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:459) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2044) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeader(JRVerticalFiller.java:639) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeaders(JRVerticalFiller.java:561) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:286) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:859) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:821) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1622) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1005) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:881) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)</p>
  </blockquote>
  
  <p><strong><em>The Solution for this is:
  add the repo and jrxml in the published reports eg: "repo:Sureport_Name.jrxml"</em></strong></p>
  
  <p>this happens every time when i publish report and it happens for few reports. every time i cant update repo and jasper to jrxml.</p>
  
  <p><strong>I tried solution for it is
  1. deleted all report from server and myExport folder and re-published again but doesn't work
  2. tried to add path in report but that also doesn't work and this ll be not proper soln for me cause i'm going to use that myExport folder in other places 
  3. reinstalled s/w but didn't worked</strong></p>
  
  <p><strong>EDIT jrxml</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!-- Created with Jaspersoft Studio version last--&gt;
  &lt;jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="POS_Billing_DailySalesReport_Type2" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="0" uuid="ddaeb9ca-aae7-4e61-9615-f25f60294adb"&gt;
      &lt;property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/"/&gt;
      &lt;property name="ireport.jasperserver.user" value="jasperadmin"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1" value="columnHeader"/&gt;
      &lt;property name="net.sf.jasperreports.export.csv.exclude.origin.band.2" value="pageFooter"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.0101" value="columnHeader"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.report.0101" value="POS_Billing_DSR_Subreport_Type2"/&gt;
      &lt;property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.band.0101" value="columnHeader"/&gt;
      &lt;property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.report.0101" value="POS_Billing_DSR_Subreport_Type2"/&gt;
      &lt;property name="ireport.jasperserver.report.resource" value="/reports/SMARTORDER_REPORTS/SMARTORDER_BILLING_DSR/POS_Billing_DailySalesReport_Type2_files/main_jrxml"/&gt;
      &lt;property name="ireport.jasperserver.reportUnit" value="/reports/SMARTORDER_REPORTS/SMARTORDER_BILLING_DSR/POS_Billing_DailySalesReport_Type2"/&gt;
      &lt;property name="com.jaspersoft.studio.data.defaultdataadapter" value="POSConnection"/&gt;
      &lt;parameter name="fromDate" class="java.lang.String"&gt;
          &lt;parameterDescription&gt;&lt;![CDATA[]]&gt;&lt;/parameterDescription&gt;
      &lt;/parameter&gt;
      &lt;parameter name="toDate" class="java.lang.String"/&gt;
      &lt;parameter name="hotelName" class="java.lang.String"/&gt;
      &lt;parameter name="foodCategory" class="java.lang.String"&gt;
          &lt;defaultValueExpression&gt;&lt;![CDATA["18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,38,39,40,41"]]&gt;&lt;/defaultValueExpression&gt;
      &lt;/parameter&gt;
      &lt;parameter name="wineFoodCategory" class="java.lang.String"&gt;
          &lt;defaultValueExpression&gt;&lt;![CDATA["14"]]&gt;&lt;/defaultValueExpression&gt;
      &lt;/parameter&gt;
      &lt;parameter name="coldDrinkFoodCategory" class="java.lang.String"&gt;
          &lt;defaultValueExpression&gt;&lt;![CDATA["17,37"]]&gt;&lt;/defaultValueExpression&gt;
      &lt;/parameter&gt;
      &lt;parameter name="liquorFoodCategory" class="java.lang.String"&gt;
          &lt;defaultValueExpression&gt;&lt;![CDATA["1,2,3,4,5,6,7,8,9,10,11,12,13,15,16"]]&gt;&lt;/defaultValueExpression&gt;
      &lt;/parameter&gt;
      &lt;parameter name="companyId" class="java.lang.String"/&gt;
      &lt;parameter name="IsExcelExport" class="java.lang.Integer"/&gt;
      &lt;queryString&gt;
          &lt;![CDATA[Select 1 from Dual]]&gt;
      &lt;/queryString&gt;
      &lt;field name="1" class="java.lang.Long"/&gt;
      &lt;group name="DSR_Group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="50" splitType="Immediate"&gt;
                  &lt;subreport&gt;
                      &lt;reportElement isPrintRepeatedValues="false" x="-20" y="0" width="842" height="50" isRemoveLineWhenBlank="true" uuid="1d4602df-49db-47be-84ad-ad22c861f068"/&gt;
                      &lt;subreportParameter name="hotelName"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{hotelName}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="coldDrinkFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{coldDrinkFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="wineFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{wineFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="liquorFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{liquorFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="IsExcelExport"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{IsExcelExport}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_DSR_Subreport_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="Cancel_Bill"&gt;
          &lt;groupHeader&gt;
              &lt;band height="50"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="842" height="50" isRemoveLineWhenBlank="true" uuid="718a14a1-286e-4c06-9f2b-9381b0c2a0e7"/&gt;
                      &lt;subreportParameter name="hotelName"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{hotelName}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="coldDrinkFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{coldDrinkFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="wineFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{wineFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="liquorFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{liquorFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_Cancelled_Bill_Subreport_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="NC_Group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="50"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="842" height="50" isRemoveLineWhenBlank="true" uuid="498c51ae-a361-4c0f-98e4-e05d973da8ff"/&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="coldDrinkFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{coldDrinkFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="wineFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{wineFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="liquorFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{liquorFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_DailyNCReport_Subreport_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="Cancel_KOT_Group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="50"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="841" height="50" uuid="67c9d02f-cf0e-46f7-a072-31e94e5d0a60"/&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodcategoryId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_Cancelkot_Subreport_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="Cancel_BOT_Group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="50"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="841" height="50" uuid="be1c0cf4-a1c7-4cd7-b0cd-cff0b06fa124"/&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_Cancelbot_Subreport_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="Reprint_Bills"&gt;
          &lt;groupHeader&gt;
              &lt;band height="50"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="841" height="50" uuid="556e3c56-0683-41ed-98aa-01a9d888fdb0"/&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_reprintbill_Subreport_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="Summary_Group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="50"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="841" height="50" uuid="6cd3ce43-0edc-40ee-87e3-e499a178af60"/&gt;
                      &lt;subreportParameter name="coldDrinkFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{coldDrinkFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="wineFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{wineFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="liquorFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{liquorFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_DSR_Summary_Subreport1_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="summarycancel_Group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="57"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="842" height="57" isRemoveLineWhenBlank="true" uuid="599a967c-7970-4285-bada-db370e285b5d"/&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="coldDrinkFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{coldDrinkFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="wineFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{wineFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="liquorFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{liquorFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_DSR_Summary_Subreport3_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="SummaryNC_group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="51"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="842" height="51" isRemoveLineWhenBlank="true" uuid="8779a930-536d-4215-a99d-96ed55b9303e"/&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="coldDrinkFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{coldDrinkFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="wineFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{wineFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="liquorFoodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{liquorFoodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="foodCategory"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{foodCategory}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_DSR_Summary_Subreport2_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="companyaccount_group"&gt;
          &lt;groupHeader&gt;
              &lt;band height="49"&gt;
                  &lt;printWhenExpression&gt;&lt;![CDATA[$P{IsExcelExport}==0]]&gt;&lt;/printWhenExpression&gt;
                  &lt;subreport&gt;
                      &lt;reportElement x="-20" y="0" width="841" height="49" isRemoveLineWhenBlank="true" uuid="8d2cde54-2c95-4912-8498-5edd50111ffd"/&gt;
                      &lt;subreportParameter name="fromDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{fromDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="toDate"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{toDate}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;subreportParameter name="companyId"&gt;
                          &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{companyId}]]&gt;&lt;/subreportParameterExpression&gt;
                      &lt;/subreportParameter&gt;
                      &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;subreportExpression&gt;&lt;![CDATA["POS_Billing_CompanyNamewise_Subreport_Type2.jasper"]]&gt;&lt;/subreportExpression&gt;
                  &lt;/subreport&gt;
              &lt;/band&gt;
          &lt;/groupHeader&gt;
      &lt;/group&gt;
      &lt;group name="Group1"/&gt;
      &lt;title&gt;
          &lt;band height="41" splitType="Stretch"&gt;
              &lt;line direction="BottomUp"&gt;
                  &lt;reportElement x="-20" y="40" width="842" height="1" uuid="4338177c-bab1-4305-b8ee-495c03aa9e22"&gt;
                      &lt;property name="local_mesure_unitheight" value="pixel"/&gt;
                      &lt;property name="com.jaspersoft.studio.unit.height" value="px"/&gt;
                  &lt;/reportElement&gt;
              &lt;/line&gt;
              &lt;textField&gt;
                  &lt;reportElement x="-20" y="0" width="842" height="19" uuid="017a4739-0ade-4f16-9ddd-630f0fb0e075"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                      &lt;font fontName="Times New Roman" size="16" isBold="true" pdfFontName="Helvetica"/&gt;
                  &lt;/textElement&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA[$P{hotelName}+" "+" Daily Sales Report"]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
              &lt;textField pattern="MMMMM dd, yyyy"&gt;
                  &lt;reportElement x="-20" y="19" width="842" height="17" uuid="f318ec8d-2fad-40d7-8f79-ee7fd4a1b7f5"/&gt;
                  &lt;box rightPadding="5"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                      &lt;font size="12"/&gt;
                  &lt;/textElement&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA["From :"+" "+$P{fromDate}+" "+"To :"+" "+$P{toDate}]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
          &lt;/band&gt;
      &lt;/title&gt;
  &lt;/jasperReport&gt;
  </code></pre>