[jasperreports-questions] jasperreports-Error

2008-09-02 Thread Prasad Boddu
Hi All,


I want to print numbers of Excel Sheets with one print job.

Please tell me is it possible if it is possible can you tell me the logic.



Thanks

Prasad Boddu
iGATE is Ranked No. 3 in DQ-IDC best IT employer survey and Ranked No.6 
by Business Today-Mercer Human Resource Consulting-TNS  in a cross industry 
survey of Best Companies to work for in India
DISCLAIMER-
Information transmitted by this EMAIL is proprietary to iGATE Group of 
Companies and is intended for use only by the individual 
or entity to whom it is addressed and may contain information that is 
privileged, confidential, or exempt from disclosure under 
applicable law. If you are not the intended recipient of this EMAIL immediately 
notify the sender at iGATE or [EMAIL PROTECTED] 
and delete this EMAIL including any attachments
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions


[jasperreports-questions] Error initializing graphic environment.

2008-09-02 Thread Abhishek Sharma
hello all,

I getting this error while I am trying to fill a sample application webapp
with jasperReports. I am new to java and JasperReports please any one help
me ?

JasperReports encountered this error :

net.sf.jasperreports.engine.JRException: Error initializing graphic environment.
at 
net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer.java:62)
at net.sf.jasperreports.engine.fill.JRBaseFiller.(JRBaseFiller.java:363)
at 
net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:77)
at 
net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:59)
at 
net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147)
at 
net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:83)
at 
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)
at 
net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:517)
at org.apache.jsp.jsp.fill_jsp._jspService(fill_jsp.java:71)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
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:874)
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)
Caused by: java.lang.NullPointerException
at sun.awt.FontConfiguration.getVersion(Unknown Source)
at sun.awt.FontConfiguration.readFontConfigFile(Unknown Source)
at sun.awt.FontConfiguration.(Unknown Source)
at sun.awt.windows.WFontConfiguration.(Unknown Source)
at sun.awt.Win32GraphicsEnvironment.createFontConfiguration(Unknown 
Source)
at sun.java2d.SunGraphicsEnvironment$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.java2d.SunGraphicsEnvironment.(Unknown Source)
at sun.awt.Win32GraphicsEnvironment.(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown 
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(Unknown 
Source)
at 
net.sf.jasperreports.engine.util.JRGraphEnvInitializer.initializeGraphEnv(JRGraphEnvInitializer.java:58)
... 28 more



-- 
WIth Regards !
Abhishek sharma
[EMAIL PROTECTED]
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions


Re: [jasperreports-questions] Input Date Not working in Jasper reports?

2008-09-02 Thread adhikarisanu

Hi

i am having the same problem.. my reports without parameters are running
well in jasperserver but not the ones with parameters...  what do i need to
do in Jasperserver to make the parameters work...  please help...

Sanu

Sherman Wood wrote:
 
 You are talking about JasperServer, right?
 
 How have you set up the parameters in the JRXML?
 
 The date parameters in JasperServer will come in as java.util.Date
 objects.
 
 
 Sherman
 JasperSoft
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf
 Of
 Ashish.Anant
 Sent: Friday, January 04, 2008 7:40 PM
 To: jasperreports-questions@lists.sourceforge.net
 Subject: [jasperreports-questions] Input Date Not working in Jasper
 reports?
 
 
 Hello All,
 
 I'm trying to run the bellow query through Jasper reports. The report ask
 for two input paramters (startDate and endDate), so, I added two control
 with the similar name what I'm using in query (pStartDate and pEndDate) of
 date type. The format I'm using for date is 
 mm-dd-. 
 
 But the problem is, whenever I'm running the same query with some date
 range
 directly on mysql console, I'm getting the result properly. Same query
 with
 same input is also running and giving me correct result through Open
 Reports
 also. But whenever I'm running this query through Jasper Report, I'm
 getting
 NOTHING (Saying ... reports data empty).
 
 
 I think, the format of date or something somehow is going wrong here. Can
 someone pls give me any idea what I'm missing here? I pasted the query
 below
 of this mail.
 
 
 thanks (in adv)
 
 Ashish.
 ([EMAIL PROTECTED])
 ==
 select
   PO.created as 'Date',
   PO.purchase_order_id as 'Transaction ID',
   L.price as 'Transaction Amount',
   concat(PO.status, '-', ifnull(PO.delivery_status,'')) as 'State',
   'paypal' as 'Payment Source',
   UB.userId as 'Buyer User ID',
   UB.userEmail as 'Buyer email',
   PPPVB.email as 'Buyer Paypal ID/Email',
   URB.buyerRating as 'Buyer Rating',
   US.userId as 'Seller User ID',
   US.userEmail as 'Seller email',
   PPPVS.email as 'Seller Paypal ID/Email',
   URS.sellerRating as 'Seller Rating',
   G.gameShortName as Game,
   UAB.userAvatarName as 'Buyer Avatar Name',
   UAS.userAvatarName as 'Seller Avatar Name',
   CI.catalogItemTitle as Item,
   L.price as Amount
 from
   ps_purchase_order PO
   join ps_listing L on (PO.listing_id = L.listing_id)
   join useravatar UAB on (PO.avatar_id = UAB.userAvatarId)
   join ps_purchase_attempt PURCHA on (PURCHA.purchase_order_id =
 PO.purchase_order_id)
   join ps_payment_attempt PAB on (PURCHA.payment_attempt_id =
 PAB.payment_attempt_id)
   join ps_payment_vehicle PVB on (PVB.payment_vehicle_id =
 PAB.payment_vehicle_id)
   join ps_paypal_payment_vehicle PPPVB on (PPPVB.payment_vehicle_id =
 PVB.payment_vehicle_id)
   join user UB on (UAB.userId = UB.userId)
   join useravatar UAS on (L.avatar_id = UAS.userAvatarId)
   join user US on (UAS.userId = US.userId)
   join ps_account ACCTS on (US.userId = ACCTS.user_id)
   join ps_payment_vehicle PVS on (ACCTS.account_id = PVS.account_id)
   join ps_paypal_payment_vehicle PPPVS on (PPPVS.payment_vehicle_id =
 PVS.payment_vehicle_id)
   join catalogitem CI on (L.item_id = CI.catalogItemId)
   join game G on (CI.gameId = G.gameId)
   join userrating URB on (UB.userId = URB.userId)
   join userrating URS on (US.userId = URS.userId)
 where
   PO.status in ('PAID', 'INVOICED')
   and PVS.status = 'ACTIVE'
   and (date_format(PO.created, '%m-%d-%Y') = $P{pStartDate})
   and (date_format(PO.created, '%m-%d-%Y') = $P{pEndDate})
 group by 
 PO.purchase_order_id
 order by 
 PO.created desc;
 
 -- 
 View this message in context:
 http://www.nabble.com/Input-Date-Not-working-in-Jasper-reports--tp14612558p1
 4612558.html
 Sent from the jasperreports-questions mailing list archive at Nabble.com.
 
 
 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2005.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
 ___
 jasperreports-questions mailing list
 jasperreports-questions@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
 
 
 
 -
 This SF.net email is sponsored by: Microsoft
 Defy all challenges. Microsoft(R) Visual Studio 2005.
 http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
 ___
 jasperreports-questions mailing list
 jasperreports-questions@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
 
 

-- 
View this message in context: 
http://www.nabble.com/Input-Date-Not-working-in-Jasper-reports--tp14612558p18966348.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.



[jasperreports-questions] Looping through child elements in XMLDataSource

2008-09-02 Thread Iwud H8u

Hi All,

I am generating a report from an XML document using JRXmlDataSource. I have
specified the XPath in the field description to render the values on the
report. All this seems to work fine, but when a node has more than one
child, the fields for only the first node are generated. It seems like
JasperReports will not iterate through all the child elements of a node.

Has anyone had any similar experiences or do you have a solution? Below is
an example of the fields I am using.. In this case, I would expect more than
one session_name field to be generated but only the first instance of the
field is generated on the report!

field name=session_name class=java.lang.String
fieldDescription![CDATA[//session/@name]]/fieldDescription
/field
-- 
View this message in context: 
http://www.nabble.com/Looping-through-child-elements-in-XMLDataSource-tp19204230p19204230.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK  win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100url=/
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions