2002 JI Open Discussion

By: ding city - ding123 Applet problem in demo/samples/webapp 2003-01-20 22:14 Hi, Browser is Swing enabled . but, when i open "Embedded Viewer Applet" to link viewer.html page, it show FileNotFoundException as fellowing: java.io.FileNotFoundException:http://localhost:8080/jasper/webapp/servlets/jasperprint at sun.net.www.protocal.http.HttpURL Connection.getInptStream(Unknown Source) at sun.plugin.net.protocal.http.HttpURLConnection.getInputStream(Unknown Source) at java.net.URL.openStream(Unknown Source) at dori.jasper.engine.util.JRLoader.LoadObject(JRLoader.java:147) at EmbeddedViewerApplet.init(EmbeddedViewApplet.java:112) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) NESTED BY: dori.jasper.engine.JRException:Error loading object from URL:http://localhost:8080//jasper/webapp/servlets/jasperprint at dori.jasper.engine.util.JRLoader.loadObject(JRLoader.java:155) (EmbeddedViewApplet.java:112) at sun.applet.AppletPanel.run(Unknown Source) at java.lang.Thread.run(Unknown Source) What might be the reason for such behavior? thanks. By: Teodor Danciu - teodord RE: Applet problem in demo/samples/webapp 2003-01-25 01:11 Hi, Check to see if the "jasperprint" servlet is working. You can do this by calling the servlet URL in the browser and if everything is OK, the browser will ask you to save a .jrprint file on disk. I hope this helps. Teodor

By: lovish Durbha - lovish Out Of Memory Error 2003-01-23 08:10 I have 1 main report and 2 sub reports in it while compiling it throws " out of memory error" please help Lovish By: Teodor Danciu - teodord RE: Out Of Memory Error 2003-01-24 06:42 Hi, You mean when filling the report, not when compiling... If it is about the filling process, then it might be that the program enters an infinite loop. The most probable cause for this is that you have a subrepot that either has too large bands or it is placed too low on the page in the master report, or both. If it is the case, then engine will try in vain to start new pages in the master report hoping that the subreport will fit on the next one. It enters an infinite loop. This is rather a design/layout problem that the library cannot check beforehand. You sould try to verify this scenario. It might be that simply removing the page margins in the subreport (you don't need them, do you) or split the large bands using the tip proposed in the docs might solve such problem. I hope this helps. Teodor

By: Muralidhar bp - pmurli noXmlDesignApp example 2003-01-24 01:33 Hello, I want to use the noXmlDesignApp example as a web example. How to proceed with this. Thanx Murli

By: Andreas K䧩 - andreaskaegi formatting float-values in reports 2003-01-23 07:44 hello everybody i want all the float-values in my report with a format like "123'250.40". is there an easy way to do this? thanks, andreas By: Teodor Danciu - teodord RE: formatting float-values in reports 2003-01-23 08:15 Hi, Use the "pattern" attribute of the text field element. I hope this helps. Teodor

By: Andreas K䧩 - andreaskaegi formatting float-values in reports 2003-01-23 08:07 hello everybody i want all the float-values in my report with a format like "123'250.40". is there an easy way to do this? thanks, andreas

By: Chuck Deal - cdeal PDF Generation error 2003-01-22 12:37 I have a report defintion that works just fine as far as i can tell. I have been able to view my reports, use different criteria, etc. By all accounts it seems fine. I was even able to generate PDFs from the report, BEFORE. I don't know what happened, perhaps it is related to subreports, but I can't generate PDFs anymore (using JasperRunManager.runReportToPdf) I have successfully used this method before so I don't believe that it is the problem. I can also view the report with data via the JasperViewer. As you can see in the following stack trace, the error is being thown by iText (i am using v0.96). Could this have something to do with subreports? If so, there must be a specific case, because I was able to generate PDFs from this report (that contains subreports) yesterday with no problems and the report definition has barely changed (typos ans such). java.lang.RuntimeException: No valid column line found. at com.lowagie.text.pdf.ColumnText.convertColumn(Unknown Source) at com.lowagie.text.pdf.ColumnText.setColumns(Unknown Source) at com.lowagie.text.pdf.ColumnText.setSimpleColumn(Unknown Source) at com.lowagie.text.pdf.ColumnText.setSimpleColumn(Unknown Source) at dori.jasper.engine.export.JRPdfExporter.exportText(JRPdfExporter.java:975) at dori.jasper.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:316) at dori.jasper.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:270) at dori.jasper.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:214) at dori.jasper.engine.JasperExportManager.exportReportToPdf(JasperExportManager.java:182) at dori.jasper.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:166) at com.csc.aims.reports.JasperController.getPDF(JasperController.java:61) at CodeSnippet_16.run(CodeSnippet_16.java:14) at org.eclipse.jdt.internal.debug.ui.snippeteditor.ScrapbookMain1.eval(ScrapbookMain1.java:14) at java.lang.reflect.Method.invoke(Native Method) at org.eclipse.jdt.internal.debug.ui.snippeteditor.ScrapbookMain.evalLoop(ScrapbookMain.java:48) at org.eclipse.jdt.internal.debug.ui.snippeteditor.ScrapbookMain.main(ScrapbookMain.java:29) Any ideas? By: Chuck Deal - cdeal FOLLOWUP: PDF Generation error 2003-01-23 07:01 Ok, I have found the source of my problem, but I don't know why it is a problem. Here is my textField: <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" x="0" y="15" width="710" height="0"/> <textElement textAlignment="Center"> <font reportFont="CourierNew" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[((com.csc.aims.reports.jasperreports.TESTStepsByStatusScriptlet)$P{REPORT_SCRIPTLET}).getFilterDescription($P{TestInfoType}, $P{TestInfoFilter})]]></textFieldExpression> </textField> I am using a Scriplet and the method that is being called will either return a String or null. I wanted it to return 'null' so that I could use the isBlankWhenNull attribute of the textField. However, when I have this attribute set to true, I can view it with the JasperViewer, but I can't generate a PDF. If I take that attribute off (set to false), I can generate the PDF just fine. What I want to do: I only want this textField to take up space when it "has something to say" therefore, I have set its height to 0 and isStretchWithOverflow="true" to accomodate this. Can you tell me a better way to accomplish this? Perhaps tell me if there is a bug with the way JasperReports is creating the PDF in this case or maybe iText is where the problem lies? For now, I will just suffer with the blank line, but I would prefer not to do it that way. Thanks! By: Teodor Danciu - teodord RE: FOLLOWUP: PDF Generation error 2003-01-23 07:24 Hi, I know what the problem is. Fortunately, you have posted the text field definition. Make the text field height="1". This is a bug that I already fixed for the 0.4.5 version to be released soon. Thank you, Teodor

By: Chuck Deal - cdeal PDF Generation error 2003-01-22 12:37 I have a report defintion that works just fine as far as i can tell. I have been able to view my reports, use different criteria, etc. By all accounts it seems fine. I was even able to generate PDFs from the report, BEFORE. I don't know what happened, perhaps it is related to subreports, but I can't generate PDFs anymore (using JasperRunManager.runReportToPdf) I have successfully used this method before so I don't believe that it is the problem. I can also view the report with data via the JasperViewer. As you can see in the following stack trace, the error is being thown by iText (i am using v0.96). Could this have something to do with subreports? If so, there must be a specific case, because I was able to generate PDFs from this report (that contains subreports) yesterday with no problems and the report definition has barely changed (typos ans such). java.lang.RuntimeException: No valid column line found. at com.lowagie.text.pdf.ColumnText.convertColumn(Unknown Source) at com.lowagie.text.pdf.ColumnText.setColumns(Unknown Source) at com.lowagie.text.pdf.ColumnText.setSimpleColumn(Unknown Source) at com.lowagie.text.pdf.ColumnText.setSimpleColumn(Unknown Source) at dori.jasper.engine.export.JRPdfExporter.exportText(JRPdfExporter.java:975) at dori.jasper.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:316) at dori.jasper.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:270) at dori.jasper.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:214) at dori.jasper.engine.JasperExportManager.exportReportToPdf(JasperExportManager.java:182) at dori.jasper.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:166) at com.csc.aims.reports.JasperController.getPDF(JasperController.java:61) at CodeSnippet_16.run(CodeSnippet_16.java:14) at org.eclipse.jdt.internal.debug.ui.snippeteditor.ScrapbookMain1.eval(ScrapbookMain1.java:14) at java.lang.reflect.Method.invoke(Native Method) at org.eclipse.jdt.internal.debug.ui.snippeteditor.ScrapbookMain.evalLoop(ScrapbookMain.java:48) at org.eclipse.jdt.internal.debug.ui.snippeteditor.ScrapbookMain.main(ScrapbookMain.java:29) Any ideas? By: Chuck Deal - cdeal FOLLOWUP: PDF Generation error 2003-01-23 07:01 Ok, I have found the source of my problem, but I don't know why it is a problem. Here is my textField: <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement positionType="Float" x="0" y="15" width="710" height="0"/> <textElement textAlignment="Center"> <font reportFont="CourierNew" size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[((com.csc.aims.reports.jasperreports.TESTStepsByStatusScriptlet)$P{REPORT_SCRIPTLET}).getFilterDescription($P{TestInfoType}, $P{TestInfoFilter})]]></textFieldExpression> </textField> I am using a Scriplet and the method that is being called will either return a String or null. I wanted it to return 'null' so that I could use the isBlankWhenNull attribute of the textField. However, when I have this attribute set to true, I can view it with the JasperViewer, but I can't generate a PDF. If I take that attribute off (set to false), I can generate the PDF just fine. What I want to do: I only want this textField to take up space when it "has something to say" therefore, I have set its height to 0 and isStretchWithOverflow="true" to accomodate this. Can you tell me a better way to accomplish this? Perhaps tell me if there is a bug with the way JasperReports is creating the PDF in this case or maybe iText is where the problem lies? For now, I will just suffer with the blank line, but I would prefer not to do it that way. Thanks! By: Teodor Danciu - teodord RE: FOLLOWUP: PDF Generation error 2003-01-23 07:24 Hi, I know what the problem is. Fortunately, you have posted the text field definition. Make the text field height="1". This is a bug that I already fixed for the 0.4.5 version to be released soon. Thank you, Teodor

By: lovish Durbha - lovish JRDataSource for a subreport 2003-01-23 04:22 I have a main report which implements JRDataSource and have a sub report and would ideally like to have a separate JRDataSoource implementation. I have noticed that for the fields in sub report JSAPER calls mail report JRDataSource implemented class for data of sub rport. can anyone help? thanks siva.durbha

By: Moisey Blehman - rhal Showing the text within allowed width. 2003-01-23 03:34 Hi I need to show text within the field despite its fitting inside the given width... In other words: How can I display just some part of text? It would look like text cut on the width border. Right now I am aware that you can either hide it or show it all using "isStretchWithOverflow" tag. Thank you rhal.

By: Dhruv K Vohra - dhruv_k_vohra Now able to use sub reports properly 2003-01-22 13:22 Hi, I have a simple report "sub1" [similar to the chart sample - only the pie-image is smaller at left aligned]. I made a copy of the report as another sub report "sub2" [the pie-image is right aligened]. I am able to compile, fill and view the above two reports independently. Next, I wrote a simple master report "multi" which just contained the above two reports as sub-reports. Problem) The 2 sub-reports do appear ! Question) how do I make this simple thing work :( Note) The 2 sub-reports just have an image. The XML below is for "sub1" <?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="sub1" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" scriptletClass="ChartScriptlet" isTitleNewPage="false" isSummaryNewPage="false"> <variable name="ChartImage" class="java.awt.Image" resetType="Report" calculation="System"> </variable> <title> <band height="0"> </band> </title> <pageHeader> <band height="0"> </band> </pageHeader> <columnHeader> <band height="0"> </band> </columnHeader> <detail> <band height="660"> <image scaleImage="RetainShape" isUsingCache="false" evaluationTime="Now" hyperlinkType="None"> <reportElement mode="Opaque" x="11" y="16" width="238" height="581" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <graphicElement stretchType="NoStretch" pen="None" fill="Solid" /> <imageExpression class="java.awt.Image">$V{ChartImage}</imageExpression> </image> <staticText> <reportElement mode="Transparent" x="11" y="609" width="237" height="38" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false"/> <textElement textAlignment="Left" lineSpacing="Single"> <font fontName="" pdfFontName="Helvetica-BoldOblique" size="10" isBold="true" isItalic="true" isUnderline="true" isPdfEmbedded ="false" pdfEncoding ="Cp1250" isStrikeThrough="true" /> </textElement> <text><![CDATA[sub Report 1. Go for it.]]></text> </staticText> </band> </detail> <columnFooter> <band height="1"> </band> </columnFooter> <pageFooter> <band height="0"> </band> </pageFooter> <summary> <band height="0"> </band> </summary> </jasperReport>

By: Muralidhar bp - pmurli Store procedures 2003-01-17 01:52 Hello, How to use store procedures in an xml document. I want to user store procedure instead of (<query_string>. Is it possible to use multiple queries in a single xml document. By: Chuck Deal - cdeal RE: Store procedures 2003-01-17 05:29 I use SQL Server 7.0 and I call stored procedures like this: <queryString><![CDATA[exec usp_rpt_TESTStepsByStatus $P!{BaselineId}, $P!{ProgramId}, '$P!{StepStatus}', '$P!{DevStatus}', $P!{AuthorId}]]></queryString> Of course, I don't use OUTPUT parameters so this is acceptable. By: Teodor Danciu - teodord RE: Store procedures 2003-01-17 05:55 Hi, You could call in the query string stored procedures that return result sets and do not have OUT parameters. Thank you, Teodor By: Muralidhar bp - pmurli RE: Store procedures 2003-01-20 05:23 Hii Thanx for the reply, I kindly request you to send me the example for the same. I dont know how to handle the result set in the Jasper Reports. My email is pmurli@psi.soft.net Thanx Murli By: Chuck Deal - cdeal RE: Store procedures 2003-01-21 05:42 Is your stored proceure complex? Complex meaning more than one resultset or uses OUT parameters? If not, then you can simply imagine that the call to the stored procedure and the call to a query are the same thing... both return a list of rows delimited into columns. Therefore, you can handle a simple stored procedure the same way you would handle a query in JasperReports. By: Muralidhar bp - pmurli RE: Store procedures 2003-01-22 06:03 Hello Charles, Thanks for the reply, will you please write a simple procedure which gives the result set and please show me how you r using it in the XML file. Please tell me what i should write in xml file which shows the " ************* " indication mark. I mean should I have to write a column name or procedure name <queryString><![CDATA[exec SwiftMessage $P!{LCNumber}]]></queryString> <field name="******************" class="java.lang.String"/> <detail> <band height="500"> <textField isStretchWithOverflow="true"> <reportElement x="0" y="5" width="500" height="495" forecolor="#333333"/> <textFieldExpression class="java.lang.String"> $F{*************************} </textFieldExpression> </textField> </band> </detail> Please help me. Thanks Murli By: Chuck Deal - cdeal RE: Store procedures 2003-01-22 07:13 Sure, I'll give it a try. You have a users table that contains two varchar fields: last_name and first_name. Then, we could write a sql stmt like this to get those values. SELECT last_name, first_name FROM users This would return a two column resultset with as many rows as there are in this table. Now, you could create a stored procedure called usp_rpt_GetUsers. For simplicity we will not have any parameters. The body of this stored procedure should contain the query that we defined earlier in the message. Therefore, if we execute that stored procedure like this: exec usp_rpt_GetUsers We will also get a two column resultset with as many rows as there are in the database. That brings us up to how to use this stored procedure in the JasperReports XML definition. Using yur basic example, I will fill in the blanks as best as I can. <queryString><![CDATA[exec usp_rpt_GetUsers]]></queryString> <field name="last_name" class="java.lang.String"/> <field name="first_name" class="java.lang.String"/> <detail> <band height="500"> <textField isStretchWithOverflow="true"> <reportElement x="0" y="5" width="500" height="495" forecolor="#333333"/> <textFieldExpression class="java.lang.String">$F{last_name}</textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="500" y="5" width="500" height="495" forecolor="#333333"/> <textFieldExpression class="java.lang.String">$F{first_name}</textFieldExpression> </textField> </band> </detail> From here, you should be able to see how to add parameters to the stored procedure. Remember only INPUT parameters are supported by JasperReports. Therefore, it you were to establish a filter by, let's say last_name, you could pass that parameter to the stored procedure. Your resultset will still contain two columns, but your filter would have limited the number of rows returned. Now, as far as your data being of CLOB type, you may have to perform some conversion in your stored procedure to make the CLOB type a varchar (as you mentioned in another post). Good luck, I hope I was able to help you. By: Muralidhar bp - pmurli RE: Store procedures 2003-01-22 09:08 Hello, Thank you very much for the information, please have a look at my procedure and give suggestions. Also tell me if there is any mistake in this procedure. CREATE OR REPLACE PROCEDURE StillMessage(p_lc_number IN STILLLOG.LC_NO%type) AS v_text_loc CLOB; v_text_amt VARCHAR2(32000):=80; v_text_pos INTEGER:=1; v_text_buffer VARCHAR2(32000); v_text_length INTEGER; v_error_code VARCHAR2(100); v_error_msg VARCHAR2(100); BEGIN SELECT STILL_MESSAGE INTO v_text_loc FROM STILLLOG WHERE LC_NO=p_lc_number; v_text_length := DBMS_LOB.GETLENGTH(v_text_loc); LOOP DBMS_LOB.READ(v_text_loc, v_text_amt, v_text_pos, v_text_buffer); v_text_pos := v_text_pos + v_text_amt; IF ((v_text_pos+80)>= v_text_length) THEN v_text_amt := v_text_length - v_text_pos; END IF; EXIT WHEN v_text_pos >= v_text_length; END LOOP; EXCEPTION WHEN NO_DATA_FOUND THEN v_error_code := SQLCODE; v_error_msg := SQLERRM; END; / Please give suggestions on this. Thanks, once again for your effort to educate me. Thanks Murli By: Chuck Deal - cdeal RE: Store procedures 2003-01-22 11:25 I'm not familiar with the particular syntax you are using, but it doesn't look like you are actually returning a resultset. As far as I know, there is no explicit way to do this, you simply run a select statement. Here is my intepretation of your stored proc and a potential solution: It looks as if you are selecting a single CLOB field out of your table and then processing it (i'm a little fuzzy on the actual processing that you are doing, but that is ok, for now). When the loop finishes, my guess is that your final value is stored in v_text_buffer (?). The thing is, no where in your proc did you execute a plain-old SELECT stmt. Here is what I would try. Right after END LOOP and before EXCEPTION put this stmt: SELECT v_text_buffer AS clob_field Based upon what I can see of your proc this will cause a resultset of 1 column and 1 row to be returned. Then, your <field> tag will use "clob_field" as the name attribute.

By: ding city - ding123 where can i find the faq.html page? 2003-01-22 05:05 when i look some article in the forums, i found some answers to the questions is : goto: http://jasperreports.sourceforge.net/faq.html#.. but i can not visit this link sucessfully? somebody tell me? thx By: Teodor Danciu - teodord RE: where can i find the faq.html page? 2003-01-22 08:45 Hi, Do you mean this one? http://jasperreports.sourceforge.net/faq.html Teodor By: Teodor Danciu - teodord RE: where can i find the faq.html page? 2003-01-22 08:46 Anyway, all you can find on the site is also present in the /docs directory of the project source files. Thank you, Teodor

By: Muralidhar bp - pmurli very urgent 2003-01-21 06:15 Hello, I am getting this error when deploying my war file in weblogic server. Plzzz help me... <Jan 21, 2003 7:51:15 PM IST> <Error> <HTTP> <[WebAppServletContext(4789566,List OfSwift,/ListOfSwift)] Servlet failed with Exception java.lang.NullPointerException at java.util.Hashtable.put(Hashtable.java:375) at java.util.Properties.setProperty(Properties.java:97) at java.lang.System.setProperty(System.java:637) at servlets.ListOfSwiftServlet.service(ListOfSwiftServlet.java:33) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:262) at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm pl.java:198) at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe rvletContext.java:2637) at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm pl.java:2359) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) > Thanx Murli By: Chuck Deal - cdeal RE: very urgent 2003-01-21 08:25 It looks like you are calling System.setProperty inside the ListOfSwiftServlet. Look for this statement and verify that you are not setting a null (or that the variable you are using as the parameter is not null) By: Muralidhar bp - pmurli RE: very urgent 2003-01-22 00:35 Hello, I have the query, which consists of CLOB data, and want to show this data as a report, and when i create the war file and try to deploy I am getting this error. Plzz tell me whether the xml file which i have written is correct or wrong. I am using a store procedure called SwiftMessage, to read the CLOB data. The querystring in the xml file is like this... <queryString><![CDATA[exec SwiftMessage $P!{LCNumber}]]></queryString> where SwiftMessage is the procedure name. I am writing the procedure on CLOB column SWIFT_MESSAGE, So please tell me what I should write in field tag and detail tag. Should I have to write the column name or procedure name. Please help me, thanx in advance. Rgds Murli By: Teodor Danciu - teodord RE: very urgent 2003-01-22 03:45 Hi, I'm not very familiar with PL/SQL, but as far as I know, it seems that your stored procedure returns the CLOB value in an OUT parameter (from the code you've sent me). And as we already told you, JasperReports cannot deal with such stored procedures. It can only use SELECT queries or at least stored procedures that return result sets and have no OUT parameters at all. I suggest you give up using the SQL query feature of JasperReports and read the CLOB value outside JasperReports, in you own application code. I assume that you already have an infrastructure that allows you to read such values using JDBC. It is your application who stored these values in the database or not? Anyway, if you read the CLOB before launching the report, you could supply the value simply as a large String report parameter. Furthermore, the exception you get has nothing to do with what we've already talked about. It is not about the query or the CLOB or anything. It does not seem to be related to JasperReports, if that is the entire stack trace you got. I don't see any JasperReports class mentioned in the stack trace. I hope this helps. Teodor By: Muralidhar bp - pmurli RE: very urgent 2003-01-22 06:10 Hello, Thanks for the reply, I want to execute one simple store procedure program with Jasper report. So can you please show me how to use store procedure in Jasper Reports with example. Thanks in advance. Rgds Murli By: Teodor Danciu - teodord RE: very urgent 2003-01-22 08:43 Hi, I do not have such an example. Maybe someone with more hands-on experience on this could help you. Thank you, Teodor

By: Michel - micheljr Blank Master report/Subreport 2003-01-22 05:06 Hi, I'm a newbie to iReport. I'm trying to create a report with a subreport inside. The layout I need looks like the MasterReport sample, but I'm still in trouble to make it working. I'm using 2 tables: one table ordered by City and another table with Code/Name/Age. This is the layout I need: CITY: NEW YORK CODE NAME AGE 00001 JOHN 30 00002 PAUL 30 00003 GEORGE 30 00004 RINGO 30 When I compile the subreport, it works well and shows all the names. But when I compile the master report, the result is a blank PDF, the subreport isn't being inserted into the master report. I think the problem is the connection or any parameter between the master report and the subreport. Any suggestion? Or perhaps step-by-step tips... Thanks in advance

