88.srivatsan

I have generated reports using Jasper IReport and compiled it in Java. I'm filtering the report dynamically with the user driven dates. It displays the filtered data in the screen. but if export the filtered report it exports unfiltered data. I think its because of object flush isn't working properly. is there any way to flush objects inJasper ?

I got it fixed with changing the parameters in the table data Source . The mistake was selecting the database fields instead of main report parameters>>

even if i give USE DEFAULT , it fails for me. I'm in IST and i give I have changed the format options in ireport-> tools->options->compilation-> parameter prompt. but still it shows some random format in the report

Thank you for the response. it works very fine if i hard code the dates or use default dates . but if i pass the same default dates via prompt it fails. I wonder where the thing goes wrong . please help

Thank you for the response . I dint give any input. For default values I'm getting two diff output . In query window it's correct and in report it fails

Thank you for the response . I dint give any input. For default values I'm getting two diff output . In query window it's correct and in report it fails

Hi All, I have designed a report in ireport 5.0 , where the query works very fine in the query window. It pulls up proper data from the DB with respect to the default parameters.but if i run the report preview it fails and pulls up wrong data

Was it working on query window with default values ? Did you check the date format of you DB. Change the date format of Ireport in Tools->options->ireport->compilation and execution-->parameter prompt --> date format.

Was it working on query window with default values ? Did you check the date format of you DB. Change the date format of Ireport in Tools->options->ireport->compilation and execution-->parameter prompt --> date format.

Hi I'm getting null values when i compile my JRXML and print it to PDF via java. package com.test;import java.io.IOException;import java.util.HashMap;import java.util.Map; import net.sf.jasperreports.engine.JREmptyDataSource;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JasperCompileManager;import net.sf.jasperreports.engine.JasperExportManager;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.JasperReport; public class PdfFromJasperFile { public static void main(String[] args) throws JRException, IOException { JasperReport jasperReport; JasperPrint jasperPrint; Map param = new HashMap(); try{ String sourceFileName = "C:/Users/Sadagopan/Documents/report3.jrxml"; jasperReport = JasperCompileManager.compileReport(sourceFileName); jasperPrint = JasperFillManager.fillReport(jasperReport, param, new JREmptyDataSource()); JasperExportManager.exportReportToHtmlFile(jasperPrint, "C:/Users/Sadagopan/Documents/sample.html"); } catch(Exception e){ e.printStackTrace(); } } } my JRXML file <?xml version="1.0" encoding="UTF-8"?> select * from person where name =sadagopan ]]></fieldDescription> </field> <field name="name" class="java.lang.String"> <fieldDescription><![CDATA[ ]]></fieldDescription> </field> <field name="phonenumber" class="java.lang.String"> <fieldDescription><![CDATA[ ]]></fieldDescription> </field> <field name="pension" class="java.math.BigDecimal"> <fieldDescription><![CDATA[ $F{id} $F{name} $F{phonenumber} $F{salary} Person Salary report iD Name Address Phonenumber salary pension $F{id} $F{name} $F{address} $F{phonenumber} $F{salary} $F{pension} $F{id} $F{salary}