2002 JI Open Discussion

By: Angelo Rafael de Melo D'Alessa - angelorafael NoClassDefFoundError on Solaris 2003-02-06 08:23 I am using jasperreports in W2K and it works fine. But in Solaris i get the atached message java.lang.NoClassDefFoundError: dori/jasper/engine/fill/JRVerticalFiller All the jars are in the classpath . Someone could help me ? By: Teodor Danciu - teodord RE: NoClassDefFoundError on Solaris 2003-02-06 10:07 Hi, This seems to be the solution: https://sourceforge.net/tracker/index.php?func=detail&aid=640874&group_id=36382&atid=416705 Apparently, you have to recompile the jasperreports.jar on Solaris. Thank you, Teodor

By: remi - rpeyret IllegalStateException in R( + /jsp/image.jsp 2003-02-06 09:37 OK I succeed to launch my application... The jasperreports works well but I have got this error : Ctx() : IllegalStateException in R( + /jsp/image.jsp + null) - java.lang.IllegalStateException: getOutputStream() has already been called at org.apache.tomcat.facade.HttpServletResponseFacade.getWriter(Unknown Source) at org.apache.jasper.runtime.JspWriterImpl.initOut(Unknown Source) at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(Unknown Source) at jsp.image_1._jspService(image_1.java:102) On my NT server, it doesn't mind, but on my linux server, I've got this error message on my browser. I don't have any idea, can you help me ? thx By: Chuck Deal - cdeal RE: IllegalStateException in R( + /jsp/image.jsp 2003-02-06 09:53 There is a predefined "OutputStream" in each JSP page called out. You could also get a handle to the response's outputStream(response.getOutputStream()). HOWEVER, you can't do both on the same page. If you are going to use response.getOutputStream() DON'T use out.xxx() anywhere else on the page. The first time you use it, it gets initialized. At least, this is how it is in my configuration (iPlanet 4.1).

By: Mark Smith - paddysmith MS SQL Server JDBC connect problem 2003-02-06 05:00 Hi, I am trying to run the demo sample “Query” in the 0.45. The problem occur when I try to run the ant fill target on MS SQL Server with a new JDBC driver. I have installed the exact same data and tables on both the provided hsqldb and the MS SQL server (created a database test and migrated the table and data input script to run on both servers) I have updated the getConnction method with the following. //String driver = "org.hsqldb.jdbcDriver"; //String connectString = "jdbc:hsqldb:hsql://localhost"; String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; String connectString = "jdbc:microsoft:sqlserver://cgsnextbigthing:1433;DatabaseName=racts2"; I receive the error message: fill: [java] java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Object has been closed. [java] at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) [java] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) [java] at com.microsoft.jdbc.base.BaseResultSet.validateClosedState(Unknown Source) [java] at com.microsoft.jdbc.base.BaseResultSet.getStatement(Unknown Source) [java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381) [java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114) [java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106) [java] at QueryApp.main(QueryApp.java:148) [java] NESTED BY : [java] dori.jasper.engine.JRException: Error closing ResultSet or Statement for report data source : QueryReport [java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:390) [java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114) [java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138) [java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106) [java] at QueryApp.main(QueryApp.java:148) Any help will be appreciated. The JDBC driver works fine for other applications. Mark By: Teodor Danciu - teodord RE: MS SQL Server JDBC connect problem 2003-02-06 05:39 Hi, OK. I get it now. I'll post a patch for this. Thank you, Teodor By: Teodor Danciu - teodord RE: MS SQL Server JDBC connect problem 2003-02-06 06:00 The patch is here: https://sourceforge.net/tracker/index.php?func=detail&aid=681655&group_id=36382&atid=416705 Thank you, Teodor

By: elmar weber - elmar_weber Pagewide element positioning 2003-02-06 05:07 Hello, I'd like to place elements somewhere at the page regardless of bands and columns and so an. E.g.: I want in the middle of the page a cross but the title band doesnt reach until the middle and the header and footer not, too. So there is always the detail section. The only way I figure out is, afaik, to count the detail lines and if the current detail line is the closest to the middle print it there (e.g. page is 800 pixel height, top margin 50, header 150, detail band 20; it must be the 10th detail band to ensure that it is the middle). But then there is still a problem if there a less detail lines than neccessary. Thanks in advance, Elmar

By: remi - rpeyret How use jasper without X server ??? 2003-02-06 04:52 I just finished to develop my application and it works fine on my own NT and linux server. But I want to install it on a platform and I have got this error : Can't connect to X11 window server using 'localhost:0.0' as the value of the DISPLAY variable I try several things, export DISPLAY, setenv DISPLAY but it doesn't work. I can't launch Xbvf or xhost + because these commands are unknown. Is there any other way ???

By: Cetin Ergen - cetin Problems with PDF generation from webapp 2003-01-30 10:57 Hi, i have incorparated the a Servlet in our webapp to generate PDF with JasperReports (0.4.5). But the generated PDF contains no pages !!! If i compile and view the report with iReport its all OK. Can any one help! Thanks ǥtin Ergen By: Neil H - neilhay RE: Problems with PDF generation from webapp 2003-01-31 12:34 I had same problem before with iReport. Sometime iReport and Jasper X & Y dimission are not correct. try to play with XML file. By: Rajan Karunakaran - rkaran RE: Problems with PDF generation from webapp 2003-02-05 13:05 Have you added the isStretchWithOverflow attribute to your textField elements? <textField isStretchWithOverflow="true"> <>.....</> </textField>

By: Martin Duclos - tchitow Problem with Integer object in report 2003-02-04 13:18 I am getting data from a database. Some of the fields that are coming from the database are Integers. When I try using those in the report, I always get the value 0. I have verified that the value in the db isn't 0 but is in fact a number != 0. The only way I can get this to work is by adding the following to my sql statement: concat( '', someIntegerField ) This seems to force the returned value to be a string that gives the desired results in the report. This works for now, but there has to be a better way to make this work. By: Teodor Danciu - teodord RE: Problem with Integer object in report 2003-02-05 00:18 Hi, What database and what JDBC driver are we talking about? Try to make a small Java program that executes a query and retrieves the same values from the ResultSet. It might be not related to JasperReports. Thank you, Teodor By: Martin Duclos - tchitow RE: Problem with Integer object in report 2003-02-05 09:31 Thanx for the reply. I'm getting the data from a mysql database. I tried making a simple report with just the one text field that I wasn't getting right in the big report. After hours of thinking, I realized that the query involved 2 tables. Thoses two tables each contain a field with the same name. To slove the problem: select *, someTable.someField as anotherNameForField from someTable, someTable2 and Voila!

By: eric teo - duckizz trying to run webappdatasource sample 2003-02-05 00:12 hi , i tried to run the webappdatasource sample, but i got this error java.io.InvalidClassException: dori.jasper.engine.base.JRBaseReport; local class incompatible: stream classdesc serialVersionUID = 405, local class serialVersionUID = 402 any clues ? By: Teodor Danciu - teodord RE: trying to run webappdatasource sample 2003-02-05 00:27 Hi, Somewhere in your classpath, you have an older version of the jasperreports.jar file. You are trying to fill a report that is compiled with the 0.4.5 using this older version of the library. I hope this helps. Teodor By: eric teo - duckizz RE: trying to run webappdatasource sample 2003-02-05 00:51 yea thanks it works ! =)

