jaesun

I am wondering if it is possible to create a report that has multiple columns, but goes verticle at first, then horizontal when the group changes? I created a test report, that basically had this: SELECT'Gender' AS section, 'Male' AS ky, 10 AS valUNIONSELECT'Gender' AS section, 'Female' AS ky, 20 AS valUNIONSELECT'Ethnicity' AS section, 'Asian' AS ky, 30 AS valUNIONSELECT'Living' AS section, 'Home' AS ky, 40 AS valUNIONSELECT'MaritalStatus' AS section, 'Married' AS ky, 50 AS valORDER BY section DESC I then went to Report Group, made a group with the expression off section, and checked Start on a New Column In Report Properties, I made 4 columns, going vertical. It would work, except, Gender would start on a new column (but no group header). If I changed the query, and added another MaritalStatus, then Gender, would both be under the 1 column as I wanted. So basically, it seems that the number of "rows" in the first column dictated the max number of rows in the rest of the columns? So if the first column only had 3 records, then the rest of the columns would have a max of 3 rows and any remaining rows be put into the next column.

I was creating and testing a report. I took a report, tested and was able to generate a report just fine. I then took that report, made it a subreport. I created the seperate parent report, that called that subreport, passed in 2 parameters it needed, then ran the report. But it just hangs as soon as it starts generating the report (the threads box shows a "Generating report" action and it just sits there. If I pass it a variable that doesn't exist in the database, it generates just fine and comes up with an empty pdf. Not sure what the issue is? I run the subreport alone and it runs just fine (fast, no delays, etc). But as soon as I run it from the parent report, it just hangs? I can execute the report on an empty data source and it is fine. I have to end the thread, or else iReports starts running slugglishly. I am running iReport 2.0.4 (yes I know it's an old version)

ahh, that explains it. Looks like I will downgrade iReports. In the meantime, its me moving the whole report boxes around to fix it, hah!

I created my report in iReport. In several areas, I used Rectangle objects with a thin border around it, stacked on each other (to look like rows or what not) When I test the report printout in iReport, it comes out fine. Fine as in, All the data is there, the rectangle boxes are there as expected. I then go to my java code, and run it, but then a problem exists. Those rectangle boxes, where they are stacked on top of each other, the lines between them, are doubled up and "bolded". the lines between the rows are much thicker. Jasperreports Version: 2.0.2 iReports Version: 2.0.4 I input the java code int he code box, just in case that helps I've done reports like this just fine before. not sure what the issue is? I uploaded a screenshot of what I am talking about Code: String jReportPath = getServletConfig().getInitParameter("jasperReportPath"); InputStream input=new FileInputStream(new File(jReportPath + "Report.jrxml")); Map parameters = new HashMap(); parameters.put("SUBREPORT_DIR", jReportPath); parameters.put("CAMLKADMITID", this.reportId); JasperDesign design = JRXmlLoader.load(input); JasperReport report = JasperCompileManager.compileReport(design); JasperPrint jasperPrint = JasperFillManager.fillReport(report, parameters, db); JasperExportManager.exportReportToPdfStream(jasperPrint, getResponse().getOutputStream());

I have the parent, main report. Just consists of a header, and detail bands I then have a subreport, with header, detail, and lastpagefooter (also tried with summary). Problem is, when I use a Lastpagefooter/summary in the subreport, and print out the PDF of the parent report, it will print out a blank page at the end of the report (with the blank page having the header, but nothing else). any ideas?

what's the difference between the usage? I cannot find anything on this. But I know there is a difference between the two, at least when I use the paramter in a SQL statement.

harinderrakkar Wrote: U can do it by making all the position type of below elements float from the properties of that elements. Regards Harinder Singh I have tried that to no avail. I will hide an element, but all the elements after that hidden element are still in the same location (not moving up) even though the position type is float

I have a report, and I compiled it. It was running fine (I ran with empty datasource and datasource), until recently, it would compile with some exceptions, but it would still generate the end report just fine without any issue. It happened after I made objects Position Type as Float (due to subreports, etc). None of the subreports link to another subreport yet, but that didn't seem to cause the problem. Also, sometimes, when I compile, it gives no error. The Exceptions just show up in the log after compiling over and over again (without making any changes) Here are the exceptions: Compiling to file... \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.jasper -> \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.java at javax.swing.plaf.basic.BasicTabbedPaneUI.calculateTabHeight(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI.calculateMaxTabHeight(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.calculateTabRects(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.calculateLayoutInfo(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.layoutContainer(Unknown Source) at java.awt.Container.layout(Unknown Source) at java.awt.Container.doLayout(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validate(Unknown Source) at javax.swing.RepaintManager.validateInvalidComponents(Unknown Source) at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Compilation running time: 346 ============ Compiling to file... \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.jasper -> \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.java at java.awt.Container.layout(Unknown Source) at java.awt.Container.doLayout(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validate(Unknown Source) at javax.swing.RepaintManager.validateInvalidComponents(Unknown Source) at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Compilation running time: 345. =============== Compiling to file... \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.jasper -> \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.java at java.awt.Container.doLayout(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validate(Unknown Source) at javax.swing.RepaintManager.validateInvalidComponents(Unknown Source) at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Compilation running time: 345 ================ Compiling to file... \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.jasper -> \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.java at javax.swing.plaf.basic.BasicTabbedPaneUI.calculateMaxTabHeight(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.calculateTabRects(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.calculateLayoutInfo(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.layoutContainer(Unknown Source) at java.awt.Container.layout(Unknown Source) at java.awt.Container.doLayout(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validate(Unknown Source) at javax.swing.RepaintManager.validateInvalidComponents(Unknown Source) at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Compilation running time: 329 =================== Compiling to file... \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.jasper -> \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.java at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Compilation running time: 345 =================== Compiling to file... \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.jasper -> \Desktop\jrxml\compqa\ComplianceQA_Findings_Combination_Counselor.java at javax.swing.plaf.basic.BasicTabbedPaneUI.getTextViewForTab(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI.calculateTabHeight(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI.calculateMaxTabHeight(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.calculateTabRects(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.calculateLayoutInfo(Unknown Source) at javax.swing.plaf.basic.BasicTabbedPaneUI$TabbedPaneLayout.layoutContainer(Unknown Source) at java.awt.Container.layout(Unknown Source) at java.awt.Container.doLayout(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validateTree(Unknown Source) at java.awt.Container.validate(Unknown Source) at javax.swing.RepaintManager.validateInvalidComponents(Unknown Source) at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Compilation running time: 329 Post Edited by jaesun at 07/27/2009 23:32

I have certain objects (rectangles for styles, etc), text, and even subreports that are run in a report and are sometimes hidden depending on certain values that are passed in (hidden using "Print when expression" under the preferences). But it also leaves a blank space/gaps where the objects would normally be. Is there a way to make it objects and everything below the hidden object "float" up so that it would occupy that space where the hidden object would be if it was printed? Post Edited by jaesun at 07/27/2009 23:32