niels.cadee

Hi, I finally got the solution from JasperSoft Support. Part of the problem was that my meauseres are integers, and the average includes decimals. There are two ways to solve the problem: 1. In the Ad Hoc chart interface, right-click on the measure name above the chart and select Change Data format. Then choose a format that displays decimals: -1234.56. 2. In the domain designer, on the Display tab, edit the measure properties. For Summary Format, choose Average. This also fixes the axis problem.

Thanks ever so much for your time Jerry! I'll try this and also the suggestion I got from Jaspersoft Support: Use Parameter Class java.util.Collection and just leave the Default Parameter Value empty. It seems to work, I'm on the right track now!

Hi, I'm using iReport 4.5.0 Community Edition with language set to Groovy and have trouble defining a parameter. The basic thing is that I want to build a default option 'All values' into a parameter and cannot find a way to do it. I have a field HospitalType with values 1 (Central), 2 (Region) and 3 (Local) and some missing values. I want to have a parameter with the options Central, Region, Local and a default value All that includes all three levels. In the last case I'm asking for a range of values and that's where the problem begins. I tried using some tips I found on technical blogs and here but I'm not getting any further. In my Report SQL query I included WHERE $X{IN, HospitalType, TypeParameter} For my parameter TypeParameter I tried Parameter Class: java.util.List and Default Value Expression: java.util.Arrays.asList(NULL,1,2,3) but then I get an error when reading the fields in the Report query: Error in method invocation: Static method asList(null,int,int,int) not found in class 'java.util.Arrays' Is this the right way to do it, where is the problem? Many thanks in advance for any help and suggestions.

Hi, I'm using JasperServer Pro version 4.5.0 and have a problem creating Ad Hoc reports. Every time I create a graph of a field (e.g. civil status, single/married/partnership) against a measure (e.g. number of days in hospital), I get a strange display of values on the Y axis. With Sum, Min, Max, Count it works fine, but with Average I get repeated vales: 0 0 0 1 1 1 2 2 2 3 along the ticks on the axis. Any ideas why this happens and what can be done about it? Many thanks in advance for your help and suggestions!