[Using semi colon on SQL Query]

the report query can only execute one sql query, you are sending 2 commands. You might need to use a stored procedure instead. refer the JasperReports documentation for limitations on stored procedures.

[Displaying an String Output]

you could do that with a tertiary operation as field expression. Create a text field having this as expression:
 

( field_4 < 80 ? "Has Issues":  ( field_4 < 85 ? "Improvement required" :   ( field_4 < 90 ? "Meets Expertations" :   ( field_4 < 95 ? "Exceeds Expertaions" : ""   )  ) ))

[HTTP api decorate=no calendar not working]

you might want to have a look at the file /WEB-INF/decorators/decorator.jsp to understand the impact of the parameter decorate=no.

[Updating saved adhoc report]

Not as far as I know. As soon as you save the report a copy of the topic is stored as report resource. this prevents the report from being broken caused by future changes of the topic. The query is directly related to the contained topic - not a copy of the topic's SQL.

[roll up subtotals inline in recursive sub-report]

have you looked at variables and sub report return parameters?

[Using stored Images in detail of report]

Could you pls provide more details such as where the images are stored (a database?) and what exception you are getting?

[Where is the 4359 bug fix ???????]

as the issue get closed end of last year i would assume it was released with JasperReports 3.7

[Count value for a particular column - Grouped]

For each group a variable <group name>_COUNT is generated which contains the number of rows in the group.

[retrieve jrxml file]

iReport allows to access reports remotely. Click on Window > JasperServer repository to open the panel. Create a new server entry and navigate there to your report. I would recommend this way.

 

Another way would be using the import/export tools to export the report using the --uris parameter. refer the JasperServer administration guide for more details.

 

[How to retrieve property in jrxml?]

You can't hide bands from the exporter using the printWhenExpression. You would need to configure the exporter settings.

More help provides the JasperReports Configuration Reference, look for the property net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name}

[ireport's update site for eclipse ganymede 3.4.2]

what exactly are you looking for? iReport is built on the netbeans platform.

[Couple of doubts]

1) yes. You could simply use the title band or a fake group header. You could also set the printWhenExpression for the pageHeader band to

($V{REPORT_COUNT} == 0)

2) I am not entirely sure if I understand what you want to achieve here.

[Is there Auto Height Property for Report Elemen]

please refer the jasperreports stretch sample which is available in the demo folder.

the desired property is a text field property:

isStretchWithOverflow="true"

[Print if...]

just write a simple expression

("%".equals($P{Company})? "All Companies" : $P{Company})

 

assuming that your parameter is called Company. Be aware that report elements are case sensitive.

[Different page headers]

You could set the printWhenExpression for the pageHeader or certain elements in it. If the variable PAGE_COUNT contains 0, you are on the first page, otherwise on other pages.

Post Edited by mrcaffeine at 22/02/2010 10:15 PM

Post Edited by mrcaffeine at 23/02/2010 08:43 AM

[Single Select Query with parameters]

The Parameter and the input control need to have the same name: in this case it seems to be 'client'.

 

I am not entirely sure if you need the locale paremeter as the JRXML has a parameter REPORT_LOCALE which is filled by the environment, such as iReport or JasperServer.

 

the syntax using the ! is only if you are injecting code into the report query.

 

please share the querystring, parameter definition and details about the input control.

[Single Select Query with parameters]

Hi Simon

 

the name of the single select query input control must be equal to the parameter name.

 

I assume that the name of the input control is different to test. Be aware that uppercase / lowercase matters.

[iRepBar Chart: How to choose colour for each serie]

can't you just set a style for the text field? Or if you don't want to use styles just change the properties for the text field such as foreground and background color?

[how to transfer variable between jobs.]

Hey Kevin

 

i have to play around a bit.

 

for now as work around you could just simply put the variables into a file (tfileinput, tfileoutput) you are going to read in any job you need. it might be a bit overweighted but should do the job.

 

you could also ask at http://www.talendforge.org if somebody has another idea.

 

if i find anything better i will let you know.

 

cheers

Kerstin

 

[Change background color reportelement]

You might want to use a conditional style instead.

 

The style contains a name and for each condition and the corresponding color settings. The text itself gets the style applied.

 

not sure if this will help for your requirement.

[how to transfer variable between jobs.]

I haven't tried it out myself, there is a tSetGlobalVar component you might want to use.

[Dyanmic Positioning of report textfields/elements]

Have you tried to use the printWhenExpression to hide the element?

Also you could set the RemoveLineWhenBlank and RelativeToHighestObject properties on a report element.

[Chart Y axis min max limits]

You would need to write a chart customizer to do so. This is a simple piece of java code, examples are available in the jasperreports demos.

[Distinguish the output format in jrxml]

AFAIK you would need to customize the exporter (changing the source code). then you could e. g. add custom properties in the JRXML and handle these while exporting.

 

background: while generating the JRXML it gets filled with data and all expression get evaluated. The resulting object is JasperPrint which is the meta-output file. The standard customizer processes this file and writes it in the desired output format.

 

none of the standard exporters has the option to hide a specific element. You might want to raise a feature request in bugzilla for a export format specific property to hide elements.

[Multiple graphs in one report]

try this out: create a group based on the field $F{type}. put the chart in the group footer based having label and value as data fields. for each new group the chart will be redrawn.