kcronin

So, I am starting to be at a loss here. Basically for a report I am working on, I need to create a second report that is near identical, but the grouping is different and it has an extra column in there. It sounds simple enough. Now, I need to say that the query itself is very large. So, what I am doing is coping the jrxml and directly pasting it into the folder it is currently in, and then renaming that jrxml to what I want. That works just fine. I then try to add the column, or any column, and get this error: net.sf.jasperreports.engine.JRException: Unknown column name : column_name Now, just to test this, what I did was deleted the entire query from the copied report, and then changes the entire query to this: select '1' as testingvar I then deleted everything from the report to give myself a clean document, but once that query is in there, iReport refuses to let me modify it. Well, I take that back. I can delete columns from it just fine, but when I go to add any columns, this error comes up. Is there something within iReport that will lock these files and it is just not telling me? I did not give the query I am using because it is not very important. It works just fine in the other report, and if I copy and paste it to create a new jrxml, everything will still work just fine. If I did a copy and paste and did not modify anything, it works flawlessly. The moment I try to add any column, I get the error that I showed you above. Is there something I am missing? This thinks that the column does not exist when it is the only column in the query, and the document is empty, so it is not trying to pull from anything even from a DB. If you want to see the jrxml, please let me know. I need to go through it and ensure that there is no company information in there, but I am willing to post it up. I am just avoiding it since something like this seems like something that would be common to happen (making a report near identical to another one with a big query), so I am hoping somebody has experienced this before. EDIT: With the error I am getting where I say the unknown column is column_name, I made up column_name just for this post to ensure no company information is given out Post Edited by kcronin at 01/06/2012 01:13

I figured that I would post the solution that I found for myself in case anybody else runs into this issue. What happened was that most of the sub reports were static, which means that they were all going to be much larger than 802 (the main issue was printing since with a massive height, everything would get shrunk down to almost unreadable). What I did was created some new bands so that there were no bands that were bigger than 802 (I just created empty report groups and used those as extra bands). Then I manually went into the jrxml files and manually changed the height to 802 on the sub reports. Since iReport accepted those values, I made sure that no bands at all were 802 big and all were smaller (sometimes splitting the bands with new bands I created). Then I manually went in and changed the main jrxml file's height and the report ran just fine with the new, lower height. My main issue was that since my height was 1775, printing my reports became difficult for the users (the page size was just far too large). I found out that even at a page height of 900, that Adobe Reader will still allow it to print 1 page per paper page without shrinking much if at all (it is not noticable at all). So that is the solution I found. Make additional bands through making empty report groups and make sure no band is over 802, then you can manually change the sub report's jrxml height to 802, which will allow for the main report's jrxml to be shortened to a height that with allow for printing to not completely shrink everything Post Edited by kcronin at 09/16/2011 15:54

I have a report with multiple subreports. Now, I am trying to get the page size of the report back down to 802 (which it seems to default on), but I have a sub report that is 1,715 big, and when I adjust the main report's page size, Java will give me an out of memory error. There is no way to make the sub report smaller. Is there something else I can do to force the proper page size even though a sub report is too big? Any tips or tricks you can think of to make this happen? I am not at a complete loss or anything, but I am confused as to what I should do in order to have a big subreport, but the report has a small page size. I would think the end result would be the subreport gets cut off when it goes to the next page (which I am 100% fine with), but I am trying to get to that point

I am looking for some documentation on cross tabs. Any documentation will be nice. The only thing I have found on them is this: http://ireport-tutorial.blogspot.com/2008/10/ireport-crosstab-report.html And he flies through that, doesn't explain anything, and that is it. Basically, the amount of rows I am going to have is going to be dynamic and the amount of columns is going to be dynamic. I tell it what I want the columns to be based on the query, and what I want the rows to be. Nothing happens. I would rather read up and get knowledge of cross tabs, but the the Wiki seems almost empty and the docs do not say anything about cross tabs. Can I please be directed to where any documentation on cross tabs exists so that I can get mine working. I am 99% confident my cross tabs stuff is very simple, but with no documentation, I am really just messing with the software trying to figure it out as I go, which is probably not the best technique Here is an example of what I am looking for when it comes to dataset and end result: dataset: name test# score james s 1 12 james s 2 13 james s 3 21 mike r 1 21 mike r 2 32 mike r 3 12 and this will be the end result. test 1 results test 2 results test 3 results james s 12 13 21 mike r 21 32 12 Now, with this example, this could get more than 3 tests. It could get 70 tests, or it could get 1. It could get all 300 students, or just 5 of them. This is what I am talking about with dynamic rows and columns. Crosstabs seemed like my best option, until I was unable to find any documentation on it. Either that or if somebody has ran into dynamic rows and columns like this and can tell me something other than cross tabs, that would be amazing. Also, as you can see, I could technically group them, but it would not really do anything. Post Edited by kcronin at 07/14/2011 19:31 Post Edited by kcronin at 07/14/2011 20:16

Wow, you get the awesome green + sign from me. That worked like a charm and was exactly what I was trying to do. Thank you for your help.

I thought this would be simple, but either it is very simple, or I am missing something. What I am trying to do is simple: I have a column that is a BigDecimal and this column is in a group that I created within iReport. I want the total for a group footer. Example: This is the group header \/ \/ \/ account number Name debt 12345 James 40.00 12345 Mike 55.00 Total debt: 95.00 ^ ^ ^ This is the group footer How would I be able to get the total of 95.00 through iReport itself since the debt is in a group that is based off of the account number?

