scotthendoau

Howdy, Well in my case, I have an ear file deployed to a web server. Now say my project is called example, my files are saved in example/jasper. So I set the SUBREPORT_DIR to "jasper". Also make sure that your subreport and main report are both in the same directory. Scott.

Thats ok guys, have solved the problem. Rather than setting up the year as a parameter in the main report and then sending that to the sub report, add the year as a parameter by right clicking on the sub report and adding it there.

Hey guys I have been trying to pass a field to a sub report but am having troubles. Given the SQL: SELECT extract(year from request_time) as time I want to pass the time field to a sub-report so that i can generate a report just based on that year. Now I have tried using a parameter and setting the parameter to the field using the default value expression but this gives an error. Does anyone know how I can implement this? Thanks in advance, Scott

Thanks for your reply svenn I have figured it out. For some reason, when deployed locally, setting the SUBREPORT_DIR to "\" works fine but when deployed to a Unix box, i have to set the SUBREPORT_DIR to the folder that both reports are in but not the full directory path, ie. I set SUBREPORT_DIR to "jasper". Go figure. Cheers, Scott

Hi guys. I am using sub reports for the first time. Now when I run the reports locally everything works fine, yet when I deploy my ear to a Unix based server, i get the following exception: net.sf.jasperreports.engine.JRException: Could not load object from location. The main report and sub-reports are in the same folder. I have been using the sub-report dir parameter with just about every combination under the sun ("//", "/", "", "\", "." and "") but nothing is working. Can anyone help me? Thanks in advance for any help. Regards Scott.

Hi guys, I am wondering if this is possible. I have a report that displays a set of data aggregated by year. Now I want to be able to click on a year and then this brings up a report that has all the data aggregated by month. heres a screenshot of what I currently have: size=150]http://i270.photobucket.com/albums/jj81/scotthendoau/orgscreeny.jpg Now obviously I cant just create a sub report as I would have to have a sub report for every single year. Can anyone offer a suggestion?

Hi guys, I am wondering if this is possible. I have a report that displays a set of data aggregated by year. Now I want to be able to click on a year and then this brings up a report that has all the data aggregated by month. heres a screenshot of what I currently have: size=150]http://i270.photobucket.com/albums/jj81/scotthendoau/orgscreeny.jpg Now obviously I cant just create a sub report as I would have to have a sub report for every single year. Can anyone offer a suggestion?

Hi guys, I am wondering if this is possible. I have a report that displays a set of data aggregated by year. Now I want to be able to click on a year and then this brings up a report that has all the data aggregated by month. heres a screenshot of what I currently have: size=150]http://i270.photobucket.com/albums/jj81/scotthendoau/orgscreeny.jpg Now obviously I cant just create a sub report as I would have to have a sub report for every single year. Can anyone offer a suggestion?

Move the chart into the lastPageFooter band. Probably not the best way around the problem but it will work.

Hey guys I have the following query: Code: That produces: size=381]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/reportA-b37c8e30985eff8fc29b048bc9a101e7.JPGhttp://i270.photobucket.com/albums/jj81/scotthendoau/reportA.jpg Now obviously I only want to print hits/org once per organisation (I need to get rid of all but the first value of '8' next to "Spatial Information Infrastructure". If I de-select the option "Print repeat values" I get: ]http://i270.photobucket.com/albums/jj81/scotthendoau/reportB.jpg So after diving a little further I determined that it will only print a value once in that yearly block. So I headed to my group by section of my query but no matter what I change hear it seems to have little effect. Can someone please suggest what I can do. Thanks in advance. Scott. P.S. Sorry for the poor screen shot quality. size=150] Post edited by: scotthendoau, at: 2008/02/13 22:09

Ignore Post edited by: scotthendoau, at: 2008/02/13 22:06