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

: AND submitted_date = $P!{PARAM_TO_DATE} parameter PARAM_TO_DATE is defined as a java.util.Date with the default Value Expression set to new java.util.Date(01/01/2050) But when the the Report query reads the SQL is gives the error Error : SQL problems: Missing IN or OUT parameter at index ::1 John Dunn

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 printing

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 November

[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 attachment: winmail.dat- Take Surveys. Earn Cash

[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

[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] 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

[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] 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

[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