[jasperreports-questions] print when expression question from newbie

I need help with the syntax in returning a boolean. Whay does this not wirk? I get a compilation error? (($F{JOB_PROFILE_TYPE} != "MERGE") ? true : false) John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.

[jasperreports-questions] different detail lines

Can I only have one detail band? I want to output different information on the detail line dependant upon a field value. How can I do that? John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0) 117 373 6114

[jasperreports-questions] print when and evaluating null

altogether it is printed Why does this not evaluate to true? John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0) 117 373 6114 Fax: +44 (0) 117 373 6115 www.sefas.com

[jasperreports-questions] subreports

blanl lines above the sub report lines. I have removed all margins in the sub-report and set all header band heights to 0 but still have too many blank lines before the first line of the sub-report. Anything I can do to get rid of this ? John Dunn Product Consultant Direct Dial +44 (0) 117 373

[jasperreports-questions] Print leading zeros

How can print a number with leading leading zeros to pad it out to 6 digits? e.g. 1234 should print as 001234 What pattern do I need to set? John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0) 117 373 6114

Re: [jasperreports-questions] subreports

first line of the sub-report. Anything I can do to get rid of this ? John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0) 117 373 6114 Fax: +44 (0) 117 373 6115 www.sefas.com

[jasperreports-questions] When sub report returns no data

When my sub report generates no data (i.e report contains no pages), I just get a line in the master report that says null for various data items. Anyway I can suppress the subreport lines in this case? Example report attached. John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122

[jasperreports-questions] Question re report query SQL

Is it possible to pass part of, or an entire SQL query string as a parameter? My problem is that the SQL where clause may vary from one call of the report to another i.e.some AND clauses may or may not be required. Or is the case that only values can be passed as parameters? John Dunn Product

[jasperreports-questions] How to add pattern to an expression

In the following expression I want to left pad $F{JOB_ID} with zeros to 6 characters $F{JOB_ID} + $F{FILE_NUMBER} + "." + $F{REPRINT_COUNT} Is there an easy way to do that in a expression? John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoi

[jasperreports-questions] store field values

I want to be able to compare a value in my data record with the value from the previous record. i.e I need to store the value from the previous record. How do i do this? ___ jasperreports-questions mailing list jasperreports-questions@lists.sourcef

[jasperreports-questions] Bug in ireport

If I amend an element in one report , save the report and then switch to another report, when I switch back to the first report, the change has been lost. John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44(0

Re: [jasperreports-questions] How to add pattern to an expression

I still need help with this. Can anyone help? In the following expression I want to left pad $F{JOB_ID} with zeros to 6 characters $F{JOB_ID} + $F{FILE_NUMBER} + "." + $F{REPRINT_COUNT} Is there an easy way to do that in a expression? John Dunn Product Consultant Direct Dial +44 (

[jasperreports-questions] Help needed with variable

I am using ireports to create my reports and want to calculate a variable each time I read a record. Basically if field1 = field2 set variable to 1 else set variable to (field2 - field1) * 24 However I have no idea how to write this variable expresssion because I no little java. Can anyone he

[jasperreports-questions] Print 0 when null

I want to print 0 when my numeric value(BigDecimal) is null. Ireports allow me to set the value displayed to "Blank when null", but is it possible to print 0 instead? John Dunn Product Consultant Direct Dial +44 (0) 117 373 6122 Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol B

[jasperreports-questions] Different static texts for different languages

Different static text for different languages How can I set up different static texts depending upon the language? I am using ireport 1.2.2 to create my reports John Dunn <>- Take Surveys. Earn Cash. Influen

[jasperreports-questions] Default oracle date format in ireport

Where does ireport get the default Oracle date format from...is it from the JDBC driver? Can it be changed? John Dunn Product Consultant Sefas Innovation Limited. Tel: + 44 (0) 117 373 6122 www.sefas.com <http://www.sefas.com/> P Please consider the environment before pr

Re: [jasperreports-questions] Default oracle date format in ireport

Where?...I can't see anywhere to change it John Dunn Sefas Innovation Limited. Tel: + 44 (0) 117 373 6122 P Please consider the environment before printing this email From: Suresh Kumar [mailto:sures...@yahoo.co.in] Sent: 12 Nov

Re: [jasperreports-questions] Default oracle date format in ireport

t Subject: Re: [jasperreports-questions] Default oracle date format in ireport "John Dunn" writes: > Where?...I can't see anywhere to change it You can change the display format of a date field as one of the properties of that field in the report, or by manually formatting the f

Re: [jasperreports-questions] Default oracle date format in ireport

David You were absolutely correct...it was the use of $P!{} I've been stareing at that for days! Thanks for spotting my error so quickly(and so early in the day!) John Dunn Sefas Innovation Limited. Tel: + 44 (0) 117 373 6122 P Please consider the environment before pri