Bonjour,
J'ai besoin de votre aide. je suis débutante avec jasper Report .j'ai préparé une classe java qui permet l'exportation d'un fichier dans différent forme(pdf ,xsls,Doc,ppt) et un fichier users.jrxml qui qui permet la génération de rapport et une page jsf appelant la classe java
lorsque j'exécute tous marche bien mais les fichier exporter sont vide
voici le code:
@ManagedBean
@SessionScoped
public class CompteRapport implements Serializable{
private List<Users>listusers ;
UsersDAO uDao= new UsersDAOImp();
public List<Users> getListusers() {
return listusers;
}
public void setListusers(List<Users> listusers) {
this.listusers = listusers;
}
JasperPrint jasperPrint;
public void init() throws JRException{
JRBeanCollectionDataSource beanCollectionDataSource=new JRBeanCollectionDataSource(listusers);
String reportPath= FacesContext.getCurrentInstance().getExternalContext().getRealPath("/stat/users.jasper");
jasperPrint=JasperFillManager.fillReport(reportPath, new HashMap(),beanCollectionDataSource);
}
public void PDF(ActionEvent actionEvent) throws JRException, IOException{
init();
HttpServletResponse httpServletResponse=(HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();
httpServletResponse.addHeader("Content-disposition", "attachment; filename=report.pdf");
ServletOutputStream servletOutputStream=httpServletResponse.getOutputStream();
JasperExportManager.exportReportToPdfStream(jasperPrint, servletOutputStream);
FacesContext.getCurrentInstance().responseComplete();
}
public void DOCX(ActionEvent actionEvent) throws JRException, IOException{
init();
HttpServletResponse httpServletResponse=(HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();
httpServletResponse.addHeader("Content-disposition", "attachment; filename=report.docx");
ServletOutputStream servletOutputStream=httpServletResponse.getOutputStream();
JRDocxExporter docxExporter=new JRDocxExporter();
docxExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
docxExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, servletOutputStream);
docxExporter.exportReport();
FacesContext.getCurrentInstance().responseComplete();
}
public void XLSX(ActionEvent actionEvent) throws JRException, IOException{
init();
HttpServletResponse httpServletResponse=(HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();
httpServletResponse.addHeader("Content-disposition", "attachment; filename=report.xlsx");
ServletOutputStream servletOutputStream=httpServletResponse.getOutputStream();
JRXlsxExporter docxExporter=new JRXlsxExporter();
docxExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
docxExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, servletOutputStream);
docxExporter.exportReport();
FacesContext.getCurrentInstance().responseComplete();
}
public void ODT(ActionEvent actionEvent) throws JRException, IOException{
init();
HttpServletResponse httpServletResponse=(HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();
httpServletResponse.addHeader("Content-disposition", "attachment; filename=report.odt");
ServletOutputStream servletOutputStream=httpServletResponse.getOutputStream();
JROdtExporter docxExporter=new JROdtExporter();
docxExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
docxExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, servletOutputStream);
docxExporter.exportReport();
FacesContext.getCurrentInstance().responseComplete();
}
public void PPT(ActionEvent actionEvent) throws JRException, IOException{
init();
HttpServletResponse httpServletResponse=(HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();
httpServletResponse.addHeader("Content-disposition", "attachment; filename=report.pptx");
ServletOutputStream servletOutputStream=httpServletResponse.getOutputStream();
JRPptxExporter docxExporter=new JRPptxExporter();
docxExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
docxExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, servletOutputStream);
docxExporter.exportReport();
FacesContext.getCurrentInstance().responseComplete();
}
}
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="null" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="3b546d4f-cc1e-4e9d-92f2-725b0ae9214b">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="101"/>
<style name="Title" forecolor="#FFFFFF" fontName="Times New Roman" fontSize="50" isBold="false" pdfFontName="Times-Bold"/>
<style name="SubTitle" forecolor="#CCCCCC" fontName="Times New Roman" fontSize="18" isBold="false" pdfFontName="Times-Roman"/>
<style name="Column header" forecolor="#666666" fontName="Times New Roman" fontSize="14" isBold="true" pdfFontName="Times-Roman"/>
<style name="Detail" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman"/>
<style name="Row" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman">
<conditionalStyle>
<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
<style mode="Opaque" backcolor="#F0EFEF"/>
</conditionalStyle>
</style>
<queryString language="SQL">
<![CDATA[SELECT
users.`idEmp` AS users_idEmp,
users.`nom` AS users_nom,
users.`prenom` AS users_prenom,
users.`cin` AS users_cin,
users.`dateEmbauche` AS users_dateEmbauche,
users.`fonction` AS users_fonction,
users.`mail` AS users_mail
FROM
`users` users
WHERE
users.enabled = true]]>
</queryString>
<field name="users_idEmp" class="java.lang.Integer"/>
<field name="users_nom" class="java.lang.String"/>
<field name="users_prenom" class="java.lang.String"/>
<field name="users_cin" class="java.lang.Integer"/>
<field name="users_dateEmbauche" class="java.sql.Date"/>
<field name="users_fonction" class="java.lang.String"/>
<field name="users_mail" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="132" splitType="Stretch">
<frame>
<reportElement mode="Opaque" x="3" y="0" width="537" height="95" backcolor="#000000" uuid="aebc1c67-36f7-44d2-ad14-5807d172a291"/>
<staticText>
<reportElement style="Title" x="17" y="15" width="504" height="66" uuid="a524a12e-93d8-4cda-b497-aefe299bdda2"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[List desEmployés]]></text>
</staticText>
</frame>
<frame>
<reportElement mode="Opaque" x="0" y="100" width="553" height="32" forecolor="#000000" backcolor="#CC0000" uuid="24f86c32-1927-425b-86a3-b2a7ecff6400"/>
<textField pattern="EEEEE dd MMMMM yyyy">
<reportElement x="307" y="12" width="144" height="20" forecolor="#FFFFFF" uuid="743a7a0c-3745-4981-975a-0a0a79509816"/>
<textElement textAlignment="Right">
<font size="12"/>
</textElement>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</frame>
</band>
</title>
<pageHeader>
<band splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band height="26" splitType="Stretch">
<staticText>
<reportElement style="Column header" x="0" y="7" width="79" height="18" forecolor="#000000" uuid="135b858e-32c1-46b0-8dc6-f6b3adb06277"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[ID]]></text>
</staticText>
<staticText>
<reportElement style="Column header" x="79" y="7" width="79" height="18" forecolor="#000000" uuid="b88bc1c2-0405-4d7f-a102-7e433308cbe6"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[ nom]]></text>
</staticText>
<staticText>
<reportElement style="Column header" x="158" y="7" width="79" height="18" forecolor="#000000" uuid="f1dc845f-8a74-467a-867b-40a1a71a08a7"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[prenom]]></text>
</staticText>
<staticText>
<reportElement style="Column header" x="237" y="7" width="70" height="18" forecolor="#000000" uuid="686b2dc9-df26-43ab-8291-87b966515db3"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[ cin]]></text>
</staticText>
<staticText>
<reportElement style="Column header" x="316" y="7" width="79" height="18" forecolor="#000000" uuid="37a5ffe3-714d-48ee-bd74-406564cae668"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[date Embauche]]></text>
</staticText>
<staticText>
<reportElement style="Column header" x="407" y="7" width="56" height="18" forecolor="#000000" uuid="d899144c-b924-4242-84c7-287a4e314acd"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[ fonction]]></text>
</staticText>
<staticText>
<reportElement style="Column header" x="476" y="7" width="79" height="18" forecolor="#000000" uuid="d7297634-3ca1-459b-9de1-3b69ba58141a"/>
<textElement>
<font isBold="false"/>
</textElement>
<text><![CDATA[email]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="21" splitType="Stretch">
<frame>
<reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="18" uuid="32ac4f04-dd66-4064-87a5-e060a4faedec"/>
<textField isStretchWithOverflow="true">
<reportElement style="Detail" positionType="Float" x="0" y="0" width="79" height="18" uuid="23a741f8-9c9d-4138-a685-99d95fe14473"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{users_idEmp}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement style="Detail" positionType="Float" x="79" y="0" width="79" height="18" uuid="2d6fa6a0-8f4b-4cfa-8c2f-f86ca8a13c23"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{users_nom}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement style="Detail" positionType="Float" x="158" y="0" width="79" height="18" uuid="e8b24937-164c-4ba6-a2a0-47be476de962"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{users_prenom}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement style="Detail" positionType="Float" x="237" y="0" width="79" height="18" uuid="163bb2b4-e007-4512-9d26-dc2da889f625"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{users_cin}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement style="Detail" positionType="Float" x="316" y="0" width="79" height="18" uuid="85e82587-d9a7-4dbe-8dec-289e37603670"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{users_dateEmbauche}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement style="Detail" positionType="Float" x="407" y="0" width="67" height="18" uuid="7fd63226-2e97-4c5e-b9bb-abdb0937e917"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{users_fonction}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement style="Detail" positionType="Float" x="476" y="0" width="79" height="18" uuid="379cd038-1d05-4381-8823-40270c85ec47"/>
<textElement>
<font size="14"/>
</textElement>
<textFieldExpression><![CDATA[$F{users_mail}]]></textFieldExpression>
</textField>
</frame>
</band>
</detail>
<columnFooter>
<band height="226" splitType="Stretch">
<line>
<reportElement positionType="FixRelativeToBottom" x="0" y="3" width="555" height="1" uuid="aaea7108-4ce4-4803-8f18-ce3fe9e9c324"/>
<graphicElement>
<pen lineWidth="0.5" lineColor="#999999"/>
</graphicElement>
</line>
</band>
</columnFooter>
<pageFooter>
<band height="223" splitType="Stretch">
<frame>
<reportElement mode="Opaque" x="3" y="199" width="555" height="24" forecolor="#D0B48E" backcolor="#000000" uuid="bfcff4b5-ef43-4fc4-a8f2-65b6f4c44dcc"/>
<textField evaluationTime="Report">
<reportElement style="Column header" x="513" y="0" width="40" height="20" forecolor="#FFFFFF" uuid="c4d57545-a23f-42fa-bf65-a7b124b8989d"/>
<textElement verticalAlignment="Middle">
<font size="10" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<textField>
<reportElement style="Column header" x="433" y="0" width="80" height="20" forecolor="#FFFFFF" uuid="8da2ac68-0a03-49ed-b855-d6e08d6287c4"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="10" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
</textField>
<textField pattern="EEEEE dd MMMMM yyyy">
<reportElement style="Column header" x="2" y="1" width="197" height="20" forecolor="#FFFFFF" uuid="51ac2d16-ca41-47db-901a-2b949f6da0be"/>
<textElement verticalAlignment="Middle">
<font size="10" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</frame>
</band>
</pageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
</jasperReport>
Afficher la suite
5 août 2016 à 12:12
5 août 2016 à 22:14