Buela

Hi, By using jasperstudio am creating student report. When am giving classname parameter all students reports will be generated to the respective parameter specified(class).But the problem is chart is not working.chart is taking common values for all the students.Can anyine help me how to resolve this

thanku 4 u r response.it helped me

I have created reports using ireports in my computer.But my database is in mysql server.I have the IPadrress and portnumber of the server details.How to give those details in ireports to access remote database.Can anybody please help me.I am searching in google .I couldn't find any solution.

In my database i have 3 different tables subjects table,examination table,marks table In subjects table all the subjects will be there according to class Eg: sub ject class english X Maths X PE X english IX maths IX PE IX in examination table i have different term examinations(Column: Term1, Term2, Skills), And in marks table (Columns: subject id,student id, exam id,marks) I have to create bargraph only for Term1, Term2 examinations and english, maths subjects. I have created bar graph by taking these values Series Expression : Examgroup(Term1,Term2,Term3) Category Expression: subjects(maths, english, PE) Value Expression: marks I have created graph by using new dataset of the report . This is my query for this dataset SELECT student_details.student_name,student_details.admno,student_details.batch,marks.*,examination.exam_name,subject.subject_name,subject.code FROM `student_details` LEFT JOIN `marks` on student_details.student_id = marks.student_id LEFT JOIN examination on examination.id=marks.exam_id LEFT JOIN subject ON subject.id=marks.subject_id where student_details.batch=$P{classname} and student_details.admno=$P{admno} and student_details.active=1 AND student_details.session='2017-2018' Now the problem is i am getting the graph for all the subjects(maths,english,PE) and for all examinations(term1,term2,skills) but i want only for examinations (term1 and term2 ) and subjects(maths,english) Even i have tried that giving exam group name in query itself but graph is not working properly .Graph is showing only for term1. Can anybody suggest me how to resolve this

I have to create progress report .In that comparison bar graph between two term examination i have to create.I have taken new dataset for the chart query. My database table is like this student id examgroup marks subjectid 1 1 85 1 1 1 98 2 1 2 85 1 1 2 65 2 when am creating chart its displaying only one exam group graph.can anybody suggest how to create comparison graph between two terms

I am creating report using ireports. I have created chart report group header nd footer. In group footer i have created bar graph.But that grapgh has to display in first page.Its taking blank space from header data to footer data.Can anybody suggest me how to bring that graph to first page

But i need to run the jrxml file from jsp page.with one parameter its working fyn but i need to pass multiple parameters.

In my jsp page only class has been selected.Based on this class id all students admission numbers has to be retrieved from the database and have to pass these admission num and class id as parameters to jrxml file inireports.can anybody suggest how to do this.

Hi I have created progress reports using ireports.I have creted report group header with group expression as a admission number.The complete report has to be organize by the admission number .But in my report i have to use tables.For that i have created different dataset and different group nme also has been created.But i need this tables has to be print accoring to main report group header.Can anybody please help me how to do this.

Hi In ireport how to create table horizontally.All the values are taking from database eg: grade a b c graderange90-100 80-90 70-80 In the above format i need to create a table can anybody suggest me how to do that

Hi How to calculate percentage for total in ireport.i have created total variable and max total marks is 600.How to represent in ireport

Hi I have integrated Jasper Reports with JSP.The below code in written my JSP Page.At runtime I am getting this error.Please help me out.I am pretty new to this.When am executing its giving Exception: java.lang.IllegalStateException: getOutputStream() has already been called for this response Connection conn; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/studentinfo", "root", "adminuser"); File reportFile = new File(application.getRealPath("//report//apsreport.jasper"));//your report_name.jasper file //Map parameters = new HashMap(); //parameters.put("test_subjects","test_TermI"); byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(),null, conn); response.setContentType("application/pdf"); response.setContentLength(bytes.length); // ServletOutputStream outStream = response.getOutputStream(); //outStream.write(bytes, 0, bytes.length); // outStream.flush(); // outStream.close(); return; } catch (Exception ex) { ex.printStackTrace(); }

I have included that but still its giving blank response

I have jrxml file which retrieves data from mysql database.I would like to run this file using jsp page.When am executing jsp page jrxml file should print data in pdf format .Here is my code File reportFile = new File(application.getRealPath("report/report1.jasper"));//report_name.jasper file Map parameters = new HashMap(); byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(),parameters, conn); response.setContentType("application/pdf"); response.setContentLength(bytes.length); ServletOutputStream outStream = response.getOutputStream(); outStream.write(bytes, 0, bytes.length); outStream.flush(); outStream.close(); while executing its giving exception: org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 38 38:byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(),parameters, conn); Can anybody please help me how to resolve this.

am using java to call jasper report.I have added the library files also.Still am getting error at <%@ page import="net.sf.jasperreports.engine.*"%> //cannot find symbol byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(), parameters, conn); //cannot find symbol. please help me what i am missing