Databases
StackOverflow2013
Postsdbo
POError when I use an aggregate function count in my report using JPQL language
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError when I use an aggregate function count in my report using JPQL language
    text
    copied!<p>Somthing happened to my account (I can't access to it !!!!),so I will ask again my question :( I can't use an aggregate function in my JPQL request in my report: <strong>this is my report.jrxml</strong></p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&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="Test" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"&gt; &lt;property name="ireport.zoom" value="1.0"/&gt; &lt;property name="ireport.x" value="0"/&gt; &lt;property name="ireport.y" value="0"/&gt; &lt;parameter name="priority" class="java.lang.String"&gt; &lt;defaultValueExpression&gt;&lt;![CDATA[]]&gt;&lt;/defaultValueExpression&gt; &lt;/parameter&gt; &lt;queryString language="ejbql"&gt; **&lt;![CDATA[select count(j) as nb from Jiraissue j where j.priority='3']]&gt;** &lt;/queryString&gt; &lt;field name="nb" class="java.lang.Long"/&gt; &lt;background&gt; &lt;band splitType="Stretch"/&gt; &lt;/background&gt; &lt;title&gt; &lt;band height="79" splitType="Stretch"&gt; &lt;/band&gt; &lt;/title&gt; &lt;pageHeader&gt; &lt;band height="35" splitType="Stretch"/&gt; &lt;/pageHeader&gt; &lt;columnHeader&gt; &lt;band height="84" splitType="Stretch"&gt; &lt;staticText&gt; &lt;reportElement x="28" y="0" width="100" height="20"/&gt; &lt;textElement/&gt; &lt;text&gt;&lt;![CDATA[nb]]&gt;&lt;/text&gt; &lt;/staticText&gt; &lt;/band&gt; &lt;/columnHeader&gt; &lt;detail&gt; &lt;band height="125" splitType="Stretch"&gt; &lt;textField&gt; &lt;reportElement x="50" y="11" width="100" height="20"/&gt; &lt;textElement/&gt; &lt;textFieldExpression class="java.lang.Long"&gt; &lt;![CDATA[$F{nb}]]&gt;&lt;/textFieldExpression&gt; &lt;/textField&gt; &lt;/band&gt; &lt;/detail&gt; &lt;columnFooter&gt; &lt;band height="45" splitType="Stretch"/&gt; &lt;/columnFooter&gt; &lt;pageFooter&gt; &lt;band height="54" splitType="Stretch"/&gt; &lt;/pageFooter&gt; &lt;summary&gt; &lt;band height="42" splitType="Stretch"/&gt; &lt;/summary&gt; &lt;/jasperReport&gt; </code></pre> <p>My code java:</p> <pre><code>public static void main(String[] args) { EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("JiraMapPU"); EntityManager entityManager = entityManagerFactory.createEntityManager(); Map parameterMap = new HashMap(); parameterMap.put(JRJpaQueryExecuterFactory.PARAMETER_JPA_ENTITY_MANAGER, entityManager); //parameterMap.put("priority","3"); try { JasperReport report = JasperCompileManager.compileReport("C:/Documents and Settings/a497165/My Documents/NetBeansProjects/JiraMap/src/java/Reports/Test.jrxml"); JasperPrint print = JasperFillManager.fillReport(report,parameterMap); JasperExportManager.exportReportToPdfFile(print,"C:/Documents and Settings/a497165/My Documents/NetBeansProjects/JiraMap/src/java/Reports/Test.pdf"); } catch (JRException ex) { ex.printStackTrace(); } </code></pre> <p><strong>The error:</strong></p> <pre><code>net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : nb at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDat aSource.java:123) at net.sf.jasperreports.engine.data.JRJpaDataSource$PropertyReader.getValue(JRJpaDataSource.java:206) at net.sf.jasperreports.engine.data.JRJpaDataSource.getFieldValue(JRJpaDataSource.java:131) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:821) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:785) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1482) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:118) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435) at Reporting.ReportBean.main(ReportBean.java:41) Caused by: java.lang.NoSuchMethodException: Unknown property 'nb' on class 'class java.lang.Long' </code></pre> <p>Any help please :((</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload