[chart is not working in jasperstudio]

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

[How to access remote mysql server database from ireports in localhost]

thanku 4 u r response.it helped me

[How to access remote mysql server database from ireports in localhost]

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.

[How to create students performance comparison bargraph in ireports]

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

[How to integrate charts in ireports]

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

[How to display group footer data into first page using ireports]

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

 

[How to pass multiple parameters from jsp page to ireports]

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

 

[How to pass multiple parameters from jsp page to ireports]

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.

[Display table according to report group header in ireports]

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.

[How to disply table data horizantally]

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

 

 

[how to calculate percentage in ireport]

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

[Exception: java.lang.IllegalStateException: getOutputStream() has already been called for this response]

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();
            }
           

[executing jasper report from jsp page]

I have included that but still its giving blank response

[executing jasper report from jsp page]

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.

[How to run jasper report from JSP page with parameter]

 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  

[How to run jasper report from JSP page with parameter]

 

[How to run jasper report from JSP page with parameter]

Hi, 

I have created a jrxml report with database values.But how could i will call this report from jsp Page. Can anyvody plz help me.