By: Muralidhar bp - pmurli problem with calculation="Sum" 2003-01-17 01:23 Hello, In the xml code which i have written.. <variable name="TotalCustomer" class="java.lang.Integer" resetType="Report" calculation="Sum"> <variableExpression> $F{CUSTOMERCOUNT} </variableExpression> </variable> This works fine when there is data in the database. When the database is empty, total is null. But I want to display as 0 ie., zero. Please help me.. Thanx Murli By: Jorge Augusto Pizzato - pizzato RE: problem with calculation="Sum" 2003-01-20 10:11 : You can use the tag < printWhenExpression > for not printing in the case of null values. <reportElement> <printWhenExpression> new Boolean($F{CUSTOMERCOUNT} != NULL) </printWhenExpression> </reportElement> Pizzato By: Teodor Danciu - teodord RE: problem with calculation="Sum" 2003-01-22 05:04 Hi, Or you could use the <initialValueExpression> : <variable name="TotalCustomer" class="java.lang.Integer" resetType="Report" calculation="Sum"> <variableExpression> $F{CUSTOMERCOUNT} </variableExpression> <initialValueExpression>new Integer(0)</initialValueExpression> </variable> Thank you, Teodor

By: Michel - micheljr Blank Master report/Subreport 2003-01-22 04:33 Hi, I'm a newbie to iReport. I'm trying to create a report with a subreport inside. The layout I need looks like the MasterReport sample, but I'm still in trouble to make it working. I'm using 2 tables: one table ordered by City and another table with Code/Name/Age. This is the layout I need: CITY: NEW YORK CODE NAME AGE 00001 JOHN 30 00002 PAUL 30 00003 GEORGE 30 00004 RINGO 30 When I compile the subreport, it works well and shows all the names. But when I compile the master report, the result is a blank PDF, the subreport isn't being inserted into the master report. I think the problem is the connection or any parameter between the master report and the subreport. Any suggestion? Or perhaps step-by-step tips... Thanks in advance

By: Muralidhar bp - pmurli CLOB support in Jasper reports 2003-01-17 03:35 Hello, I have to develop a report, in which it consists of CLOB data. Please help me how to go with it. Thanx Murli By: Teodor Danciu - teodord RE: CLOB support in Jasper reports 2003-01-17 05:57 Hi, Pure CLOB/BLOB support is not yet available in JasperReports. Not sure, but using InputStream report fields might help. Thank you, Teodor By: Muralidhar bp - pmurli RE: CLOB support in Jasper reports 2003-01-22 02:16 Hii, How about if i write a store procedure to store the data in varchar2(32000), and pass the procedure in the query string. Thanks Murli

By: Vishal - vabrol123 java.io.StreamCorruptedException 2003-01-21 16:08 hi, trying out jasperreports for the first time. I get this error when try to fill the report. Any ideas ? created the xml file with ireport0.0.7 appreciate any help Thanks Internal Servlet Error: javax.servlet.ServletException: Error loading object from file : report.xml at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459) at jsp._0002fjsp_0002frepRetrieve_0002ejsprepRetrieve_jsp_3._jspService(_0002fjsp_0002frepRetrieve_0002ejsprepRetrieve_jsp_3.java:1347) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Unknown Source) Root cause: java.io.StreamCorruptedException: InputStream does not contain a serialized object at java.io.ObjectInputStream.readStreamHeader(Unknown Source) at java.io.ObjectInputStream.(Unknown Source) at dori.jasper.engine.util.JRLoader.loadObject(JRLoader.java:119) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:101) at jsp._0002fjsp_0002frepRetrieve_0002ejsprepRetrieve_jsp_3._jspService(_0002fjsp_0002frepRetrieve_0002ejsprepRetrieve_jsp_3.java:863) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Unknown Source) NESTED BY : dori.jasper.engine.JRException: Error loading object from file : report.xml at dori.jasper.engine.util.JRLoader.loadObject(JRLoader.java:126) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:101) at jsp._0002fjsp_0002frepRetrieve_0002ejsprepRetrieve_jsp_3._jspService(_0002fjsp_0002frepRetrieve_0002ejsprepRetrieve_jsp_3.java:863) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Unknown Source) By: Teodor Danciu - teodord RE: java.io.StreamCorruptedException 2003-01-21 23:50 Hi, When filling a report, you have to supply the compiled report design file (.jasper) and not the XML report design. Thank you, Teodor

By: Fishee - fishee Plugin error 2003-01-14 23:38 i encountered 2 errors, which are:- - "An error occurred inside a plug-in contained on this page" - "The plugin did not initialize properly" whenever the length of a page's URL exceed a certain amount of characters. But when i cut down the parameters passed to the next page (which obviously would shorten the length of the URL), the report would display without any problem. Is there a solution to this? By: Teodor Danciu - teodord RE: Plugin error 2003-01-17 08:06 Hi, Maybe here you'll find a solution: http://www.the-it-mercenary.com/forums/Help/posts/6295.html Thank you, Teodor