I gave you a plus since that was the exact answer I needed and was awesome (even though you solved it yourself, you still solved it)

One of these days I will get this report done (I am still working on that same one that I have been posting about for the past few days, but just went about it a different way). Ok, so I have a sub query that will run great on its own. I have a main report that will work great on its own. When I try to combine them, I get this: Error filling print... cannot assign instance of net.sf.jasperreports.engine.base.JRBaseFrame to field net.sf.jasperreports.engine.base.JRBaseLineBox.boxContainer of type net.sf.jasperreports.engine.JRBoxContainer in instance of net.sf.jasperreports.engine.base.JRBaseLineBox java.lang.ClassCastException: cannot assign instance of net.sf.jasperreports.engine.base.JRBaseFrame to field net.sf.jasperreports.engine.base.JRBaseLineBox.boxContainer of type net.sf.jasperreports.engine.JRBoxContainer in instance of net.sf.jasperreports.engine.base.JRBaseLineBox at java.io.ObjectStreamClass$FieldReflector.setObjFieldValues(Unknown Source) at java.io.ObjectStreamClass.setObjFieldValues(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.util.ArrayList.readObject(Unknown Source) at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at java.io.ObjectStreamClass.invokeReadObject(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at java.util.ArrayList.readObject(Unknown Source) at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at java.io.ObjectStreamClass.invokeReadObject(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:88) at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:257) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:308) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:257) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1380) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeader(JRVerticalFiller.java:591) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupHeaders(JRVerticalFiller.java:524) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:253) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:814) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:517) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:910) at java.lang.Thread.run(Unknown Source)

I need a report to use 2.0.2, but even when I the compatibility of iReport to 2.0.2-2.0.4, it will still want to convert my deprecated tags. Since the website that is running this is using 2.0.2, I need to ensure that everything stays in accordance to that. Is there a way for Ireport 3.0.0 to no convert to the new syntax and just go based off of the 2.0.2 syntax?

I figured it out and might as well post on it (it is so simple that it is annoting): The height of that toolbar was set to zero, so I just scrolled down there with my mouse until the cursor changed to the "change height" mouse cursor and then just dragged it back up

I ended up figuring this out and I might as well post what happened for future reference. This happened because my version of iReport was using a higher version of the jasperreports jar file than my java code was. Updating that jar fixed that problem.

Yes, I am making sure that they have the correct names and paths. This only happens in iReport itself, as if I run the report outside of it, I do not run into this issue

The options that I have under window are: Cascade Tile Horizontally Tile Vertically Tile All Next Window Previous Window Show/Hide Right Side I do not seethe option you are referring to EDIT: I found where I should go to view it, View->Docking Panes-> Show output Window It was already checked. When I try to uncheck it and check it again, nothing happens. Post Edited by kcronin at 11/01/2010 15:16

I did a search for this one since it seems more common, but I did not find anything. The window that loads at the bottom that says the status of builds of reports, how do you get that back up? I have a build that is not creating a jasper file and need that window back up to find out why

I should probably add this thread since I have been just going in and deleting these, but I am sure there is some purpose to them. This is the error: Invalid element 'topPen' in content of 'box', expected closing tag. Here is the chunk in question which has been auto-generated by iReport: <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> I guess I am curious why this would throw an error. If I have to fix this manually until there is a fix for this, I am more than willing to do that, but I do find it odd that I am one of the slim few that runs into this error. I guess I am also curious as to why this chunk is auto-generated by iReport if it just throws an error? I have tried putting a space in between where it has the line color and the closing tag, but that does not work. I have also tried splitting up the tag by doing this: <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"></topPen> That seems to have no effect either. EDIT: What is topPen even used for? Everytime I make a report, I could do nothing, and have a bunch of these in there. I also double checked my version of jasperreports and I am using 3.0.1 Post Edited by kcronin at 10/29/2010 20:50 Post Edited by kcronin at 10/29/2010 21:15

So I am pulling in some subreports, but for some reason, they are not properly updating. I know they are not updating simply because I put a test static text box in that simply said "test". I deleted that textbox and recompiled everything, but I still see that static textbox "test" when I run the main report that pulls the .jasper for the subreport. Is there some type of "Please get the most current .jasper file" button somewhere that I am not seeing? EDIT: I need to add as well that if I directly open the sub report from the main report and and run the sub report, it runs the current version. If I go and run the main report that I opened the sub report from, the old version still shows up with that test textbox. I have triple checked that the main report is using the correct .jasper file (well, it is supposed to). I have also triple checked that the sub-report is compiling to the location that the main report is looking for. Post Edited by kcronin at 10/29/2010 19:29 Post Edited by kcronin at 10/29/2010 21:14

So my report is doing a page break on every single row it returns. How do I make this not happen?

You just made it click in my head. It was completely a connection issue as for some of my parameters had to hit a database, but I was closing the connection, so when I would go to run the report, it had no db connection since I was closing it in gathering the parameters

I have verified that my parameters from my java code are correct and going through properly to the Jasper report, but when I try to run my report, I am getting the following error: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query For safety sake, I am going to simple show an example for what it is showing for a query: Select something From some_table Where thedate between ? and ? and someid in ( ? ) Why would this show question marks. I am 99% sure that my report is not running because of this.