iancr01

This post was submitted by mistake

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&param1=myFirstParam&param2=mySecondParam Any other alternatives would also be accepted.

Post Edited by iancr01 at 11/03/2011 21:28

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.

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