Hi,
I need to have a border around text fields in the report. Each text
field should be completely removed when it contains null value. Fields
should be also expanded when text does not fit (stretch with overflow).
Problem occurs when one field is stretched and one field is removed.
Then the size of the enclosed frame is correct, but consecutive elements
(outside of frame) are positioned like frame size is different. It looks
like floating position of the next element is computed with frame still
containing the removed element.
Everything works fine when the field is not removed...
I've attached a report with described situation. It can be previewed in
iReport using Empty Data source. In preview "text" value should normally
be positioned right after the frame's border, but it's about 1 cm lower.
Please help, I'm stuck with this problem for over a week :(.
thanks
tomas

Any solution?
Please, someone?
Cindy
mctpursuer wrote:
>
> Hi, I need to dynamically set the background color of a field in the
> report, e.g. a field called first-level manager, second-level manager, if
> the first-level manager.isCurrentManager == true, then I want to give the
> first-level manager a particular background color, how can I archieve this
> in JasperReport? Thanks a lot.
>
--
View this message in context: http://old.nabble.com/How-to-dynamically-set-the-background-color-of-a-field--Thanks.-tp22285675p26732625.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

Hi Cindy,
1. You can try to use styles of iReport and apply some predefied style
according to value of dynamically passed parameter.
2. Before generating the report you can parse jrxml using some lighter
language (Groovy, Ruby), find needed tag and correct value of appropriate
property.
Hope that would help.
Taras
c.fr wrote:
>
> Any solution?
> Please, someone?
>
> Cindy
>
>
> mctpursuer wrote:
>>
>> Hi, I need to dynamically set the background color of a field in the
>> report, e.g. a field called first-level manager, second-level manager, if
>> the first-level manager.isCurrentManager == true, then I want to give the
>> first-level manager a particular background color, how can I archieve
>> this in JasperReport? Thanks a lot.
>>
>
>
--
View this message in context: http://old.nabble.com/How-to-dynamically-set-the-background-color-of-a-field--Thanks.-tp22285675p26732703.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

I am using jasper report to generate some reports
when firs tested it as a standalone project it worked fine but when i
integrated it with my web project
(using java, jsp, tomcat)...
the whole project failed from the begging before even using the button that
generates the reports:
SEVERE: Allocate exception for servlet ajax
java.lang.NoClassDefFoundError:
net/sf/jasperreports/engine/JRExporterParameter
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
at java.lang.Class.getConstructor0(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1089)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:791)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:127)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
java.lang.NoClassDefFoundError:
net/sf/jasperreports/engine/JRExporterParameter
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
at java.lang.Class.getConstructor0(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1089)
at
org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:791)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:127)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
Plz I need an answer very soon
--
View this message in context: http://old.nabble.com/urgent-plz-tp26729870p26729870.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

There is band called "lastPageFooter" you can use this band to display
data only in the last page of the report.
Thanks
~~~~~~~~~~~~~~~~
Ashok R
Senior Software Engineer
-----Original Message-----
From: ai [mailto:ai_mahathir@...]
Sent: Wednesday, November 18, 2009 3:49 PM
To: jasperreports-questions@...
Subject: [jasperreports-questions] Show Column Footer Only in Last Page
Hi everybody, my name Fakhri, i want to show column footer only in last
page.
I use oracle database. I believed someone in here can help me. Thank you
very much for advice. Best Regards, Fakhri.
--
View this message in context:
http://old.nabble.com/Show-Column-Footer-Only-in-Last-Page-tp26405365p26
405365.html
Sent from the jasperreports-questions mailing list archive at
Nabble.com.
------------------------------------------------------------------------
------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and
focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@...
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions

jnorth wrote:
> Can anybody give advice on problems with backwards compatibility using 3.6.1
> from 3.1.4 (or any other version 3 compatibility issues)?
>
> I need to support the multiple bands feature added in 3.5.2 for some new
> reports but do not want to break any other reports. I am happy to use 3.5.2
> if there are problems with 3.6.1.
>
> Thanks.
>
>
The migration is really safe.
If for some reason you need to keep jrxml level compatibility for some
reports, you can still use the compatibility option from
Tools->Options->iReport->General->Compatibility
Giulio