By: Angelo Rafael de Melo D'Alessa - angelorafael Error on Solaris 2003-02-04 04:53 I'm using Jasper on Soaris with WebSphere 3.5 and when i was trying to get a Html Report. The error go below : [03.02.04 08:29:53:497 GMT-04:00] f78c48 WebGroup X Root Cause java.lang.InternalError: Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable. at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method) at <Unloaded Method> at java.lang.Class.forName0(Native Method) at java.lang.Class.forName0(Compiled Code) at java.lang.Class.forName(Compiled Code) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:63) at <Unloaded Method> at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:109) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217) at com.po.jasper.RelatorioConsolidadoAcessos.constroiRelatorio(RelatorioConsolidadoAcessos.java:58) at com.po.business.ControladorRelatorios.constroiRelatorioConsolidado(ControladorRelatorios.java:26) at com.po.facade.SistemaPaymentOrder.constroiRelatorioConsolidado(SistemaPaymentOrder.java:198) at com.po.struts.action.ImprimirAction.relatorioConsolidadoAcesso(ImprimirAction.java:125) at com.po.struts.action.ImprimirAction.perform(ImprimirAction.java:60) at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at com.po.struts.action.SistemaPaymentOrderActionServlet.doGet(SistemaPaymentOrderActionServlet.java:42) at javax.servlet.http.HttpServlet.service(Compiled Code) at javax.servlet.http.HttpServlet.service(Compiled Code) at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(Compiled Code) at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(Compiled Code) at com.ibm.servlet.engine.webapp.IdleServletState.service(Compiled Code) at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(Compiled Code) at com.ibm.servlet.engine.webapp.ServletInstance.service(Compiled Code) at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Compiled Code) at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(Compiled Code) at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(Compiled Code) at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(Compiled Code) at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(Compiled Code) at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(Compiled Code) at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(Compiled Code) at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Compiled Code) at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Compiled Code) at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(Compiled Code) at com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(Compiled Code) at com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(Compiled Code) at com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(Compiled Code) at com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.notifyService(Compiled Code) at com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.run(Compiled Code) at com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run(Compiled Code) at java.lang.Thread.run(Thread.java:479) Someone could help me ? tanks Angelo Rafael By: Teodor Danciu - teodord RE: Error on Solaris 2003-02-04 05:01 Hi, Go to this forum, and type X11 in the upper left search textbox https://sourceforge.net/forum/forum.php?forum_id=113529 You'll find your solution. Thank you, Teodor

