Do I have to use subreports or not

[2002 JI Open Discussion]

By: Muralidhar bp - pmurli

Do I have to use subreports or not

2003-01-12 04:44

Hi,

 

I have a query like this which reads 2 tables...

 

SELECT TF_PAR_BRANCH_PERSONALIZATION.BRANCH_CODE,TF_PAR_BRANCH_PERSONALIZATION.BRANCH_NAME, COUNT(TF_M_CUSTOMER.CUSTOMER_ID) AS CUSTOMERCOUNT FROM TF_PAR_BRANCH_PERSONALIZATION, TF_M_CUSTOMER WHERE TF_PAR_BRANCH_PERSONALIZATION.BRANCH_CODE=TF_M_CUSTOMER.BRANCH_CODE GROUP BY TF_PAR_BRANCH_PERSONALIZATION.BRANCH_CODE, TF_PAR_BRANCH_PERSONALIZATION.BRANCH_NAME

 

Do I have to use subreports or not

 

The error i am getting is...

 

java.sql.SQLException: Column not found

at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java:1790)

at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:383)

at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:263)

at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:702)

at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:158)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:457)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:373)

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)

at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138)

at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106)

at servlets.ListOfCustomerNumberServlet.service(ListOfCustomerNumberServlet.java:68)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:263)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)

at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2390)

at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1959)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

 

NESTED BY :

dori.jasper.engine.JRException: Unable to get value for field 'CUSTOMER_ID' of class 'java.lang.String'

at dori.jasper.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:272)

at dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:702)

at dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:158)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:457)

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:373)

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)

at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138)

at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106)

at servlets.ListOfCustomerNumberServlet.service(ListOfCustomerNumberServlet.java:68)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:263)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:200)

at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2390)

at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:1959)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)

 

 

 

 

 

 

 

 

 

 

By: Teodor Danciu - teodord

RE: Do I have to use subreports or not

2003-01-25 02:40

 

Hi,

 

As you can see, you have renamed the

CUSTOMER_ID column CUSTOMERCOUNT

using an alias in the SELECT.

 

The engine does not find a matching column

in the ResultSet for your report field.

 

I hope this helps.

Teodor