email.vinu04

I am calling jasper report by java swing application and I have created .jasper file in Jaspersoft studio 6.3.1 and I am making use of JasperReports library 6.3.1. I can export the report into excel format but the problem I am facing is when I tried exporting report into pdf or xml format, it is affecting to xlsx report. import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter; import net.sf.jasperreports.export.SimpleExporterInput; import net.sf.jasperreports.export.SimpleOutputStreamExporterOutput; import net.sf.jasperreports.export.SimpleXlsxReportConfiguration; When I use these libraries, excel report is getting generated successfully but when I use import net.sf.jasperreports.engine.Jasper Export Manager or JRPdfExporter, JRXmlExporter, pdf report is not getting generated properly and it is affecting to my excel report also. So I am not getting what is the issue, please could anyone help me

I am not using any groups or tables, because it gives duplicate records, so only I am just pulling all fields into detail band, but the problem is, it is not supporting that query well, even though it is correct

The query which I have written for fetching data from 3 tables is working fine in SQL server management studio and MS Access but in Jaspersoft studio it is giving unexpected output with many duplicate records. My query looks something like this Employee table: emp_Id, emp_name, salary, Dep_num, project_id --->Primary key=emp_Id Department table: Dep_num, Dep_name, Manager ----->Primary key= Dep_num Project table: project_id, project_name, project_loc ------->Primary key=project_id I want to have a resul table like emp_name, Dep_name,project_name I have written query like this select emp_name, Dep_name, project_name from Employee as E inner join Department as D on E.Dep_num = D.Dep_num inner join Project as P on E.project_id = P.project.id; so I am awaiting any response from jasper team, query is fine but jasper is not giving correct output, anyone help me out, how to deal with this issue

In Jasper reports server, while adding new Data Source, we need to select jdbc drivers related to our database. So here I am using 'ucanaccess' jdbc driver to connect the MS Access database, how can I add this driver in the jdbc driver selection list.