[error]

This post was submitted by mistake

[Passing parameters automatically to a report]

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.

[error]

 

 

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

[Passing a parameter in IN clause of SQL]

You can also use:

 

select ... where $X{IN, colname, parameter name}

 

"parameter name" is a parameter of type Collection or array.

 

[iReports Database connection password.]

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.

[Fields option]

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.

[Passing a parameter in IN clause of SQL]

Try using $P!{parameter name} instead of just $P{parameter name}.

[Displaying textField when not null]

You may also use the Print When Expression for your text field.

[Nullpointer when reading fields from query (3.5.2)]

Can you run the same query against the DBMS (Copy to Clipboard and paste into a query tool)? What DBMS is it?

[About multiple conditional expressions...]

No. ".doubleValue" is of type "double" (lower case d). "Double" (upper case D) is a different data type.

[Dynamic Query]

To give you an example...

SELECT a,b,c FROM table1 WHERE a < $P{YourParameter}

[how to unite fields (in detail)?]

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.

[IF statment: java.lang.Integer]

$F{CostNeutral}.equals( new Integer(1) ) ? new Integer(0) : $V{persondays}

[opening ireport from command prompt]

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"

 

[Conditional / fixed fields]

Try

(category == "Frozen Goods" || category == "Snacks")?(amount):0

[writing section of code eg crystal style]

Yes, you would have to use scriplets. Can't do in the expression.

[Complex SQL statements with parameters]

Have you tried where t3.y = $P!{xxx} ?

(note the exclamation point)

[Close connection in ireports]

Try a DBMS that's more robust... like Ingres ;). ingres.com

[VALUE FOR PARAMETERS]

You need to select java.util.Date for the class type and something like new Date("12/12/2007") for the default value expression

[query based on query]

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.

[help needed urgently]

We've created reports that are close to the waterfall format by using multiple subreports.