dnvsrikanth

Hi Teodard, Thanks for the help. I have resolved the CSV issue. But theres another problem in this in which a javascript code snippet is being added everytime I export the report to CSV format. I am attaching the CSV file exported using JasperReports API and the CSV filestream. Please help me in this regard, our product is at a release state in which this issue is one of the issues which is pulling the release Thanks, DNV Srikanth

Hi, That can be possible through a web application. Refer to webapp folder demo/samples folder in the JasperReports distribution. It contains the samples which explain how to export a report to multiple formats. DNV Srikanth.

Hi You can actually download the JasperServer source code and can embed it in your applications. DNV Srikanth

Hi, Set the isRemoveLineWhenBlank attribute to true for graph and set the printWhenExpression of the graph such that the graph will be printed only once in the report. DNV Srikanth

Hi, If am not wrong you can create password protected files in the case of XLS export only. Thanks DNV Srikanth

hi othmasoft I think iReport is unable to find the scriptlet, check whether the scriptlet is included in classpath or not... DNV Srikanth

Hi Use Crosstab for this. This meets your requirement. DNV Srikanth

Hi, Can you elaborate what you want to do? What is that you are trying to do?? DNV Srikanth

Hi Teodor Can you please help me in this regard? Thanks, DNV Srikanth.

Can anyone please help me in this regard?? Thanks, DNV Srikanth.

Hi Compile the jrxml template with iReport. If its compiled successfully the jasper file will be created. DNV Srikanth

Hi Nithin, Refer these links: http://www.devx.com/Java/Article/29309 http://www.docstoc.com/docs/2139263/Jasper-Report-Tutorial http://aspalliance.com/1140 DNV Srikanth.

Hi, We are using JasperReports to generate Reports in our Web application. Its great that JasperReports exports the report to various format. I have a small problem in CSV export where in when I export the page to CSV format, the data is not set properly, I mean to say the column headers are at one location and the values are at another location say to the below-right of the column-headers. But I expect that the data need to be below the column-headers. I am attaching a CSV file exported by using JasperReports. Anyone Please help me out of this problem. This issue is reported by one of our clients and I need to resolve it as early as possible Thanks, DNV Srikanth. Post Edited by dnvsrikanth at 11/06/2009 17:19 Post Edited by dnvsrikanth at 11/06/2009 17:20

Hi Check whether the jar file is included in classpath or not or check whether you have given any package for the costomiser class. Thanks, DNV Srikanth Post Edited by dnvsrikanth at 07/17/2009 15:56

can anyone help me in this regard...

yes....exactly

Hi Amit, Just mention the customizer class in the chart properties. Prepare a jar file with the customizer class and add the jar file to the classpath of iReport. DNV Srikanth.

Hi Where can I find the Internationalization menu in iReport-nb-3.5.2? Can anyone tell me where I can find the Internationalization in iReport-nb-3.5.2 Thanks, DNV Srikanth. Post Edited by dnvsrikanth at 07/15/2009 15:54

Hi, Just pass the parameters to the SP in the same order as how they are declared in SP. Otherwise you will end up with lot of exceptions. DNV Srikanth

prasad_psl Wrote: Hi, I am also want to call the stored procedure .. but i dont know where i should create the callable statment for ireport. You mentioned above how to write the callable statment .But where i can write this statement. It will be good if you please explain in the step by step ,that how one can use the stored procedure in ireport.. Thanks Prasad Hi If you want to call stored procedures and use Callable Statements you need to use it in the Java generator class where in the jrxml file is being compiled, filled and displayed onto the screen or printed. DNV Srikanth.

Hi have you inserted a page break in the report?? Use printWhenExpression of the page break and set it to print after 50 records in a page. DNV Srikanth. Post Edited by dnvsrikanth at 07/08/2009 11:37

Hi Thank you, I'll check the link provided and implement as you have mentioned. But the code I have mentioned worked properly. But later logging was implemented in the application and everything was fine except these exports. Anyhow I'll refer the link mentioned. And this is the code am using for excel stream: Thanks, DNV Srikanth Code:if(formatType.equals("excel")) { ServletOutputStream outputStream= response.getOutputStream(); exporter = new JExcelApiExporter(); ByteArrayOutputStream xlsReport = new ByteArrayOutputStream(); response.setContentType("application/xls"); response.setHeader("Content-Disposition", "inline; filename=\""+reportName+".xls\""); exporter.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, xlsReport); exporter.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.FALSE); exporter.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); exporter.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE); exporter.setParameter(JExcelApiExporterParameter.IS_FONT_SIZE_FIX_ENABLED, Boolean.TRUE); exporter.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE); exporter.exportReport(); byte bytes[] = xlsReport.toByteArray(); response.setContentLength(bytes.length); outputStream.write(bytes, 0, bytes.length); outputStream.flush(); outputStream.close(); }

Hi, REPORT_COUNT is a built-in variable which has total no.of records in a report.So when you place this in the detail band in the report it will check for the no.of pages per page.sorry instead of the expression mentioned previously use the following one:DNV Srikanth. Code:new Boolean($V{REPORT_COUNT}.intValue() == 50)

Hi, This is the code I am using to export the report to pdfstream: From the JSF page am passing a parameter to Java Generator Class and exporting the report based on the parameter passed. DNV Srikanth Code:if(formatType.equals("pdf")){JRExporter exporter = null;exporter = new JRPdfExporter();response.setContentType("application/pdf");response.setHeader("Content-Disposition","inline;filename=\""+reportName+".pdf\"");exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream());exporter.exportReport();}

Hi, I am herewith attching the screenshts of the report exported to HTML, PDF and EXCEL formats. Thanks, DNV Srikanth.