lilyrh09

You were right @reportdev, I've added it and it worked as intended. Thanks!

maridion

Hi! I have a report with the following structure: PAGE HEADER DETAIL BAND (12 of those) SUMMARY BAND The detail bands shows depending on expressions I specified. What I'm trying to achieve is to execute the report without any filter as the ID or any other field of the table. Instead, I want to extract the information of all the registers of one specific table (let's name it USER). What I'm expecting to find when I execute the report is something like the following: PAGE HEADER detail sections (shown depending on the expressions) SUMMARY What I'm getting looks similar to the following: PAGE HEADER DETAIL 1 (for user1) DETAIL 2 (for user1) DETAIL 1 (for user2) DETAIL 4 (for user3) and never the summary band (just at the end of the report) As you can see, all the users are getting mixed while what I want to do is to start a new page for each one of them. QUESTIONS: How can I get the report to show each one of the users from the table in separate pages?Is there some property I missed that allows me to do that? Thanks!

Ok, I already got a solution by myself (quite obvious), I just put the <summary><band height="100"></band></summary> tags at the end of the report's jrxml and voila! Hope it helps someone!

@avinash.eng18 Thanks for the answer, but the section is already deleted, there's no way I can select the left/right/bottom/top side of that specific section. So, what I'm asking is if there is some way of bringing that section back to the report's body. I spent more than enough searching for it in the designer but couldn't find any lead. Is it even possible?

Hi all! I have one complex report already working but now I realize I need the Summary band and can't find the way to add it nor even in Internet. Thus, I'm starting to wonder whether it can be done or I'm wasting my time.... Can someone clarify this for me? Thanks!