We usually use JavaBeans as JRDatasource for our reports, but now we
have a special requirement where we also need to execute a query to a
database using data from the JRDatasource as the SQL's WHERE clause, is
it possible to accomplish that using for example a javax.sql.Connection
object as a JRParameter and keeping all the other data the regular way
we are to used to (i.e JavaBeans in the JRDataSource object)? If so,
please provide any hints on achieving such goal.
--
Atentamente,
Gonzalo Vásquez Sáez
Gerente de Proyectos
Altiuz | Neox Desarrollo
Nueva Tajamar 555 Of. 802
Las Condes - Santiago
Fonos 56 (2) 335 2461 / 203 6200
<http://www.neox.cl&gt;
IBM Certified Advanced Application Developer
Rational Application Developer for WebSphere Software
------------------------------------------------------------------------
IBM Certified Database Associate
DB2 Universal Database Family

Dear everybody,
I have some question about export in excel.
As we all know, excel has its limitation in displyting data, about
60000 lines, however, result of my query has more than 200000 lines,
I want to know how to display so many lines in an excel file, or in
other word, how to change pages whent the excel has fufilled its lines
or reaches a certain line limit, does jasperreport has support some
method for the problem ???
urgent question, pls give me your help,thanks.

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 this email
-----Original Message-----
From: David Bolen [mailto:db3l.net@...]
Sent: 13 November 2009 09:09
To: jasperreports-questions@...
Subject: Re: [jasperreports-questions] Default oracle date format in
ireport
"John Dunn" <JDunn@...> writes:
> Thanks, but my problem relates to a date used in the SQL in my report
> query
Ah, other direction - sorry.
> I have tried using a value that is a java.util.date in my SQL query.
> Here is the relevant bit of my SL query :
>
> 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
Ah - it may be your use of $P!{}.
It's my understanding that by using $P!{} you're overriding normal
parameter replacement behavior and forcing iReport/jasperreport to
insert the parameter as a raw string value into the SQL without being
able to parameterize the query to leave data conversions to the driver.
In such cases I believe it's best to ensure that the parameter being
used is a string formatted exactly as you wish for the SQL, and also to
include any necessary quoting, either as part of the parameter or in the
query.
Is there a specific reason that you need to use $P!{} at this point in
your query? It seems like a normal $P{} would be fine, and in that case
the date should transit across the JDBC connection just fine. That
should also have the advantage of being database server agnostic as the
date isn't being converted into a string by your code, but inside the
driver.
If you have to stick with $P!{}, I'm guessing your current parameter
definition is causing the query to likely be built using the result of
.toString() on your parameter, which given what I think is the default
representation for a java.util.Date probably means that internally you
end up with a query like:
and submitted_date >= Sat Jan 01 00:00:00 XXX 2050
(where XXX is the local timezone of the machine the report is run on)
In order to use $P!{}, I'd suggest:
* Make your parameter a type of java.Util.String and then construct the
value so it is exactly the string representation you want of the date.
So perhaps something like:
String.format("%tY-%<tm-%<td", new Date("01/01/2050"))
* Include any necessary quoting in your SQL, which I think would be:
and submitted_date >= '$P!{PARAM_TO_DATE}'
The combination of these two should, I believe, result in a SQL command
sent to the server of:
and submitted_date >= '2005-01-01'
If Oracle doesn't like that format by default, just adjust the format
string as desired.
Beyond that, if you still have problems, I would try to obtain a trace
of the actual SQL that is making it to your server. I'm not familiar
with Oracle but presume there is statement logging of some sort that can
be enabled. Alternatively, I think you can use the JDBC driver manager
to add local logging to your JDBC connection.
-- David
------------------------------------------------------------------------
------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day trial. Simplify your report design, integration and deployment -
and focus on what you do best, core application coding. Discover what's
new with Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@...
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions

"John Dunn" <JDunn@...> writes:
> Thanks, but my problem relates to a date used in the SQL in my report
> query
Ah, other direction - sorry.
> I have tried using a value that is a java.util.date in my SQL query.
> Here is the relevant bit of my SL query :
>
> 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
Ah - it may be your use of $P!{}.
It's my understanding that by using $P!{} you're overriding normal
parameter replacement behavior and forcing iReport/jasperreport to
insert the parameter as a raw string value into the SQL without being
able to parameterize the query to leave data conversions to the
driver. In such cases I believe it's best to ensure that the
parameter being used is a string formatted exactly as you wish for the
SQL, and also to include any necessary quoting, either as part of the
parameter or in the query.
Is there a specific reason that you need to use $P!{} at this point in
your query? It seems like a normal $P{} would be fine, and in that
case the date should transit across the JDBC connection just fine. That
should also have the advantage of being database server agnostic as
the date isn't being converted into a string by your code, but inside
the driver.
If you have to stick with $P!{}, I'm guessing your current parameter
definition is causing the query to likely be built using the result of
.toString() on your parameter, which given what I think is the default
representation for a java.util.Date probably means that internally you
end up with a query like:
and submitted_date >= Sat Jan 01 00:00:00 XXX 2050
(where XXX is the local timezone of the machine the report is run on)
In order to use $P!{}, I'd suggest:
* Make your parameter a type of java.Util.String and then construct the
value so it is exactly the string representation you want of the date.
So perhaps something like:
String.format("%tY-%<tm-%<td", new Date("01/01/2050"))
* Include any necessary quoting in your SQL, which I think would be:
and submitted_date >= '$P!{PARAM_TO_DATE}'
The combination of these two should, I believe, result in a SQL
command sent to the server of:
and submitted_date >= '2005-01-01'
If Oracle doesn't like that format by default, just adjust the format
string as desired.
Beyond that, if you still have problems, I would try to obtain a trace
of the actual SQL that is making it to your server. I'm not familiar
with Oracle but presume there is statement logging of some sort that
can be enabled. Alternatively, I think you can use the JDBC driver
manager to add local logging to your JDBC connection.
-- David

Thanks, but my problem relates to a date used in the SQL in my report
query
I have a report that I need to run against a variety of SQL databases,
i.e Oracle, MYSQL, DB2
I have tried using a value that is a java.util.date in my SQL query.
Here is the relevant bit of my SL query :
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
Sefas Innovation Limited.
Tel: + 44 (0) 117 373 6122
P Please consider the environment before printing this email
-----Original Message-----
From: David Bolen [mailto:db3l.net@...]
Sent: 13 November 2009 02:30
To: jasperreports-questions@...
Subject: Re: [jasperreports-questions] Default oracle date format in
ireport
"John Dunn" <JDunn@...> 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
field when constructing a string field.
For simple date/time fields, use the Pattern property to select from one
of the predefined patterns. You can also manually type in a pattern
using the appropriate letter codes.
For more elaborate formatting, you can make the field a String field,
and then use String.Format with date/time formatting codes.
For example, I have a title field defined as a string that uses:
String.format('%tA, %<tB %<te', $F{class_date}) + ", " +
String.format('%tl:%<tM %<tp', $F{start_time}) + " - " +
String.format('%tl:%<tM %<tp', $F{end_time})
where class_date is a database date field, and start_time/end_time are
database time fields.
(Note that I think the above syntax may require a groovy Report
interpreter, so if using Java you probably need some new() calls or
something)
which produces an output like:
Monday, August 31, 9:30 am - 10:20 am
I don't think the above should be database-specific. The JDBC interface
to the database should be returning date/time fields in an appropriate
java object, so once it's on the iReport side any of the formatting
should be possible.
-- David
------------------------------------------------------------------------
------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day trial. Simplify your report design, integration and deployment -
and focus on what you do best, core application coding. Discover what's
new with Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
jasperreports-questions mailing list
jasperreports-questions@...
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions

"John Dunn" <JDunn@...> 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
field when constructing a string field.
For simple date/time fields, use the Pattern property to select from
one of the predefined patterns. You can also manually type in a
pattern using the appropriate letter codes.
For more elaborate formatting, you can make the field a String field,
and then use String.Format with date/time formatting codes.
For example, I have a title field defined as a string that uses:
String.format('%tA, %<tB %<te', $F{class_date}) + ", " +
String.format('%tl:%<tM %<tp', $F{start_time}) + " - " +
String.format('%tl:%<tM %<tp', $F{end_time})
where class_date is a database date field, and start_time/end_time are
database time fields.
(Note that I think the above syntax may require a groovy Report interpreter,
so if using Java you probably need some new() calls or something)
which produces an output like:
Monday, August 31, 9:30 am - 10:20 am
I don't think the above should be database-specific. The JDBC
interface to the database should be returning date/time fields in an
appropriate java object, so once it's on the iReport side any of the
formatting should be possible.
-- David

