[building a Chart with an Array]

So far, I found no way of making a chart out of an array. My guess is that's not something possible - didn't find a single reference on line for it.

[building a Chart with an Array]

Here is something I'm trying right now. I think it is possible that the first time the chart attempt to access my array it is undefined and hence I get the error. I'm thinking the syntax below would give the right value as the chart gets created. In "Category Expession" I'm trying now:

$V{likesDiff}.length >0 ? $V{likesDiff}[likesDiff.length]:0

So far the error is

Error filling print... Error evaluating expression :      Source text : $V{likesDiff}.length >0 ? $V{likesDiff}[likesDiff.length]:0

I'm still hoping to make a chart out of an array.

 

 

 

[building a Chart with an Array]

Hi all,
I have an array that gets populated in a Scriptlet. I assign the scriptlet's output to a variable in my iReport.
I had tested the variable/Scriptlet output with both types Long[] and List. I'm getting very similar results:
the array gets populated, I can see it grow in "Detail" band, then I can view the content of it in the "Summary" band.

The problem comes when I attempt to set it as a "Category Expresion" in one of iReport charts.
When the array in a Long[], the error is:
Error filling print... [Ljava.lang.Long; cannot be cast to java.lang.Comparable

When the array in a String[], the error is:

Error filling print... [Ljava.lang.String; cannot be cast to java.lang.Comparable

When the array is a List, the error is:  
Error filling print... java.util.ArrayList cannot be cast to java.lang.Comparable

Class Long & String do implement Comparable. Am I missing a cast? not sure how to pipe the content of an array into an iReport chart. Any clues anyone?

Post Edited by liw at 08/20/2012 21:53

[variable in Title band]

Hi all,

I know that Title band is for Static values, but I wonder if there is a way to add a variable into the Title band with its value set in a scriptlet.

Any help is much appreciated.

[how to store & compile scriptlet inside iReport]

The best step-by-step example so far for creating and running scriptlets is at:

http://www.opus-college.net/devcorner/iReport-Ultimate-Guide-3.pdf

Chapter 15 in the pdf file.

[how to store & compile scriptlet inside iReport]

Hi all,

I have a small test scriptlet with one method returning a string. I'm not sure how to store the scriptlet in the report or build it.

Here is what I have in the scriptlet:

import net.sf.jasperreports.engine.JRDefaultScriptlet;
import net.sf.jasperreports.engine.JRScriptletException;
public class TestScriptlet extends JRDefaultScriptlet {
     public String testDescription() throws JRScriptletException
     {
         return "Hi there!";
     }
}

 

When I build the scriptlet from a command prompt, I get errors for import statements in the scriptlet:

TestScriptlet.java:2: error: package net.sf.jasperreports.engine does not exist
import net.sf.jasperreports.engine.JRDefaultScriptlet;
                                  ^
TestScriptlet.java:3: error: package net.sf.jasperreports.engine does not exist
import net.sf.jasperreports.engine.JRScriptletException;
                                  ^
TestScriptlet.java:5: error: cannot find symbol
public class TestScriptlet extends JRDefaultScriptlet {
                                   ^
  symbol: class JRDefaultScriptlet
TestScriptlet.java:6: error: cannot find symbol
 public String testDescription() throws JRScriptletException
                                        ^
  symbol:   class JRScriptletException
  location: class TestScriptlet
4 errors
 

If anyone has some experience with this, your help will be much appreciated!

Post Edited by liw at 08/14/2012 16:48

[simple concatination routine for a field]

Syntax for splitting the string into a String array:

 

$V{my_var_str}.split(",")

[simple concatination routine for a field]

Here is what I discovered works for concatenating a field to a string:

 

$V{my_var_str}+$F{my_field}+','

 

Strange syntax, but does work.

 

 

[simple concatination routine for a field]

Hi all, I'm attempting to do this simple concatination routine in the iReport that results in errors on build. In "Variable Experssion" I have this: 

$V{likesStr}+=$F{likes}+","

Basically, I want to build a coma separated string of field $F{likes}, then later create an array out of it. I tried criating an array on the fly, directly, but couldn't get it populated correctly, the array was retaining only the very last value out of a set of values. I'm hoping to get my array out of the string I'm attaempting to build. 

The compiler error is: '(java.lang.String) variable_likesStr.getValue()', is a bad expression as the left hand side of an assignment operator

Any deailed suggestions will be much appreciated.

 

 

[creating a list based on calculated values from the Detail]

I changed Variable Expression from $V{ls}.add( $F{myfield} )

to $F{myfield}

 

So now, the array gets populated, but only with one value out many in the column. Does anybody have an idea how I could populate my array with every value of a specific field?

 

[creating a list based on calculated values from the Detail]

Ok, thank you, I was able to set it to be an array.
Now when I have it set in Variable Expression to this:
$V{ls}.add( $F{myfield} )
I get no errors, but ls is a null when tested in the page summery. I tested Calculation set to Nothing and System, but the array is empty. I even dragged it into the page Detail, still a null.

Post Edited by liw at 08/10/2012 21:21

[creating a list based on calculated values from the Detail]

Hi cmatthews,

In the dropdown for "Variable Class" I see options  java.lang.Integer,  java.lang.String, java.util.List. I have the newest iReport version installed. Where would I set java.lang.Integer to be java.lang.Integer[]?

When I had a variable declared as  java.util.List ls, then setting var Expression to ls.add($F{myNumField}), I'd get an error on attempt to "Preview" the report - ls.add function was not allowed. It seems like a simple thing, but...

[creating a list based on calculated values from the Detail]

Hi all, I wonder if its possible to do the following with the records comming from a sql query:

say I have a report that has numerical values:

count 1:   300

count 2:    289

count 3:    256

count 4:   220

Is it possible to create a variable, an numeric Array that would contain the difference between the numbers? - like that:

Integer[] arr = new Integer[  300-289,  289-256, 256-220]

I can imagine this is a variable with execution time "Now", but can it be an array? and if so, how would I set up such a variable?

Big thanks in advance!

 

 

 

[Pass a database value from report to subreport]

Hi fabioparoni,

When you have that parameter set properly, you wont be asked to input it while running the main report. That popup only occurs when you run a subreport separetely. My guess is that you created that parameter in the main report, but it should be only created in the subreport, on far left top. In main report, when you select subreport icon, in far right properties area, at the very bottom, you need to also add that parameter to the "Parameters" property.

I hope this helps.  You should compare what you have to the iReport "Subreports" example.

Post Edited by liw at 08/03/2012 17:54

[using style for a frame]

Here are steps that I took to make the style on the frame to work:

For Style: 1) add a style (left panel); 2) add condition to the style 3) add a frame to "Detail" 4) add the style to the frame
via dropdown. 5) set the frame to "Opaque".
If the style still doesn't look right, edit it in XML view.

