firass88

sallam , i have the same exception that you got, what i did first was to take the sample of webapp of jasperreports 3.7.6 and make it run. two ways to do so: 1.1 use the ant commands (*) then create the jasper-webapp.war and put it in ..\tomcat.6.0\webapps\ folder * http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/getting.started.html 1.2 create a new project using an IDE like intellij then copy all the webapp sample folder to it. then attach the ant to build.xml file in this folder. after that run the ant and compile/run the project. 2. open the browser in localhost:[port] then you can see Web Application Sample first goto applet viewr in left menu and follow this link: "click here to test whether your browser can run Swing applets or not" if you could run it and see applet rectangle then you have no problem if not try to open these pages above using another browser like "google chroom" , he might want to download the java from internet just follow the steps. 3. after running the test goto home page of this sample and follow the pages by this order compile JRXML , fill report, then click the Embedded Viewer Applet link in "applet viewer" page and see if it running correctly. 4. try to understand the sample and take a look at the applet folder (inside the webapp sample) you can see three jars: jasperreports-applet-3.7.6.jar,commons-logging-1.0.4.jar,commons-collections-2.1.1.jar open the viewer.html and see how sample is using this jars and calling the "EmbeddedViewerApplet.class" throw javascript. 5. in the servlet, write the report data to a pdf file on the server and then from the applet get a handle to the applet context object and invoke the showDocument method passing the path where I saved the pdf file. taken from: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=1291 and http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=62166 i hope this can help sombody ... :)

hi. can you please explain the solution because i didn't get the whole picture. how did you define the datasource and hoew to set the \n in unix? are you using mysql and which version , is it 5.1 ? i hope sombody can give me answers ... thanks in advance.

hi Matt, i had a similar problem when i have upgrade to 3.7 But i am asking another question can i support chinese, japanese, Hebrew, arabic .... in one font extensions. ex. i have one textfield and i set the font to arialX - i want that this font support all the languages. i know that i could build more textfields and use the printwhenexpression But i am looking for a good solution because i have already so many written reports. note ArialX is the name of a jar that i have create it in the ireport 3.7.5- tools - options - fonts i have understand that i could use locales but i couldn't build one jar for the same name, there somthing fogi for me with the font family... and the ireport didn't give me to select more than one locale! could you please direct me how to solve this problem. thanks in advance. Post Edited by firass88 at 11/08/2010 10:59

i have solve my problem by using a regular group - idea1 , i need to sort my JRBeanArrayDataSource before giving to the report. i will be very gratefull if somebody can post an example for a dummy group! with two subreports.

hi teodord, first of all thank you for replying to me, i want to describe to you my problem, i have a JRBeanArrayDataSource that i move it to the report, this array contain details, for an example, let's say for a school's teachers and students: name , telephone and type (student or teacher). so i want to print in a table(band) all the teachers then after that all the students! (it's just an example): this is the teacher's of this school: A # B # ... this is the student's list: s # b # =============================================================================== now i try different idea's But i couldn't succced, 1. i think may i use groups to do so but because group need Order by in sql and i don't have an sql - am moving JRBeanArrayDataSource to ReportDataSource. 2. i thought i can use one main report and one subreport but then i face the same problem the subreport print all the students alone but the some of the teachers is printed before and after the subreport.(why?) , i have tried to use two group footer but i face the same problem. 3. i think about using one empty main report and using two sub-reports but i face another problem that the subreports is printed on each other - i try using the "dummy group" with <groupExpression>$V{REPORT_COUNT}</groupExpression but i don''t know what i did wrong. please help me ASAP! thanks in advance.

Somebody could please give me an example about dummy group and subreports that is working ! i am struggling with this two days and i am very frustrated. please help with a simple example ... thanks a lot.

thanks a lot, i will check it and save if it solve my problem

hi lucianc, first i want to thank you for helping me , then i want to ask you if you could send me a link to this POI version 3.0.1. - i have looked in the Apache POI site but i couldn't find it. thanks

hi lucianc, i have checked your suggestion and used the poi-3.2-FINAL-20081019 (i was using jakarta-poi-1.5.1-final-20020615 before) but i am getting another exception now: javax.servlet.ServletException: Servlet execution threw an exception java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFCell.setEncoding(S)V note: i am using JRXlsExporter and i have checked with JRExporterParameter and JRXlsExporterParameter and i am getting the same exception! thanks

the exception is: Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.createDrawingPatriarch()Lorg/apache/poi/hssf/usermodel/HSSFPatriarch;

hi giliardi, i have the same problem as you , after research i found that the jasperreports-3.0.0.jar is causing this problem and if i replace it with the old one the exporting to excel will work fine! i have enter here to get any explaination for this problem and if this is the situation i think we found a Bug! thanks.

:) its is working now ..... thank you very much solution was to pass the subreport2 as a parameter from the main report to the first subreport.

hi CBox, thank you again for your help it is very appreciated... i can't use the REPORT_CONNECTION becuase am using the JRBeanArrayDataSource - ReportDataSource. so i am passing the java.sql.Connection as a parameter to the first subreport (it is working) but this method didn't work with the 2nd subreport. Although i give him another parameter connection. in the end, thank you for the help, i will try to understand how to use the DataSourceExpression i hope it will solve my problem. thanks a lot.

hi CBox, thank you for you quick reply... background: all my reports, subreports are in xml file and i a using the java to produce na run them. i think your suggestion seem reasonable to me my problem that am sending the connection from the mainreport to the subreport then i try to send this connection to the 2nd subreport so it is fail. Code: <subreport isUsingCache="true"> <reportElement mode="Opaque" x="15" y="16" width="415" height="13" forecolor="#000000" backcolor="#E9EED5" key="subreport2" isPrintRepeatedValues="false" isRemoveLineWhenBlank="false"/> <subreportParameter name="TitleLabel"> <subreportParameterExpression>$P{TitleLabel}</subreportParameterExpression> </subreportParameter> <connectionExpression>$P{dbConn}</connectionExpression> <subreportExpression class="net.sf.jasperreports.engine.JasperReport">$P{Subreport2}</subreportExpression> </subreport> i tried to send another connection as a parameter to the 2nd subreport but it also didn't work so what to do. thanks a lot.

hi all, i want a sample or a good explaination how i can call subreport from another subreport. i have search in the forum but i have found only question how to do so and that it is possible to do it. but i didn't find how. i have searched also the faq , ducumentation, Jasper Reports Manual - No answer. please help me it is very urgent thanks.