mihaela

Hi, Can I put on y attribute of a report element a parameter String? ====== What is NMTOKEN from the description of y from report element from the boojk of Teodor Danciu " The definitive Guide to Jasper Reports" Thank you, Mihaela

Hi, I want to have a iteration in the filling program (MRFill2.java) and to iterate a master report, for each iteration of master report to appear a subreport. In fact in the report appear only the last iteration. Why? How to implement all iterations? Attached are the 3 files used (I omitted the java files for compiling). Thank you, Mihaela

The parameter is passed correctly. (I put also a default value for the parameter in the subreport) The idea is only master report display data and the subreport display nothing. I attached the subreport, the master report and the java program for filling the report (I didn't attached the programs for compiling the report). Thank you, Mihaela

Hi, I have the following 3 files attached. I don't know why the parameter code is not transmitted from the master raport to the subreport so the subreport displays nothing. Thank you, Mihaela

Hi, I have the attached files: S1.jrxml for the subreport, MR.jrxml for the master report, MRFill1.java for filling the master report. I didn't attach the java files for compiling the subreport and the master report. I didn't understand why when calling the master report the subreport didn't display anything. Thank you, Mihaela

MasterReport <?xml version="1.0" encoding="UTF-8"?> <jasperReport name="MasterReport"> <field name="description" class="java.lang.String"/> <detail> <band height="300"> ………………………. <subreport> <reportElement x="0" y="0" height="30" width="500" isPrintWhenDetailOverflows="true"/> <subreportParameter name="Description"> <subreportParameterExpression> <![CDATA[$F{description}]]> </subreportParameterExpression> </subreportParameter> <connectionExpression> <![CDATA[$P{REPORT_CONNECTION}]]> </connectionExpression> <subreportExpression class="java.lang.String"> <![CDATA["Subreport1.jasper"]]> </subreportExpression> </subreport> </band> </detail> </jasperReport> Subreport1 <?xml version="1.0" encoding="UTF-8"?> <jasperReport name="Subreport1"> <parameter name="Description" class="java.lang.String"/> <detail> <band height="24"> <textField> <reportElement x="0" y="0" width="300" height="24"/> <textElement verticalAlignment="Middle"/> <textFieldExpression> <![CDATA["aaaaaaaa"]]> </textFieldExpression> </textField> <textField> <reportElement x="310" y="0" width="100" height="24"/> <textElement verticalAlignment="Middle"/> <textFieldExpression> <![CDATA["bbbbbbb"]]> </textFieldExpression> </textField> </band> </detail> </jasperReport> I have this MasterReport and this Subreport. When the field description from the Java program is filled by a select the subreport is not called automatically? Thank you, Mihaela

Hi, I have a MasterReport and a Subreport. The masterreport is connected to the subreport by means of one or more parameters. Suppose that these parameters are transmitted in the subreport but the subreport wants only to write a text. So when the parameters are completed in the Java program, they are tramsmitted in the MasterReport, the Master Report transmit it in the Subreport and this write the text, isn't it? But on the screen appear nothing. Why? Thank you, Mihaela

Hi, I would like to implement this jsp code in a program jsp which generate Japer Report. I have 3 selects and I don't know how to implement, how to use cycles, etc. Any ideas? Maybe I need to use subreports. Thank you, Mihaela <% String Text_intrebare = " "; for (int j = 0; j < CodIntrebare.length; j++) { String Intrebare = CodIntrebare[j]; int i = 0; int flag = 0; if (j != 0) { String sql2 = "select * from item where code = " + Intrebare + "and code_survey = " + 33; java.sql.ResultSet rs2 = dataRequest.executeQuery(sql2); rs2.next(); Text_intrebare = rs2.getString(6); out.println("Intrebarea: "); out.println(Text_intrebare);%><%out.println (" Optiuni"); } String sql1 = "select * from optiune where code_item = " + Intrebare + " and code_survey = " + 33; java.sql.ResultSet rs_survey1 = dataRequest1.executeQuery(sql1); while (rs_survey1.next()) { i = 0; String Optiune = rs_survey1.getString(4); Optiune = Optiune.substring(0, Optiune.length() - 1); for (int r = 0; r < CodRegiune.length; r++) { String Regiune = CodRegiune[r]; for (int c = 0; c < CodCompanie.length; c++) { String Companie = CodCompanie[c]; for (int v = 0; v < CodVechime.length; v++) { String Vechime = CodVechime[v]; for (int f = 0; f < CodFunctie.length; f++) { String Functie = CodFunctie[f]; String sql = "select r.progressive from result_detail s, result_detail r, result_detail d, result_detail u, result_detail t where (r.progressive = d.progressive) and (s.progressive = r.progressive) and (d.progressive = u.progressive) and (u.progressive = t.progressive) and (s.code_item = " + Intrebare + ") and (substr(s.item_value_text, 0, length(s.item_value_text) - 1) = " +"'" + Optiune + "'" +") and (substr(r.item_value_text, 0, length(r.item_value_text) - 1) = " +"'" + Regiune + "')" + "and (substr(d.item_value_text, 0, length(d.item_value_text) - 1) = " + "'" + Companie +"')" + " and (substr(u.item_value_text, 0, length(u.item_value_text) - 1) = " + "'" + Vechime + "')" + " and (substr(t.item_value_text, 0, length(t.item_value_text) - 1) = " + "'" + Functie + "') and r.code_survey = 33 "; java.sql.ResultSet rs_survey = dataRequest.executeQuery(sql); while (rs_survey.next()) {i=i+1;}; } // de la Functie } // de la Vechime } // de la Companie } // de la Regiune %> <% out.println(Optiune); out.println(" " + i); %> <% } // de la while de la Optiuni %> <% } dataRequest.close(); } catch(Exception exceptie){} %>

Hi, I would like to put at the tag report element in Jasper Reports Orange backcolor or another color. How do I write? Thank you, Mihaela

Hi,I tried to write a jsp program with the functionJasperFillManager.fillReport.....and I obtain the error:javax.servlet.ServletException: java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) org.apache.jsp.JasperReportsTeste.DbReport_jsp._jspService(DbReport_jsp.java:146) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) Any advice? Thank you, Mihaela

iReport 3.7.0 is free? I asked this because I did a connection to the database everything is ok but when I press New from File appear a Report and when I press Launch the Report Wizard nothing hapopens. Thank you, Mihaela

Hi, I installed iReport 3.7.0 and I did a conexxion with the database with it but I could not use the report wizard. Any help? Thank you, Mihaela