zmanning

To pass all parameters you can just pass $P{REPORT_PARAMETERS_MAP} to your subreport. The meaning of exclaimation points in parameters is to pass them into sql without adding quotes around them. For example, I used this some time ago when I needed to pass in a dynamic table name: select * from `$P!{prefix}_table`.

Hey All, I was wondering how I can get rid of blank pages when a detail field has to stretch with overflow. I have 'Split Allowed' unchecked and I have 'Print when detail overflows' checked for all my detail fields. This isnt a no data situation its just when there is a long comment that is being displayed. Thanks, Zack

Hey I know this is an old post but for anyone else looking to do this, use a chart customizer w/: Code: CategoryPlot plot = chart.getCategoryPlot(); cata.setMaximumCategoryLabelWidthRatio(2f); or Code:[code] CategoryPlot plot = chart.getCategoryPlot(); cata.setMaximumCategoryLabelLines(2); Hope this helps someone.

Found a solution and thought I should share it if anyone else is trying to do the same thing. I just created variables to calculate the number of data points for each possible series at chart generation time and grabbed them with JRAbstractChartCustomizer. I then colored the series if they were present. Code: Integer det = (Integer) this.getVariableValue("det_count"«»); Integer pass = (Integer) this.getVariableValue("pass_count"«»); Integer prom = (Integer) this.getVariableValue("prom_count"«»); int series_index = 0; if(prom.intValue() != 0) { renderer.setSeriesPaint(series_index, new Color(94, 171, 94));//green series_index++; } if(pass.intValue() != 0) { renderer.setSeriesPaint(series_index, new Color(255, 210, 64));//yellow series_index++; } if(det.intValue() != 0) { renderer.setSeriesPaint(series_index, new Color(255, 66, 66));//red series_index++; }

Hi All, I am using a customizer class to color a couple bars in a stacked bar chart. Its a situation where a certain series may be present or not. Now with setSeriesPaint(int), I can only color the series by number which mixes up my colors if for instance the first series is not present. Is there any way I can color bars based on their series name? Thanks in advance, Zack

I don't think you can do that because you need to compile the JRXML before you fill it. If you were compiling and running the report through a java app outside of iReport you would use code like: Code: JasperDesign jd = new JasperDesign(); jd = JRXmlLoader.load(jrxml_filename); jd.setColumnCount(6); Then you compile the JRXML and fill it.

Code:public class FirstCustomizer implements JRChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { BarRenderer renderer = (BarRenderer) chart.getCategoryPlot() .getRenderer(); CategoryPlot plot = chart.getCategoryPlot(); CategoryAxis cata = plot.getDomainAxis(); The code above should be a good starting point. Specify the full name of this class as the customizer class.

If you are using something like eclipse, the java will always compile automatically. Create a new class in whatever package you want. Export the package to a jar into any java lib directory (ie ireport lib directory or jre ext directory). When Jasper looks for the customizer class, it should find it in the lib you exported.

Ah of course. I just switched the order by's around and all worked well. Hopefully this will be help anyone else with this problem.

I have searched around for an answer to this but cant seem to find one. I am bringing data into a crosstab from a subdataset already being presorted. I am getting the data coming through alright but the rows are being duplicated. I am not sure how to explain so I attached an image. It is cut off at the bottom but you can imagine the rest of the columns exactly as above. Any ideas would be most appreciated! Thanks, Zack size=183]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/CrosstabProblem.JPG Post edited by: zmanning, at: 2007/07/30 22:52

When trying to preview reports JRViewer freezes all of iReport. I have been using JR and iReport for a year or so with no problem. Fails on any template. Tried uninstalling and reinstalling for Win. I dont know what the error message is because the freeze looks like this: http://img404.imageshack.us/img404/3112/jrviewererrorvf9.th.jpg Any help would be very much appreciated. Thanks, Zack Post edited by: zmanning, at: 2007/07/12 16:37

I have posted this question on the JFreeCharts forum also with no luck. All I am looking to do is align bars in a chart to the right. By default they are aligned middle. Is there a way to do this through JR? I am using a customizer class for styling. I am also doing design with iReport. Jfree version is 1.0.5 and JR version is 1.3.3. Any help would greatly appreciated. I will be able to respond realtime all today if anyone responds. Post edited by: zmanning, at: 2007/07/11 20:50

Yea I am getting the same error. It only happens when I export multiple reports. One report is using a scriptlet and the other is not. JRException is Incompatible net.sf.jasperreports.engine.JRDefaultScriptlet value assigned to parameter REPORT_SCRIPTLET I have been trying to troubleshoot this for a while with no luck. Any help would be excellent. Im using JR 1.3.0.

Little tip, dont demand a solution to your problems. Especially with free software like JR. Look at value axis label mask.

Little tip, dont demand a solution to your problems. Especially with free software like JR. Look at value axis label mask.