By: Muralidhar bp - pmurli Conditional Statements in Jasper Reports 2003-01-17 03:42 Hello, I have to use conditional statements in XML query, for example IF (CONDITION) query 1 ELSE query 2 Please help me Thanx Murli By: Chuck Deal - cdeal RE: Conditional Statements in Jasper Reports 2003-01-17 05:27 If your number of choices are small you can use the tertiary format (expression ? true-part : false-part) For more extensive conditionals, you might want to look at scriptlets. By: Teodor Danciu - teodord RE: Conditional Statements in Jasper Reports 2003-01-17 05:44 Hi, You can supply the entire SQL query at runtime using a parameter like this: <queryString>$P!{MyDynamicQuery}</queryString> Then, the question is: where you make the IF test and choose the right query (the right MyDynamicQuery parameter value). You could do this outside JasperReports, before even passing the parameters to the engine. But if there are only two possible queries, you could use the <defaultValueExpression> of the query parameter based on other parameters that you actually supply. Unlimited variations of this scenario are possible. I hope this helps. Teodor

By: Muralidhar bp - pmurli Add line in the report 2003-01-17 01:25 Hello, I have to add a line after the column header, some thing like (-------------------------------). How do i proceed. Thanx Murli By: Chuck Deal - cdeal RE: Add line in the report 2003-01-17 05:32 Goto http://jasperreports.sourceforge.net/index.html and get yourself familiar with the Jasper Reports format and available features. Consult the quick reference to see the various XML tags (<line> is one of them) available to you.

By: Thanh Nam - thanhnam12 Show report with JSP??? 2003-01-17 00:11 When I call report in my jsp page, it always show in my web server, not in client. Please tell me how to show report in client machine. I used JRun4. Thank you in advance. By: Teodor Danciu - teodord RE: Show report with JSP??? 2003-01-17 00:18 Hi, Check the "webapp" sample provided for details about how to display reports in web environment. Thank you, Teodor

By: Arsenio - jaspinoy Problem with the Report Format(Newbie) 2003-01-16 19:19 Hello World! I have a problem figuring out how to get my report working. I am using JRTableModelDataSource as DataSource but i get this error everytime i run my report. java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.apache.commons.beanutils.ConvertUtils.<clinit>(ConvertUtils.java:318) at org.apache.commons.digester.CallMethodRule.end(CallMethodRule.java:280) at org.apache.commons.digester.Digester.endElement(Digester.java:757) at org.apache.xerces.parsers.SAXParser.endElement(SAXParser.java:1403) at org.apache.xerces.validators.common.XMLValidator.callEndElement(XMLValidator.java:1550) at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1149) at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381) at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098) at org.apache.commons.digester.Digester.parse(Digester.java:1170) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:353) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:309) at dori.jasper.engine.JasperManager.loadXmlDesign(JasperManager.java:1016) at ph.edu.smu.Repos.smuSheet.getReport(smuSheet.java:615) at ph.edu.smu.Repos.smuSheet.access$1400(smuSheet.java:35) at ph.edu.smu.Repos.smuSheet$13.actionPerformed(smuSheet.java:463) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1767) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1820) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:258) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:227) at java.awt.Component.processMouseEvent(Component.java:5021) at java.awt.Component.processEvent(Component.java:4818) at java.awt.Container.processEvent(Container.java:1525) at java.awt.Component.dispatchEventImpl(Component.java:3526) at java.awt.Container.dispatchEventImpl(Container.java:1582) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3359) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3074) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3004) at java.awt.Container.dispatchEventImpl(Container.java:1568) at java.awt.Window.dispatchEventImpl(Window.java:1581) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.EventQueue.dispatchEvent(EventQueue.java:445) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:191) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:144) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130) at java.awt.EventDispatchThread.run(EventDispatchThread.java:98) org.xml.sax.SAXParseException: Error at (13, 26: org/apache/commons/logging/LogFactory at org.apache.commons.digester.Digester.createSAXException(Digester.java:1766) at org.apache.commons.digester.Digester.createSAXException(Digester.java:1795) at org.apache.commons.digester.Digester.endElement(Digester.java:763) at org.apache.xerces.parsers.SAXParser.endElement(SAXParser.java:1403) at org.apache.xerces.validators.common.XMLValidator.callEndElement(XMLValidator.java:1550) at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1149) at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381) at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098)........... I guess i have a problem the way i format my report in my XML file. Could anyone in the forum show me the right way. Below is my XML file. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="BasicReport" > <field name="ID" class="java.lang.String"> <field name="Last" class="java.lang.String"> <field name="First" class="java.lang.String"> <detail> <band height="20"> <textField> <textFieldExpression class="java.lang.String"> $F{ID} </textFieldExpression> </textField> <textField> <textFieldExpression class="java.lang.String"> $F{Last} </textFieldExpression> </textField> <textField> <textFieldExpression class="java.lang.String"> $F{First} </textFieldExpression> </textField> </band> </detail> </jasperReport> Thanks a lot! Arsenio

