[user input params]

I have several parameters that I set as checked for prompt when I created them. I also set defaults for each of them. For some reason, when I run the report, the values used by the report are not the prompt values, but the default.

Could anyone please tell me what has to happen in order to have prompt values in the report?

Thanks in advance.

[operator +=]

Thanks a lot! Worked like a charm!

[operator +=]

I'm attempting with no success to use operator += in expression $V{totNom}+= $F{NOMGEQ}.

The error is "The left-hand side of an assignment must be a variable"

pointing to $V{totNom}

 

totNom is a variable. Could anyone please tell me how to get this operator to function? ... I'm computing here a sum of the field NOMGEQ.

[SubReport]

I did all element positioning in the actual subreport. I don't think you can access element properties for subreports without writing code.

[Preventing group splitting; combining reports]

Jerry, try putting your subreports into pageHeader.

For some reason pageHeader appears to be the only place in order to avoid repetition of data. I had to make my subreports fit individually onto one page before I combined them. But here is one other problem: what if the reports need 2 separate pages? I don't know if there is a way to tell iReport to use a separate page for specific iReports...

[format phone numbers]

Very nice! Thanks a lot!

[separate result sets in one iReport]

I'm looking for a way to combine independent SELECT statement results on one iReport page. Does anyone know if this is possible? If so, how?

I was trying to simply add a subreport, but after compiling I can't get the data to show up from both reports at once.

[format phone numbers]

Hello,

Does anybody know how to format phone numbers in iReport? ... The phone numbers I'm attempting to format at this point have the following format:1112223333

I'd like to have as(111)222-3333

Thank in advance.

[sum of fields]

I got it to work - just had to use "groovy" as language.

Here is the link to one of the JasperForge pages (THIS IS SO EASY!!!)

http://www.jasperforge.org/index.php?option=com_content&task=view&id=61&Itemid=204

[sum of fields]

When I go Report Groups/New, I don't see where I could say what fields to add into a group...

When I select and left click the elements that need to be summed, I see there is a "group elements" option. But nothing happens when I click on it...

[make subtitles]

Ok, I got it to work - just had to move the element into a separate header.

[make subtitles]

Could anyone tell me if there is a way to do something like this:

I have a query "select active, title from mytable order by active,title".

Field Active is 0 or 1.

I want to have a subtitle "Inactive" and "Active" in the detail area of iReport and have record under these subtitles.

I made an element with Expression " (new String("1")).equals( new String($F{ACTIVE}) )? "Active Product" : "Inactive Product")"

The element, when in detail area of iReport, shows up per record. When the element in title, it shows up only when it's a new page - maybe there is a way to move records that are inactive into a different page?.

I'd appreciate any help here!

[format numbers]

Got it! Thanks!

[sum of fields]

Hello,

I'm attempting, without any success, to make sums for some of my data. I know this is a basic report function and assume iReport has something for it. Could anyone please post a "how to"?

[check for null]

Thanks a lot. I saw the "Set to null" option few hours after I made a post.

[check for null]

I'd like not to display nulls in my iReport. I have the following at the moment but it doesn't work:

(if($F{BEGCYC6} != null) $F{BEGCYC6})

 

Is it possible to check for nulls several fields at once so that I wouldn't rewrite the same line of code for every output?

[format numbers]

Is it possible to format numbers in iReports? I have several database fields set as floating numbers but the reports need to show integers.

:S