[Pass a database value from report to subreport]

Do you know how to make a subreport? Lets say you do. In this case you'd end up with 2 sql statements. Just an example:

In main report: SELECT distinct name FROM account order by name                  

Then in subreport: SELECT id, division FROM user_account where company_name = $P{company_name}      

If you need more specifics you want to check out the sample called "Subreports" in Help/Samples Directory. But here are few basic steps:

1) Add subreport icon into the main report. 2) Choose new report.
3) Put in sql, avoid first time around things like "where fieldName=$p{paramName}" This will need to be set later.
4) once report exists, create the param, add "where fieldName=$p{paramName}" . Test teh sql with a string expession.
5) Build subreport, build report. 6) If subreport doesn't show up, make sure that subreport expression contains only report name.

 

[using style for a frame]

Hi all,

I'm working with the iReport example "Subreports". Its subreport uses a frame with a style set to style1. The notes for the subreport point out that the style is used on the frame, but say nothing about how to get/set that style. If I simple copy their fame or type "style1" into style setting, I get the same error:

Error filling print... Could not resolve style(s): style1
net.sf.jasperreports.engine.JRRuntimeException: Could not resolve style(s): style1

Does anybody know how that works? Thanks in advance!

 

 

 

[creating a new subreport for the first time]

 

 

Post Edited by liw at 08/01/2012 22:58

[creating a new subreport for the first time]

Hi all, I'm attempting to create a subreport, just as a test to see how it works. Here is what I have:

In my main report the sql is:

SELECT distinct name FROM account order by name.

Then I add the "subreport" icon into the main report.

My subreport sql is:

SELECT id, division FROM account where name = $P{name}

I build both reports and run the main one. For some reason I only see main report data, nothing from sub report. Am'I missing something trivial here?

 

 Found it - had to edit Connection Expression

 

 

Post Edited by liw at 08/01/2012 23:01

Post Edited by liw at 08/01/2012 23:02

Post Edited by liw at 08/01/2012 23:47

[grouping var]

Found it, nevermind.

[grouping var]

Hello,

I have a variable defined for grouping, used in the group heather. I need to have its "Evaluation Time" to be set to "Now"  to get the right data. But when its set to "Now", the first time the var is printed, the var is null. Is there a way to set it to a difault? Thanks a lot.

[example Parameters and Variables]

I got it, This is a user defined parameter. I see how it gets added into a page.

[example Parameters and Variables]

Hi all, I downloaded iReport last Friday and looking through example Parameters and Variables. When I run the report, report  is created with the country set as Italy, but the sql for if doesn't spacify "Italy" anywhere. Instead, it has the following:

select * from orders where shipcountry like $P{Country}

 

I'm not not seeing where $P{Country} is set as Italy. Any ideas anybody?

[ireport: how to run demos]

I see - just had to open them!

[ireport: how to run demos]

Hi all,

I just installed iReport and while exploaring directories, I found a set of samples in directory \Jaspersoft\iReport-4.6.0\ireport\samples. I'm assuming thsese are examples of few sample reports. I'm hoping I can run them from NetBeans IDE. Does anybody know how to run them/ how to get to them in NetBeans IDE?

 

Thanks a lot!