Hi John,
Possible we can change it in the report design
Thanks
Suresh
________________________________
From: John Dunn <JDunn@...>
To: jasperreports-questions@...
Sent: Thu, 12 November, 2009 12:35:07 AM
Subject: [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
http://www.sefas.com
P Please consider the environment before printing this email
Sefas Innovation Limited, CityPoint, Temple Gate, Bristol BS1 6PL, UK.
Tel: +44 (0) 117 373 6114 Fax: +44 (0) 117 373 6115.
Registered No: 3769761 England.
Registered Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom.
VAT Registration No: GB 741 5377 32
Unless stated to be non-confidential, this email and any attachments are private and confidential and are for the addressee only. Sefas monitors e-mails to ensure its systems operate effectively and to minimize the risk of viruses. Whilst Sefas has taken reasonable steps to scan this email, it does not accept liability for any virus that may be contained in it.
Internet communications are not 100% secure and as such Sefas is not responsible for their abuse by 3rd parties, nor for any alteration or corruption in transmission.
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

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
http://www.sefas.com <http://www.sefas.com/&gt;
P Please consider the environment before printing this email
Sefas Innovation Limited, CityPoint, Temple Gate, Bristol BS1 6PL, UK.
Tel: +44 (0) 117 373 6114 Fax: +44 (0) 117 373 6115.
Registered No: 3769761 England.
Registered Office: One New Street, Wells, Somerset, BA5 2LA, United
Kingdom.
VAT Registration No: GB 741 5377 32
Unless stated to be non-confidential, this email and any attachments are
private and confidential and are for the addressee only. Sefas monitors
e-mails to ensure its systems operate effectively and to minimize the
risk of viruses. Whilst Sefas has taken reasonable steps to scan this
email, it does not accept liability for any virus that may be contained
in it.
Internet communications are not 100% secure and as such Sefas is not
responsible for their abuse by 3rd parties, nor for any alteration or
corruption in transmission.

Can anybody give advice on problems with backwards compatibility using 3.6.1
from 3.1.4 (or any other version 3 compatibility issues)?
I need to support the multiple bands feature added in 3.5.2 for some new
reports but do not want to break any other reports. I am happy to use 3.5.2
if there are problems with 3.6.1.
Thanks.
--
View this message in context: http://old.nabble.com/Migrating-to-3.6.1-from-3.1.4-tp26265324p26265324.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

hello friends...
I am new to jasper Reports.In my comapny i use iReport to generate jasper
Reports.so can u please suggest me ebook for iReport that clear my all
concepts.Also we use reportquery.properties file and reportwizard.xml.so can
u pls tell me the use of that files ???
Thanks in advance :)
--
View this message in context: http://old.nabble.com/Book-for-iReport-tp26252781p26252781.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

Hi harish i am also new to this jasper reports.You can use jasper ireports
tools to create JRXML files where u can drag n drop fields,variables, static
text fields and many more on to ur report and u can directly preview ur
reports by clicking on preview button.
busbus wrote:
>
> Jasper Reports Rookie here.
>
> Am not going to ask you to teach me entire things. But to clear few simple
> doubts.
>
> 1. Is JRXml or XML the only input and the only way for Jasper Reports.
>
> 2. If Yes, then, is there any API to generate the JRXml or we can write
> out own JRXml following the general JRXml Schema/Template?
>
> Thankyou
>
--
View this message in context: http://old.nabble.com/Jasper-Reports-Beginner-needs-simple-Clarification-tp25693053p26230524.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

Hi!
The thing I am doing is displaying Jasper Report in an JApplet in web
browser. Eeverything is working fine except two.
1. The detail section of my report is not showing up in the applet. I'm
sure that there is no issue with the report filling as the values of query
fields put in other sections like page header are showing up. Only the
detail section is missing. Can anyone give some idae about the cause?
2. The SAVE button of the JR Viewer in the applet is not working. Any
comments?
Thanks & Best Regards.
AsadULLAH!
--
View this message in context: http://www.nabble.com/Applet-based-Jasper-Report%21-tp26024492p26024492.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

Hi,
I have a Collection of beans. The bean again contains collection of beans.
can you tell me how to use it to create a report using single datasource? I
am using iReport.
Even a smallest piece of information is highly appreciated.
Thanks in advance.
Dinakar.K
--
View this message in context: http://www.nabble.com/Java-Beans-set-Datasource-tp25929345p25929345.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

Novice requires some more clarifications.
Having Chris's Idea running in parallel. I would like put my question in a
different way.
In JRXML
<field name = "projectId" class = "java.lang.Integer">
<field name = "coverageId" class = "java.lang.Integer">
Is there any way that i can mention
projectId belongs to the class Project
coverageId belongs to the class Coverage
??
--
View this message in context: http://www.nabble.com/Multiple-Object-in-DataSource-Collection-tp25816344p25840895.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

3 messages has been excluded from this view by a project administrator.