hunta007

Thank you for this post. I am trying to use the return value of the subreport variable in a filter expression in my main report (or even in the subreport) but can't seem to get any Groovy expressions to acknowledge the integer value of the variable as an integer. Is there something special about the return value that needs to be taken into consideration? Thank you.

Hello. I am trying to get a report to run that uses a report group (GROUP_1), the Group Expression for which is an input parameter named $P{GROUP_1}. The effort here is to get iReport to accept user input in defining the report group. By way of example, I have the following for the report query select * from table_one where $P{GROUP_1}=$P{GROUP_1_VALUE) This, so the user can provide both the field_name via $P_GROUP_1 and the filtering value via $P{GROUP_1_VALUE} while also providing the value that will provide for grouping within the report via $P{GROUP_1}. Has anyone tried/accomplished this or does anyone know if this is supported? Thank you.

Thanks again for your help iknueve. Post Edited by hunta007 at 10/05/2011 18:14 Post Edited by hunta007 at 10/05/2011 18:16

Also, it only works if the text field evaluation time is set to Auto. Report renders zero values.

When I remove the spaces from between the last four values of the expression, it works. thank you. The report language is Groovy... why would the spaces initiate that error?

Hi and thank you for your response. When I do this, I am getting an error that the variable expression is not compatible with the variable's class... the class is set to java.lang.integer.

I am trying to constrain a count of a variable in a group header; e.g. instead of getting the count of all employees in the department group, I want to apply a constraint to have that variable count be only for Female employees. I have a variable that is a count calculation created to group by the department. I assumed it would be as simple as setting the variable expression to $F{gender} == "F", but that doesn't seem to work to constrain the count. Please and thank you for any assistance. Post Edited by hunta007 at 10/04/2011 20:29

Has anyone been using WidgetsPro with iReport 4.0.1 extensively? I have looked through "getting-started-flash-charting.pdf" and the index.html referenced therein. The latter appears to be for version 3.7 of iReport. Is there a more current reference document for working with widgetsPro... or a good source as a reference? I am working with the funnel widget and am getting varying/unexpected results when I change settings. I am hoping that documentation or a source of discussion might lend some insight. Please and thank you. Post Edited by hunta007 at 09/26/2011 15:05

Hello Forum. I am developing a check/cheque report via iReport 4.0.1 and need to have the check amount patterned to be the textual rendition of the currency amount; e.g. $799.52 as "Seven Hundred Ninety Nine Dollars and 52 Cents". Has anyone done this before and, if so, was it done via a custom pattern or via a variable/field using Groovy/Java? Thank you.

Hi. I am new to the forum and have been working with Jaspersoft's BI Suite for a couple of months now... this for evaluation. Can someone please provide a good source for iReport templates. Right now, I am interested to see if anyone has a template for checks (i.e. the negotiable instrument type). Also, if anyone has had experience with developing similar reports that require meticulous format/layount; i.e. if your experience has been positive or negative. Thank you.