By: Arsenio - jaspinoy Problem with the Report Format(Newbie) 2003-01-16 19:19 Hello World! I have a problem figuring out how to get my report working. I am using JRTableModelDataSource as DataSource but i get this error everytime i run my report. java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.apache.commons.beanutils.ConvertUtils.<clinit>(ConvertUtils.java:318) at org.apache.commons.digester.CallMethodRule.end(CallMethodRule.java:280) at org.apache.commons.digester.Digester.endElement(Digester.java:757) at org.apache.xerces.parsers.SAXParser.endElement(SAXParser.java:1403) at org.apache.xerces.validators.common.XMLValidator.callEndElement(XMLValidator.java:1550) at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1149) at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381) at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098) at org.apache.commons.digester.Digester.parse(Digester.java:1170) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:353) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:309) at dori.jasper.engine.JasperManager.loadXmlDesign(JasperManager.java:1016) at ph.edu.smu.Repos.smuSheet.getReport(smuSheet.java:615) at ph.edu.smu.Repos.smuSheet.access$1400(smuSheet.java:35) at ph.edu.smu.Repos.smuSheet$13.actionPerformed(smuSheet.java:463) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1767) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1820) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:258) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:227) at java.awt.Component.processMouseEvent(Component.java:5021) at java.awt.Component.processEvent(Component.java:4818) at java.awt.Container.processEvent(Container.java:1525) at java.awt.Component.dispatchEventImpl(Component.java:3526) at java.awt.Container.dispatchEventImpl(Container.java:1582) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3359) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3074) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3004) at java.awt.Container.dispatchEventImpl(Container.java:1568) at java.awt.Window.dispatchEventImpl(Window.java:1581) at java.awt.Component.dispatchEvent(Component.java:3367) at java.awt.EventQueue.dispatchEvent(EventQueue.java:445) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:191) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:144) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:130) at java.awt.EventDispatchThread.run(EventDispatchThread.java:98) org.xml.sax.SAXParseException: Error at (13, 26: org/apache/commons/logging/LogFactory at org.apache.commons.digester.Digester.createSAXException(Digester.java:1766) at org.apache.commons.digester.Digester.createSAXException(Digester.java:1795) at org.apache.commons.digester.Digester.endElement(Digester.java:763) at org.apache.xerces.parsers.SAXParser.endElement(SAXParser.java:1403) at org.apache.xerces.validators.common.XMLValidator.callEndElement(XMLValidator.java:1550) at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XMLDocumentScanner.java:1149) at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner.java:381) at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098)........... I guess i have a problem the way i format my report in my XML file. Could anyone in the forum show me the right way. Below is my XML file. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="BasicReport" > <field name="ID" class="java.lang.String"> <field name="Last" class="java.lang.String"> <field name="First" class="java.lang.String"> <detail> <band height="20"> <textField> <textFieldExpression class="java.lang.String"> $F{ID} </textFieldExpression> </textField> <textField> <textFieldExpression class="java.lang.String"> $F{Last} </textFieldExpression> </textField> <textField> <textFieldExpression class="java.lang.String"> $F{First} </textFieldExpression> </textField> </band> </detail> </jasperReport> Thanks a lot! Arsenio

By: Rama Kodumagulla - rkodumagulla NullPointerException 2003-01-02 08:24 I have this problem when using WSAD 5.0, but the same code runs fine using command line compile. java.lang.NullPointerException at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1094) at org.apache.commons.digester.Digester.parse(Digester.java:1144) at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:353) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:309) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:96) at org.dhhs.dirm.acts.query.QueryApp.main(QueryApp.java:146) NESTED BY : dori.jasper.engine.JRException at dori.jasper.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:357) at dori.jasper.engine.xml.JRXmlLoader.load(JRXmlLoader.java:309) at dori.jasper.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:96) at org.dhhs.dirm.acts.query.QueryApp.main(QueryApp.java:146) Here is my code: fileName = "C:\Install\ActsReports\templates\QueryOneDef.xml"; System.setProperty("jasper.reports.compile.class.path", "C:\install\ActsReports\Jasperreports\lib\jasperreports.jar"); System.setProperty("jasper.reports.compile.temp", "C:\install\ActsReports\templates"); String oldSaxDriver = System.setProperty("org.xml.sax.driver", "org.apache.xerces.parsers.SAXParser"); JasperCompileManager.compileReportToFile(fileName); System.err.println("Compile time : " + (System.currentTimeMillis() - start)); System.exit(0); I am failing to compile the XML document. Your help will be highly appreciated. Thanks, rkodumagulla By: Teodor Danciu - teodord RE: NullPointerException 2003-01-02 10:26 Hi, It seems that the "filename" variable gets to be null when passed to the report compiling process. Double check this, or send me your JSP/servlet. Thank you, Teodor By: Vani - itsme123 RE: NullPointerException 2003-01-16 18:19 I am getting same problem when I run the report on Tomcat 4 using servlets. The same works on command line build script. Thanks.