Hi all! Here's my problem: I have a JasperReport (mainReport) with one subreport (subReport) which, at the same time, have one subreport (subSubReport). My problem comes when I try to execute it from my web app. Those reports are extracted from an Oracle database, thus I'm passing an InputStream as "path" for them. Since I've been testing "paths" as InputStream (obtained from the same database) I know it works when I have a simple mainReport->subReport hierachy... that's why I'm pretty sure the problem lies in the way I'm passing the parameters to the subSubReport. Since now if I wanted to pass some parameter (as the path) to the subReport it has to be defined in the mainReport (also passed to the mainReport as a parameter) and it had to be passed as a parameter from the mainReport to the subReport. For that reason, I'm pasing all the parameters, even those needed for the subSubReports to the mainReport (and I'm guessing that's not the correct way since I'm getting java.lang.OutOfMemoryError: GC overhead limit exceeded when executing). I'm following the next format to define where each one of my parameters has to go: - SUBREPORT_DIR for those reports that are stored in a local folder. - SUBREPORTxLEVELy for those reports that are in the database. where: x defines the number of the subReport according to its position in the mainReport y defines the level where the parameter is necessary (in this case subReport is in level 1 while subSubReport is in level 2) For example: Having this hierarchy I'm doing it the following way mainReport ------------> subReport -------------------------> subSubReport Note that I defined SUBREPORT_DIR and SUBREPORTxLEVELy because the report can either be found in a local folder or at the database and in my jasper design I have this expression for the subreports IF($P{SUBREPORT_DIR}==null,$P{SUBREPORTxNIVELy},$P{SUBREPORT_DIR}) . Here is the code used in each report and the java code to generate the report. mainReport <subreport> <reportElement key="" x="0" y="0" width="554" height="30" isRemoveLineWhenBlank="true" uuid="18ff5513-835d-4910-b39c-6d41252b4679"/><subreportParameter name="REPORT_CONNECTION"><subreportParameterExpression><![CDATA[$P{REPORT_CONNECTION}]]></subreportParameterExpression></subreportParameter><subreportParameter name="REPORT_DATA_SOURCE"><subreportParameterExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></subreportParameterExpression></subreportParameter><subreportParameter name="SUBREPORT_DIR"><subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression></subreportParameter><subreportParameter name="SUBREPORT1LEVEL1"><subreportParameterExpression><![CDATA[$P{SUBREPORT1LEVEL1}]]></subreportParameterExpression></subreportParameter><subreportParameter name="SUBREPORT1LEVEL2"><subreportParameterExpression><![CDATA[$P{SUBREPORT1LEVEL2}]]></subreportParameterExpression></subreportParameter><connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><subreportExpression><![CDATA[iF($P{SUBREPORT_DIR}==null,$P{SUBREPORT1LEVEL1},$P{SUBREPORT_DIR})]]></subreportExpression></subreport> subReport <subreport> <reportElement x="50" y="10" width="457" height="40" uuid="4528914e-bb9a-4300-8173-14be2ff2db85"/> <subreportParameter name="REPORT_CONNECTION"> <subreportParameterExpression><![CDATA[$P{REPORT_CONNECTION}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="REPORT_DATA_SOURCE"> <subreportParameterExpression><![CDATA[$P{REPORT_DATA_SOURCE}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="SUBREPORT_DIR"> <subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="SUBREPORT1LEVEL2"> <subreportParameterExpression><![CDATA[$P{SUBREPORT1LEVEL2}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA[iF($P{SUBREPORT_DIR}==null,$P{SUBREPORT1LEVEL2},$P{SUBREPORT_DIR})]]></subreportExpression> </subreport> java code parameters.put("SUBREPORT1LEVEL1", inputStream1); (For subReport) parameters.put("SUBREPORT1LEVEL2", inputStream2); (For subSubReport) Didn't find necessary to post the rest of the Java code 'cause I know it works how it's supposed to. The three reports compile perfectly in the designer (each one separated) generating the .jasper file correctly. So, my questions being said: What am I doing wrong?How am I supposed to pass the parameters to define the report path for a subSubReport?Does the parameter need to be passed to the mainReport as I do when I have a subReport? In conclusions, I want to be able to asign the correct InputStream to each subReport/subSubReport, which one is the better (and known) way to do it? PS: As you may know by now (considering the length of my question) I'm in a dead end here, so any, ANY help will be REALLY appreciated. Thanks a lot!

Hi @hozawa, Thanks for your answer! I know there is an explantaion behind the subreports feature working this way (reusability and all) but in my case I don't need the subreports to be reusable, so I'm trying to avoid getting my app "dirt" with all those unnecessary .jasper files. So far I've found the following threads where they say it is actually possible to achieve this, but my question is, how to? http://community.jaspersoft.com/questions/514525/jasper-report-and-subreports-single-file http://stackoverflow.com/questions/929290/directly-embedded-subreport-in-jasperreports I tried to do some of the explained here, but without success... Since you said it is not feasible, I'm guessing you won't know how to do it, but I think this is an interesting feature that many would be glad to use and more than that, I'm sure someone had to do it in the past. If not, I'd like to get a solution for the community's sake ;) Let's see if we can (with some help) get to a solution. Greetings!

Hi community! My doubt is based on the necessity of uploading all the .jasper files to my application report's folder when my report have several subreports (using the $P{SUBREPORT_DIR} parameter passed to my main report from java code). Since now, I just has found this option when googling for an answer to it, but I'm guessing, since I have the xml code, I can "embbed" the code of my subreport inside the main report's xml code. Is it possible? If so, how can I achieve it? It's important to have into consideration that I also have several parameters passed from my main report to my subreports. Thanks!

Did you find any solution for your problem? I'm facing the same issue running my report with subreport from my web app. I tried to pass the location of the subreport in my app to the main report as a parameter ("SUBREPORT_DIR", "mySubreportLocation.jasper"), but it didn't work. Any help will be appreciated!

Hi community! I have a (simple) working report in Crytal reports that I want to migrate to Jasper and my question comes when I need to call a function defined in a package from my Oracle DDBB. My query looks like the following: SELECT table.field1 as field1, table.field2 as field2, sp_name.function_name(some parameters) as field3 FROM myTable table WHERE ... I've been googling a lot but everything leads me to dead ends. I tried the following: SELECT table.field1 as field1, table.field2 as filed2, {call sp_name.function_name(some parameters)} as field3 FROM myTable table WHERE ... ...but I've got errors when trying to read the fields (Read Fields button). This is taking me a lot of time and I'm almost giving up... Since I did it in crystal and it was such a simple task I can't imagine it takes this much to do it in Jasper. Can anybody please clarify to me how can I achieve this? What exactly am I missing? Big thanks!

Changed Status from Resolved to New Hi I'm trying to convert from Crystal reports (.rpt) to Jasper, and I have the same doubts as you. Did you finally find a way to accomplish it?

Hello there! I'd like to know if JasperSoft Studio can be integrated/embeded in a web app as another feature. Basically, what I want to do is to be able to create reports dynamically from my running web application. It is developed in Eclipse and running with Jboss 6. I know this subject has been treated before in the community but it seems like nobody knows for sure whether or not it can be done. I will appreciate any help. Thanks in advance! Update: Is important to remark I'm a newbie in Jasper and I really don't know which tool/product is necessary to accomplish my goal, JasperReports Library, Jaspersoft Studio or other?

HHi there! I know the question was made over a year ago but I have to try it. I'm facing the same issue than you now since I want to change the reporting tool I've been using in my web app (developed in Eclipse). I've been using Crystal Reports but since the version I have is quite old and of course outdated I'd like to take advantage of the needed change and make the creation of reports possible in my web app. Could you find a solution to the question at the end? Thanks!