By: Richard Attermeyer - attermr Printing variable number of "subentries" 2003-02-04 02:07 Hi, we are currently facing the following problem: We have an entitity Activity that has a 1-n relation with entity LogEntry. We implement our own datasource to print the activities, now we want to print the log entries for each activity. Is that possible and how could we achieve this? The report should look like (simplified) Number Author task 1 Richard GAAD proposal LogEntries 01/12/03 phoned Jack 01/13/03 met Joe ------------------------------------------------------- 2 Michael cost estimation Log Entries 01/23/03 phoned Joe 01/24/03 reviewed requirements 02/01/03 edited requirements

By: Carlos Lizarralde - clizarralde class found excepcion 2003-02-03 12:41 Hi, I am using Jasper Reports 0.3.3 and it works fine over W2k but when I move it to Solaris (our testing environment) I get a class not found exception at SAX driver class. It's quite strange. Any suggestions? By: Teodor Danciu - teodord RE: class found excepcion 2003-02-04 00:02 Hi, When moving to Solaris, make sure you move also all the required libraries, like xerces.jar for example. Make sure that in the new environment, the classpath is correct. I hope this helps. Teodor

By: Jessica Daniel - jrdatorbital Problem formating textfields 2003-02-03 12:26 I am having trouble getting my report to respond to the pattern I have set. I have included the code segment and resulting xml. Any suggestions appreciated. The pattern is stored in a database table and retrieved using a sql result set. Thanks Jessica Code //detail textField = new JRDesignTextField(); if(cInfo.getColumnOrder() == cInfo.getColumnCount()){ textField.setWidth(cInfo.getColumnWidth() + columnInfo.getLastColumnPadding()); }else{ textField.setWidth(cInfo.getColumnWidth() + columnInfo.getColumnPadding()); } textField.setHeight(10); textField.setX(columnInfo.getXColumn()); textField.setY(1); font.setReportFont(fonts[7]); textField.setFont(font); textField.setForecolor(color.BLACK); textField.setPattern(cInfo.getAttribute().getFormat()); textField.setMode(textField.MODE_OPAQUE); textField.setPositionType(textField.POSITION_TYPE_FIX_RELATIVE_TO_TOP); if(cInfo.getAttribute().getJustification().equals("Left")){ textField.setTextAlignment(element.TEXT_ALIGN_LEFT); }else{ textField.setTextAlignment(element.TEXT_ALIGN_RIGHT); } //set textField expression JRDesignExpression expression = new JRDesignExpression(); expression.setText("$F{" + cInfo.getFieldName() + "}"); expression.setName(cInfo.getColumnName()); valueClass = getValueClassName(cInfo.getDataType()); expression.setValueClass(valueClass); textField.setExpression(expression); detailChildren.add(textField); Generated SQL <textField pattern="#0.0" isStretchWithOverflow="false" evaluationTime="Now" isBlankWhenNull="false" hyperlinkType="None"> <reportElement mode="Opaque" x="228" y="1" width="45" height="10" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Right" lineSpacing="Single"> <font reportFont="SubColumn" /> </textElement> - <textFieldExpression class="java.lang.Double"> - <![CDATA[ $F{DrySandRate} ]]> </textFieldExpression> </textField>

