iancr01
-
Posts
21 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by iancr01
-
I'm trying to find a way to pass parameters to a report from another application (like a web page). An example would be using the POST/GET methods... e.g.: http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2FMyFolder&reportUnit=%2FMyFolder%2FReportName¶m1=myFirstParam¶m2=mySecondParam Any other alternatives would also be accepted.
-
You can also use: select ... where $X{IN, colname, parameter name} "parameter name" is a parameter of type Collection or array.
-
That is the database user name and password. You shoud check with the DBA to see what user and password you should have access to. If you created the database, there must have been some values that you were asked to enter at a certain time during the install process.
-
You need to define a style and add a conditional style.. something like: new Boolean($V{REPORT_COUNT}.intValue() % 2 == 0) (make the color light blue for example) Then you need to apply the style to the field(s) you need to alternate the color for.
-
Try using $P!{parameter name} instead of just $P{parameter name}.
-
You may also use the Print When Expression for your text field.
-
Nullpointer when reading fields from query (3.5.2)
iancr01 replied to luciano_castro's topic in Products
Can you run the same query against the DBMS (Copy to Clipboard and paste into a query tool)? What DBMS is it? -
No. ".doubleValue" is of type "double" (lower case d). "Double" (upper case D) is a different data type.
-
To give you an example... SELECT a,b,c FROM table1 WHERE a < $P{YourParameter}
-
The detail band will always show one line(field or group of fields) per record. Do you want to show the group header for every record? If not, you should use report groups and group header bands instead of detail.
-
$F{CostNeutral}.equals( new Integer(1) ) ? new Integer(0) : $V{persondays}
-
On Windows, guessing that this is iReport 3.x, the .jrxml type should be associated with iReport, so you should just be able to run "absolutepath to report file"
-
Try (category == "Frozen Goods" || category == "Snacks")?(amount):0
-
Yes, you would have to use scriplets. Can't do in the expression.
-
Have you tried where t3.y = $P!{xxx} ? (note the exclamation point)
-
Try a DBMS that's more robust... like Ingres ;). ingres.com
-
You need to select java.util.Date for the class type and something like new Date("12/12/2007") for the default value expression
-
You may want to create an input control for your report and make it of type Single-Select Query or Multi-Select Query. That report will take as parameters the results of the query in the input control.
-
We've created reports that are close to the waterfall format by using multiple subreports.
