citress

I just realized that the same problem exists in iReport when I preview the template in XLS and XLSX formats. Help??

Hi, I am trying to export a Jasper report to XLS format however the data in the Detail band is not showing up - everything else such as the pie chart, grouping header and footer all contain correct data. I have exported the same report (same template, same fill data) in PDF with no issues. Can someone please take a look and let me know what I may be missing? I am using Excel 2007 on Windows 7 to open and view the report. It would open the report in compatibility mode (since it is .xls format, not .xlsx) - could this be an issue? Below is the code I use for the export to XLS. I have attached the generated XLS as well as my report template. Thanks! Code:JRXlsExporter exporter = new JRXlsExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);

Hi, I have a main report where I have defined 3 groups/bands for 3 different charts. I used to put everything into the Summary band but was running into weird spacing issues. Then I read somewhere that if I put each chart into their own individual band, and define a dataset for each, it would be a better approach. I tried this out, however only the chart in the first band prints. The second band prints an empty chart and the third band (which is a subreport), prints nothing (not even the static text). However if I delete the first 2 bands, the last band prints. If I delete any two bands, the last one prints - so it seems like my report only prints one band. What am I doing wrong? I've attached my XML, please take a look and let me know. Thanks!

Thanks! This looks promising. I will give that a shot.

Hi, I have defined a Group in my report and also a variable that contains the count per group. I would like to display a simple table that displays the grouping expression in the columns and the count for the group in the row below. So my table simply has columns that represent each element in a group, and a single row that contains the count of the items in that group. How do I do that? I tried using a table but had trouble defining the datasource expression since the rows are coming from a user-defined variable. Or is there another way to present the information I'd like to show, other than a chart (since I'll have a similar more detailed chart operating on the same dataset and the table is more like a summary)?

I did try using dataSourceExpression, but since I using JRBeanCollectionDataSource, there can only be one bean type in the collection. For each of my subreports, they require different bean types and each bean collection has to be sorted differently (for proper grouping in iReport). So it seems to me that I cannot use dataSourceExpression. If I am missing something, please let me know. I am not connecting to the database directly from within iReport, so that would preclude me from using connectionExpression.

Hi, I would like to include multiple sub-reports in a master report, using different JRDataSources for each sub-report. Is this possible? I know that another approach is to create individual reports and then concatenate them into a single report using JRExporterParameter.JASPER_PRINT_LIST to specify multiple reports, but doing it this way, I have no control over page breaks, as each report is on it's own page. With sub-reports, I can position two sub-reports in the same page of the master report. Any ideas?

Version: iReport 3.7.3 iReport displayed a vague error when I tried to test a JavaBeans set DataSource. In the Java class that returns the beans collection, I invoke Spring and Hibernate to query the database for results. I included all necessary jars in iReports classpath. Things work fine if I replace that with static/hard-coded values. Is there a way to turn on verbose logging so that I can see what the problem is? Thanks. /uploads/projects/ireport/error.png Post Edited by citress at 07/15/2010 17:12

Think I figured it out. :)

Hi, I'm new to JasperReports and iReports and I was wondering if there is a tutorial on using a JRDataSource to create report templates (specifically for charts) in iReport. I see tutorials for parameters but I don't see any for JRDataSource. Thanks!