By: Jessica Daniel - jrdatorbital Problem formating textfields 2003-02-03 12:11 I am having trouble getting my report to respond to the pattern I have set. I have included the code segment and resulting xml. Any suggestions appreciated. The pattern is stored in a database table and retrieved using a sql result set. Thanks Jessica Code //detail textField = new JRDesignTextField(); if(cInfo.getColumnOrder() == cInfo.getColumnCount()){ textField.setWidth(cInfo.getColumnWidth() + columnInfo.getLastColumnPadding()); }else{ textField.setWidth(cInfo.getColumnWidth() + columnInfo.getColumnPadding()); } textField.setHeight(10); textField.setX(columnInfo.getXColumn()); textField.setY(1); font.setReportFont(fonts[7]); textField.setFont(font); textField.setForecolor(color.BLACK); textField.setPattern(cInfo.getAttribute().getFormat()); textField.setMode(textField.MODE_OPAQUE); textField.setPositionType(textField.POSITION_TYPE_FIX_RELATIVE_TO_TOP); if(cInfo.getAttribute().getJustification().equals("Left")){ textField.setTextAlignment(element.TEXT_ALIGN_LEFT); }else{ textField.setTextAlignment(element.TEXT_ALIGN_RIGHT); } //set textField expression JRDesignExpression expression = new JRDesignExpression(); expression.setText("$F{" + cInfo.getFieldName() + "}"); expression.setName(cInfo.getColumnName()); valueClass = getValueClassName(cInfo.getDataType()); expression.setValueClass(valueClass); textField.setExpression(expression); detailChildren.add(textField); Generated SQL <textField pattern="#0.0" isStretchWithOverflow="false" evaluationTime="Now" isBlankWhenNull="false" hyperlinkType="None"> <reportElement mode="Opaque" x="228" y="1" width="45" height="10" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> - <textElement textAlignment="Right" lineSpacing="Single"> <font reportFont="SubColumn" /> </textElement> - <textFieldExpression class="java.lang.Double"> - <![CDATA[ $F{DrySandRate} ]]> </textFieldExpression> </textField>

By: Muralidhar bp - pmurli How to change the page header at run time 2003-02-03 05:24 Hi, I have a report where in it has messages which can go up to 10000 lines. My job is to provide the page break after every message and next message has to start from the new page with different header data. So please tell me how to provide the page break after each message and change the page header at the starting of the new message. Thanx Murli

By: Muralidhar bp - pmurli Servlet as my Data Source 2003-02-03 03:00 Hello, I have to retrieve the data from the database and the data is CLOB. So, can I write a servlet as my data source. Thanks Murli

By: Moisey Blehman - rhal Using import classes in xml 2003-01-31 01:47 Hi, How can I import my own classes (not only lang and util) in order to use them inside of xml? I'am aware that one can use non default classes through scriplets, but can this be done without scriplets use? Thanks for advice By: Teodor Danciu - teodord RE: Using import classes in xml 2003-01-31 02:40 Hi, You only have to use the entire class name in the report expressions (including the package). That's all. No import statements needed. I hope this helps. Teodor By: Moisey Blehman - rhal RE: Using import classes in xml 2003-02-01 05:19 Thank you very much - that really helped a lot. ^_^

By: elmar weber - elmar_weber Divided field (isStretchWithOverflow) 2003-02-01 04:22 Hello, I have ha problem with isStretchWithOverflow activated on a textField in the detail section. It works very well but if the current detail line exceeds the maximum page column height some lines are printed on a page and the last few an the next. Here is an examples screenshot of what i mean: http://www.sniper-lan.de/files/extern/images/jasperReportsExamplePicture-20030201.jpeg You'll recognize that three lines are printed on the next page ("Ihre TSS-Nr ...." belongs to the last detail row of the first page). How can I prevent this? Thanks in advance, Elmar Weber

By: Neil H - neilhay Issue with chart image loading in PDF 2003-01-31 12:25 I am playing around with sample "ChartApp" in Jasper Samples, I get following error: ******************************************************************************* * WARNING: Failure using Thread.currentThread().getContextClassLoader() * * in JRImageLoader class. Using JRImageLoader.class.getClassLoader() instead. * () dori.jasper.engine.JRException: Image not found : ((java.awt.Image)variable_ChartImage.getValue()) What does it mean? By: Teodor Danciu - teodord RE: Issue with chart image loading in PDF 2003-02-01 00:23 Hi, The <imageExpression> element has a "class" attribute. Use class="java.awt.Image" and not the default class="java.lang.String". I hope this helps. Teodor

By: Michel - micheljr Fatal Error during design 2003-01-31 10:42 Hi, I was designing a report and all of a sudden occured the following error: Start of root element expected instead of TEXT ' null" This error damaged my xml file. Now I can't open or edit it. Obs.: I was using a very high detail band (about 1100). Anybody knows what happened? Thanks for any help

By: Neil H - neilhay Where do i save the Sciprtlet class? 2003-01-31 09:45 I am using Scriptlet in Japser, and i get CLASSNOTFOUND exception. Where do i need to save the class? My class exists in "C:Program FilesIBMApplication DeveloperworkspacePROJECTwebApplicationWEB-INFclasses"' and I am jasper files are running from c:reports By: Chuck Deal - cdeal RE: Where do i save the Sciprtlet class? 2003-01-31 10:21 You need to fully qualify the class name. xx.yyy.zzzz.className

By: Craig Bowman - cwbowman Ant won't compile samples 2003-01-31 09:28 I don't know if this is a Jasper or Ant issue, but when I try to run ant on the samples, I get the following: BUILD FAILED file:C:/stuff/javastuff/jasper/JasperReports/demo/samples/chart/build.xml:8: Una ble to find a javac compiler; com.sun.tools.javac.Main is not on the classpath. Perhaps JAVA_HOME does not point to the JDK I've checked, re-checked and re-re-checked the environment variables. Also, I can run javac, java, jar and any other JAVA_HOMEbin executable. I'ved moved tools.jar to the lib folder, I've even expressly included it in my classpath to no avail. I am running Windows 2000. Any Ideas? Craig Bowman

By: Craig Bowman - cwbowman Ant won't compile samples 2003-01-31 07:37 I don't know if this is a Jasper or Ant issue, but when I try to run ant on the samples, I get the following: BUILD FAILED file:C:/stuff/javastuff/jasper/JasperReports/demo/samples/chart/build.xml:8: Una ble to find a javac compiler; com.sun.tools.javac.Main is not on the classpath. Perhaps JAVA_HOME does not point to the JDK I've checked, re-checked and re-re-checked the environment variables. Also, I can run javac, java, jar and any other JAVA_HOMEbin executable. I'ved moved tools.jar to the lib folder, I've even expressly included it in my classpath to no avail. I am running Windows 2000. Any Ideas? Craig Bowman

By: Craig Bowman - cwbowman Ant won't compile samples 2003-01-31 05:30 I don't know if this is a Jasper or Ant issue, but when I try to run ant on the samples, I get the following: BUILD FAILED file:C:/stuff/javastuff/jasper/JasperReports/demo/samples/chart/build.xml:8: Una ble to find a javac compiler; com.sun.tools.javac.Main is not on the classpath. Perhaps JAVA_HOME does not point to the JDK I've checked, re-checked and re-re-checked the environment variables. Also, I can run javac, java, jar and any other JAVA_HOMEbin executable. I'ved moved tools.jar to the lib folder, I've even expressly included it in my classpath to no avail. I am running Windows 2000. Any Ideas? Craig Bowman

By: Theo Heinrichs - theofrombonn Large Subreport fills pages 2..n incompletely 2003-01-31 04:20 Hello, I must print a large report, consisting of a text section of about half a page, then a a subreport of one to many pages, and finally another text section of about half a page. It resembles a large letter with a dynamic textual body. I.e. the middle part may be only a bit of text up to many pages. I modeled this by putting it all into the detail band and created an appropriate data source for it. The middle part is a subreport with a separate data source, which works well so far. On the first page of the report, the page is nicely filled. However, the subsequent pages are only filled by half, and the text length is about the same size as it was on the first page. The last page contains the rest of the middle portion plus the final text section, which looks ok as well. So, the pages 2 to n-1 are only filled halfways. This looks like a bug to me. Teodor, can you please comment? The reportElement in the subreport element has a height of 10, i.e. I want it to stretch downwards matching the total text length. I did not find any further option to determine the subreport text size. Thanks in advance, best regards, Theo

By: Muralidhar bp - pmurli Very Urgent 2003-01-31 03:45 Hello, I have a problem in web report, please try to solve this. I have a query Select col1, col2, col3, col4 from table1 where col1=xxxxxxxxxxxx; From the resultset i want to put col1, col2 and col3 info as a report header info and col4 data in the <queryString>. Please tell me how to proceed with this. . Do I have to write a query in the servlet class and get the resultset and pass the result set to the <querystring> tag. . Can I have the query in the xml file (<querystring>) and pass this to the <header> tag and <detail> tag. Please help me, I dont know how to proceed with this. Thanks Murli