[jasperreports-questions] How to get rid of NullPx image in html report
I am using iReport 4.7.1. I include jaspert report (report.jasper) created by iReport in my java project. Everything works fine except for the X image (NullPx). Is there a way to get rid of this X image ? -- View this message in context: http://old.nabble.com/How-to-get-rid-of-NullPx-image-in-html-report-tp34643959p34643959.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How to get rid of NullPx image in html report
Hi, Please post your questions on the community website at: http://community.jaspersoft.com/answers?f[0]=field_question_project%3A202 You can use the JRXhtmlExporter instead or configure the HTML one to not make use of images to align by setting the following custom property: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.html.using.images.to.align But if one day you'll have reports that indeed have images, then you better learn how to configure the image servlet in your application, by looking at our /demo/samples/webapp and demo/samples/webapp-repo samples shipped with the JR Library distro. I hope this helps. Teodor Pe 05.11.2012 21:03, jsb26 a scris: I am using iReport 4.7.1. I include jaspert report (report.jasper) created by iReport in my java project. Everything works fine except for the X image (NullPx). Is there a way to get rid of this X image ? -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Extra white space when detail section overflows
Hi In my report whenever the detail section overflows to the next page there's an extra white space left at the bottom (where couple of rows of data can easily fits) Does anyone knows how to eliminate this space. Thanks, Muttalib -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerryreg; mobile platform with sessions, labs more. See new tools and technologies. Register for BlackBerryreg; DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Extra white space when detail section overflows
Check the footer, if u are not using it , remove it or configure it to be at certain height from bottom of page Sent from my iPhone On Sep 14, 2011, at 6:09 AM, Muttalib Hossain muttalibhoss...@gmail.com wrote: Hi In my report whenever the detail section overflows to the next page there's an extra white space left at the bottom (where couple of rows of data can easily fits) Does anyone knows how to eliminate this space. Thanks, Muttalib -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerryreg; mobile platform with sessions, labs more. See new tools and technologies. Register for BlackBerryreg; DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerryreg; mobile platform with sessions, labs more. See new tools and technologies. Register for BlackBerryreg; DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Silent print of PDF report without opening at client/browser
Hi
I'm trying to get a silent print of my PDF report at client/browser.
Unfortunately, I can't be quite successful in this. My silent print command
comes to browser with the PDF document and when I open this there's a dialog
stating this document is trying to print, now if I click ok, the document
gets printed. But I need to print the document silently without opening and
without showing any dialog (not download dialog too).
The code block for setting exporter with silent print parameter is as follows:
OutputStream outputStream = new FileOutputStream(outputFile);
exporter = new JRPdfExporter();
exporter.setParameter(JRPdfExporterParameter.CHARACTER_ENCODING,
UTF-8);
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
exporter.setParameter(JRPdfExporterParameter.PDF_JAVASCRIPT,this.print({bUI:
false,bSilent: true,bShrinkToFit: false}););
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,
outputStream);
exporter.exportReport();
Can anyone help me resolve this or at least let me know if it's possible or not?
Thanks
Rashed
--
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it.
http://p.sf.net/sfu/wandisco-dev2dev___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[no subject]
living paycheck to paycheck wasnt working for me it was important for me to stay positive this was my opportunity knocking at the door!! http://arata5acapella.web.fc2.com//NeilBennett83.html now im on the way to the top just picture all that is possible
[no subject]
living paycheck to paycheck wasnt working for me it was important for me to stay positive this was my opportunity knocking at the door!! http://arata5acapella.web.fc2.com//NeilBennett83.html now im on the way to the top just picture all that is possible
Re: [jasperreports-questions] How to generate 2 dimensional report in jasper?
On Tue, Jun 21, 2011 at 4:07 PM, geetha r rgeethana...@gmail.com wrote: hi Rajesh , You can use dynamic jasper , u need to import dynamic jasper jars ... Actually everything branched out from Jasperreports only, you will have more flexibility in while creating a report in jasper reports. not sure about dynamic reporting but guess/bet it would some constraints, try using it if want the fully power of Jasper reports. p.s: It's always good to be included in the list than conversing off list rgds, -- Rajesh Pandian M http://mrprajesh.blogspot.com/ http://twitter.com/mrprajesh -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] How to generate 2 dimensional report in jasper?
Hi, I am new to jasper reporting tool. Can anyone tell me how to generate 2 dimensional report in jasper? i.e dynamic row column generation simultaneously? The output should look like the attached file. the date company unit will be known at runtime only. Any help on this matter, would be greatly appreciated ! Thanks in advance!!! http://old.nabble.com/file/p31883313/image001.png -- View this message in context: http://old.nabble.com/How-to-generate-2-dimensional-report-in-jasper--tp31883313p31883313.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How to generate 2 dimensional report in jasper?
On Mon, Jun 20, 2011 at 12:44 PM, leebangalore piquant.libra...@gmail.comwrote: Hi, I am new to jasper reporting tool. Can anyone tell me how to generate 2 dimensional report in jasper? i.e dynamic row column generation simultaneously? This source might help you. they have given working example http://www.amazon.com/JasperReports-Java-Developers-Reports-reporting/dp/1904811906 -- Rajesh Pandian M http://mrprajesh.blogspot.com/ http://twitter.com/mrprajesh -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Webapplication to run jasper reports
On Fri, May 27, 2011 at 12:56 PM, Theja theja...@gmail.com wrote: Hi All, I want ot create a Web application , with a jsp page and iframe, to run the jasper report from the application. Please help me. Its very urgent for me. Please don't post your assignment question here. If you really want help from people in the list. show them how far you have tried then they will come forward help you. -- Rajesh Pandian M -- vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Two sub reports in one report with different data sources in struts2-jasper report environment
can we use two sub reports in one report with different data sources in struts2-jasper report environment?? Please its urgent for me. i.e. can we send two lists in action -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] java.lang.NoClassDefFoundError: jet/bean/JREngine
Hi, Iam trying to generating pdf using JREngine.zip,JREntServer.zip,JRESServlets.zip in weblogic10.3 but iam getting the below error and add above jars into the class path aslo java.lang.NoClassDefFoundError: jet/bean/JREngine at jet.server.schedule.jrtasks.RunRptTask.runReport(jet/server/schedule/jrtasks/RunRptTask) at jet.server.schedule.jrtasks.ViewRptTask.runReport(jet/server/schedule/jrtasks/ViewRptTask) at jet.server.schedule.jrtasks.JRScheduleService.submitForInstantRun(jet/server/schedule/jrtasks/JRScheduleService) at jet.server.jrserver.JRRptServer.runReport(jet/server/jrserver/JRRptServer) at jet.server.servlets.WebViewServlet.$lQ(jet/server/servlets/WebViewServlet) at jet.server.servlets.WebViewServlet.action(jet/server/servlets/WebViewServlet) at jet.server.servlets.WebViewServlet.doGet(jet/server/servlets/WebViewServlet) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at jet.server.servlets.WebViewServlet.service(jet/server/servlets/WebViewServlet) at javax.servlet.http.HttpServlet.service(HttpServlet.java:821) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:176) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(Unknown Source) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086) at weblogic.servlet.internal.ServletRequestImpl.run(Unknown Source) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201) at weblogic.work.ExecuteThread.run(ExecuteThread.java:173) -- View this message in context: http://old.nabble.com/java.lang.NoClassDefFoundError%3A-jet-bean-JREngine-tp30663637p30663637.html Sent from the JReport mailing list archive at Nabble.com. -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] unable to generate sub report in jasper reports(help me please)
hi , I am your old student. In my company we are using Swings on NetBeans IDE. I need a requirement of generating sub report. here i am attaching the code. In that i have two queries. one for main report and one for sub report. but am unable to call the sub report... can you please send me the code. its urgent... please.. http://old.nabble.com/file/p30556708/Fin_PaidReceiptRpt.jrxml Fin_PaidReceiptRpt.jrxml http://old.nabble.com/file/p30556708/Fin_PaidReceiptRpt_subreport0.jrxml Fin_PaidReceiptRpt_subreport0.jrxml http://old.nabble.com/file/p30556708/PaidReciptReport.java PaidReciptReport.java http://old.nabble.com/file/p30556708/JasperReportInvoker.java JasperReportInvoker.java -- View this message in context: http://old.nabble.com/How-about-loop-a-sub-report--tp23847733p30556708.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] sub reports auto compile
bpamarti wrote: Regarding the subreports what I do is compile them individually and standalone reports and place the .jasper files along with the main report .jasper file and pass the parameter SUBREPORT_DIR to the main report In the subreportExpression tag you use this. Hope this helps. thanks, Pamarti Peace is found not in what surrounds us, but in what we hold within. --- On Fri, 9/26/08, Philippe Couas pco...@infodev.fr wrote: From: Philippe Couas pco...@infodev.fr Subject: Re: [jasperreports-questions] sub reports auto compile To: jasperreports-questions@lists.sourceforge.net Date: Friday, September 26, 2008, 10:23 AM Hi, If my CustomersReport.jrxml contains two sub reports they are compiled too ? Regards Philippe De : BalaKishore Pamarti [mailto:bpama...@yahoo.com] Envoyé : vendredi 26 septembre 2008 16:16 À : jasperreports-questions@lists.sourceforge.net; Philippe Couas Objet : Re: [jasperreports-questions] sub reports auto compile Just try -- JasperCompileManager.compileReportToFile(request.getSession().getServletContext().getRealPath(/jasperreports/ + fileName + .jrxml)); Pamarti Peace is found not in what surrounds us, but in what we hold within. --- On Fri, 9/26/08, Philippe Couas pco...@infodev.fr wrote: From: Philippe Couas pco...@infodev.fr Subject: [jasperreports-questions] sub reports auto compile To: jasperreports-questions@lists.sourceforge.net Date: Friday, September 26, 2008, 12:57 AM Hi, I have an main report with many sub reports. Into my directory i have jrxml file , How could i found sub report name and directory from main report ? I have tried following code, but that's not allawys true. String fileName=c:\\prj_java\\TestAgarder\\jasperxml01\\CustomersReport.jrxml; JasperCompileManager.compileReportToFile(fileName); JasperReport jasperReport = JasperCompileManager.compileReport(fileName); JRBand jb = jasperReport.getDetail(); // jb children Expression java.util.List jl=jb.getChildren(); JRBaseSubreport jsr=(JRBaseSubreport)jl.get(3); JRExpression jre=jsr.getExpression(); JRExpressionChunk[] jch=jre.getChunks(); String fichierjasper=jch[0].getText(); Regards Philippe- 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 - 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 - 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 -- View this message in context: http://old.nabble.com/sub-reports-auto-compile-tp19682794p30556710.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] sub reports auto compile
ok but how to send the two queries there??? i hav queries right.. how can i pass that two queries from code.. i hav to send that through code it self.. If you hav any coding regarding sub reports send me once. On Thu, Dec 30, 2010 at 5:18 PM, @rju nagarjunabatt...@gmail.com wrote: bpamarti wrote: Regarding the subreports what I do is compile them individually and standalone reports and place the .jasper files along with the main report .jasper file and pass the parameter SUBREPORT_DIR to the main report In the subreportExpression tag you use this. Hope this helps. thanks, Pamarti Peace is found not in what surrounds us, but in what we hold within. --- On Fri, 9/26/08, Philippe Couas pco...@infodev.fr wrote: From: Philippe Couas pco...@infodev.fr Subject: Re: [jasperreports-questions] sub reports auto compile To: jasperreports-questions@lists.sourceforge.net Date: Friday, September 26, 2008, 10:23 AM Hi, If my CustomersReport.jrxml contains two sub reports they are compiled too ? Regards Philippe De : BalaKishore Pamarti [mailto:bpama...@yahoo.com] Envoyé : vendredi 26 septembre 2008 16:16 À : jasperreports-questions@lists.sourceforge.net; Philippe Couas Objet : Re: [jasperreports-questions] sub reports auto compile Just try -- JasperCompileManager.compileReportToFile(request.getSession().getServletContext().getRealPath(/jasperreports/ + fileName + .jrxml)); Pamarti Peace is found not in what surrounds us, but in what we hold within. --- On Fri, 9/26/08, Philippe Couas pco...@infodev.fr wrote: From: Philippe Couas pco...@infodev.fr Subject: [jasperreports-questions] sub reports auto compile To: jasperreports-questions@lists.sourceforge.net Date: Friday, September 26, 2008, 12:57 AM Hi, I have an main report with many sub reports. Into my directory i have jrxml file , How could i found sub report name and directory from main report ? I have tried following code, but that's not allawys true. String fileName=c:\\prj_java\\TestAgarder\\jasperxml01\\CustomersReport.jrxml; JasperCompileManager.compileReportToFile(fileName); JasperReport jasperReport = JasperCompileManager.compileReport(fileName); JRBand jb = jasperReport.getDetail(); // jb children Expression java.util.List jl=jb.getChildren(); JRBaseSubreport jsr=(JRBaseSubreport)jl.get(3); JRExpression jre=jsr.getExpression(); JRExpressionChunk[] jch=jre.getChunks(); String fichierjasper=jch[0].getText(); Regards Philippe- 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 - 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 - 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 -- View this message in context: http://old.nabble.com/sub-reports-auto-compile-tp19682794p30556710.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl ___
Re: [jasperreports-questions] jasper reports performance issue
hi bhargavi, I am also working on jasper reports+Struts2+Hibernates and am facing problems regarding this. Especially jasperFillManager method is taking lot of time to fill the data and obviously data base issue also coming... I f you have find solution for this please help me -- View this message in context: http://old.nabble.com/jasper-reports-performance-issue-tp22306858p30365296.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for being marooned without product support? Time to move off Lotus Notes and onto the cloud with Force.com, apps are easier to build, use, and manage than apps on traditional platforms. Sign up for the Lotus Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] logic in jrxml?
Hello all, Is there any logic parameter in jrxml? If yes, we can perform some testings like skipping to display some parameters if they are null or empty and make the whole report more tidy. Like struts, its tag language has s:if test= /s:if Terry. -- View this message in context: http://old.nabble.com/logic-in-jrxml--tp30177322p30177322.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- What happens now with your Lotus Notes apps - do you make another costly upgrade, or settle for being marooned without product support? Time to move off Lotus Notes and onto the cloud with Force.com, apps are easier to build, use, and manage than apps on traditional platforms. Sign up for the Lotus Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] current or past date on scheduled reports
Hello all, I've been using jasperserver and ireports for a few months, i have a report within a range given by 'since' and 'to' parameters, both strings representing dates. Throug ireport, i've configured both default values to be the first and current day of the month, respectively. Now i'm trying to schedule the report, but when setting the schedule params and options, the report params take its defaults, setting the 'to' param to the date when the report was scheduled, not the date when the report is running. There is a way, other than 'hard-coding' the current date in the query, to set those params in a way that could take the run-time date? Thanks in advance, Keber Flores B. RD Tech - Segic Usach Ltd. -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Expanding chart on clicking it.
Hi, I am trying to create a report which should have miniature charts and after clicking that chart ,the same chart should get expanded in top right corner of the report. Is there any way to do it? Please help me. Regards, Snehalata -- View this message in context: http://old.nabble.com/Expanding-chart-on-clicking-it.-tp29313497p29313497.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Slider in JasperReports
Hi, I want to use slider in my report as a performance indicator. I am comparing my current years revenue to last years revenue. If the performance is average then the pointer should move to middle and if the performance is more than average then it should move further. Can we have such a slider in JasperReports ??? If there is any other way to achieve it,then please tell me. Please help me. Regards, Snehalata -- View this message in context: http://old.nabble.com/Slider-in-JasperReports-tp29313488p29313488.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Applet based Jasper Report!
Can anyone help on this issue 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? -- View this message in context: http://old.nabble.com/Applet-based-Jasper-Report%21-tp26024492p28030457.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] jasper reports performance issue
Hi Anila, Have found the way to optimize your jasper reports? If you got it, can you please help me on the same. Regards, Rajani AnilaBhargavi.Vankamamidi wrote: Hi, When huge data is to be filled into the jasper report, it is taking much time for the report generation. (It took 19mins to generate one of my report.) Please help me with a solution where I can optimize this filling process of the jasper report, so that reports can be generated quickly? Please provide with any source code if available. Regards, V. Anila Bhargavi|172793 Cognizant Technology Solutions| Hyderabad Mobile: 9849908536 This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- View this message in context: http://old.nabble.com/jasper-reports-performance-issue-tp22306858p28040719.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] simple jasper report in java without a database.
Dear all,
I hope you are doing good. I would like to know whether we can generate a
jasper report in java http://www.javaranch.com/ without using any database
connection. I know we can generate jasper report in java with database
connection. I have generated few reprts in .pdf and .xls format. Now I want
to display some text on the the jasper report in java without database, say
hello jasper. I am using ireport. I have creaated a file and in that file,
I have added a title in the title section $P{Report_title} . Now in the
program, i am declaring a hashmap and trying put value in the hasmap like,
hm.put(Report_title,Hello Report);
Later I am declaring JasperPrint like as follows.
JasperPrint print=JasperFillManager.fillReportToFile(fileName,
outFileNamePDF, hm);
Here I am having problem about type mismatch:cannot convert from void to
JasperPrint. I am not fully familiar with JasperReport API. I am trying to
learn it with some simple examples first.In order to get the data on the
report what I am supposed to do? Passing value from hashmap? Or shall use
any collections? I would appreciate your suggestions. Thanks in advance.
Please find the code. It's vary simple at the moment.
import java.util.HashMap;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporter;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
@SuppressWarnings(unchecked)
public class JasperSimple {
String fileName = C:\\Documents and
Settings\\abhijit\\JasperSimpleReport.jasper;
String outFileNamePDF = c:\\JasperSimpleReport.pdf;
HashMap hm = new HashMap();
public JasperSimple() {
super();
}
@SuppressWarnings(deprecation)
public void generateReport() throws ClassNotFoundException,
InstantiationException, IllegalAccessException {
try {
System.out.println(Filling report...);
hm.put($P{Report_title},Hello Report);
//JasperReport manager=JasperManager.compileReport(fileName);
JasperPrint print=JasperFillManager.fillReport(fileName, hm);
//byte[] bytes = JasperExportManager.exportReportToPdf(print);
//define and initialize jasperreport engine's exporter for .pdf
JRExporter exporter = new
net.sf.jasperreports.engine.export.JRPdfExporter();
//parameter used for the destined file.
exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,
outFileNamePDF);
exporter.setParameter(JRExporterParameter.JASPER_PRINT, print);
//export to .pdf
exporter.exportReport();
System.out.println(Created file: + outFileNamePDF);
System.out.println(Done!);
} catch (JRException e) {
e.printStackTrace();
}
catch(Exception e1){
e1.printStackTrace();
}
}
public static void main(String[] args) throws ClassNotFoundException,
InstantiationException, IllegalAccessException {
new JasperSimple().generateReport();
System.out.println(No. of argumetns are: + args.length);
for(int i= 0;i args.length;i++)
System.out.println(Argument + i + is : + args[i]);
}
}
--
Download Intel#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Jasper report execution in java with parametrized query at run time
Hello, I have been working on Jasper Reports. I have created few reports using ireport and I was able to export these reports within java. Of course these reports were simple. Now I want to get deeper in Jasper reports. I want to know how one can execute jasper report in java with parametrized query at run time. Has anyone worked on similar module? Do we need to create any .xml at runtime for this? Right now the Jrxml file contains the query which was written in the context while designing the report. Now, I want to run the query dynamically. I am looking forward for your suggestions and advices. Thank you in advance. Best regards. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Jasper report execution in java with parametrized query at run time
On Thu, Mar 25, 2010 at 12:50 PM, Abhijit Kamatkar abhijitkamat...@gmail.com wrote: Hello, I have been working on Jasper Reports. I have created few reports using ireport and I was able to export these reports within java. Of course these reports were simple. Now I want to get deeper in Jasper reports. I want to know how one can execute jasper report in java with parametrized query at run time. Has anyone worked on similar module? Do we need to create any .xml at runtime for this? Right now the Jrxml file contains the query which was written in the context while designing the report. Now, I want to run the query dynamically. I am looking forward for your suggestions and advices. Thank you in advance. AFAIK it not necessary to create an xml file. there are two options, 1. have the query executed before going to jrxml file and get the resultset instance, wrap it with jrresultsetdatasource. then create report 2. have the query in jrxml file itself. and just pass the Hash Map instance of all the parametrized[dynamic] values to jrxml -- Rajesh Pandian M http://mrprajesh.blogspot.com/ http://twitter.com/mrprajesh -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] two graph
Hi All, I have problem displaying two html reports in one page. I have 2 jasper report graphs and in my html page I have 2 iframes to display both graphs. but the image of the graph seem to be the same for both reports, yet if I refresh iframe then I get the correct graph. the problem seem to be that both get invoke using the same servlet at the same time.. so it's getting the same image for both graphs. http://domain.com/serlimage?type=agraph1time=1268848064395image=img_0_0_0 http://domain.com/serlimage?type=agraph2time=1268848064470image=img_0_0_0 can some please help me resolve this. THank you, -- View this message in context: http://old.nabble.com/two-graph-tp27933829p27933829.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Re porting from the Cloud?
Hi, I am new to Jasper so perhaps what I am asking is obvoius but I have the following scenario and want to know how to go about implementing it: 1. Hosted cloud computing commercial (not inhouse) application with monolithic secure database serving multiple companies written in Servoy. 2. Each company must only see their own data. 3. Must allow any user to report on data from our application 4. Users are able to customise their reports some how from the server. So, - How do they get to the report to customise? - How do they send the customisations back to the server? - Where do we store the customisations inluding logos etc? - What are the security implications? - Do they need to load iReports or something else locally to do the customisations or can we access something on the cloud for a secure rpeort customisation envuironment? - How do we pass over the database schema etc in order for them to customise the reports? - And finally, these users are not Jasper experts so I would ideally like to provide a canned , simplified environment for them to make these customisations. I would imagine the above to be a typical example of reporting issues being faced by any company hosting a multi-copany commercial application in the cloud that requires user customisable reporting. Hope someone can help. Cheers David Younger da...@theservicemanager.com +61403392363 -- View this message in context: http://old.nabble.com/Reporting-from-the-Cloud--tp27714545p27714545.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Problem with subreport
Hello! I have master report that contains only details band. In this band I put subreport, and when I generate subreport separatly it works fine and subreport fit whole page and page footer at bottom. When I generate master report, subreport footer doesn`t fit bottom page. How to fit subreport footer to the bottom of master report datails band? -- View this message in context: http://old.nabble.com/Problem-with-subreport-tp27685878p27685878.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Problem with subreport
Could you post the solution, please? Someone may need the answer, and posting keep things registered. Thanks, Davinir 2010/2/22 kapv pa...@kangin.org kapv wrote: Hello! I have master report that contains only details band. In this band I put subreport, and when I generate subreport separatly it works fine and subreport fit whole page and page footer at bottom. When I generate master report, subreport footer doesn`t fit bottom page. How to fit subreport footer to the bottom of master report datails band? Problem resolved! -- View this message in context: http://old.nabble.com/Problem-with-subreport-tp27685878p27686750.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] subreport detail band is empty
Hello. Creating a main report with a subreport, when compile in iReports 3.7.1 the subreport content is showed perfectly. However, if the main report is loaded through Tomcat Server, the subreport embeded report is not showed. Only showns header and footer bands, but not detail band. In the other side, if only the subreport (not embedded in main report) is loaded directly in tomcat server, the detail band is showed!. What could be ocurring about loading detail band' subreport if is (or not) embedded in main report? I think I don't pass JRDataSource object correctly in subreport datasourceexpression, but I don't know how. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] jasper_local time zone ..
My jasper reoprt prints GMT time ... How can I get localized time ?? -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Custom Components
The JasperReports user guide (see information on it at http://www.jaspersoft.com/jasperreports-ultimate-guide) contains an explanation of the barcode component in the form of a tutorial. Writing a custom component is indeed rather complicated. The best thing to do is to start from an existing component (like the barcode one), do some step-by-step debugging to understand what and when each part of the component implementation does and then start to implement your own component. Writing a plugin for iReport UI support is a different thing, I'm afraid I can't offer any information on that. Regards, Lucian Michi Doswald a scris: Hello, I'm trying to create reports with integrated wavedata (ECG curves) graphics. The charts available in jasper reports are not capable enough to display the ecg data the way I want it (at least it seems so). That's why I wanted to write my own "Custom Component" for jasperreports. I read that the Barcode component is also implemented as a Custom Component. And I saw that it should be possible to use such components in the iReport application by writing a NetBeans module. I already tried to figure out how to do it by looking at the Barcode and List source code in jasperreports as well as reading the jasperreport API (3.7.0). But its seems to be quite complicated to write such a custom component. Are there any tutorials, books or other documentation about that? I can't find much on the internet. any hints would be appreciated thx Michael -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] new to jasper
On Thu, Jan 21, 2010 at 12:42 AM, sonali_india amit.daund...@gmail.comwrote: hello friends, i am new to reports.and want to learn jasper report. please guide me how to start using jasper report. this book may be useful to u. Jasperreports 3.5 for Java Developers By David Heffelfinger -- Rajesh Pandian M http://identi.ca/mrprajesh -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Print detail multiple times
Hello, I have a simple table order(id,amount) and I want tot use this table to print orderlabels for shipment. I want to print a label for each package (amount), the question is how to do this. I am using a sql connection as resource for my report. Option 1: explode the resultset, I think this is a ugly solution Option 2: ?? I hope somebody has a logical solution to help me. Thanks in advance, Dencel -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] report is red/pink in the middle ?
i m using jasperreports-3.6.1. java version 1.6.0_16 on Ubuntu 9.10 i have created a PDF for bar chart report using database values i.e through query string. (using JasperReports 3.5 for Java Developers book) the report came good and the bars are fine but there is a red/pink color in the middle [1] ? (this makes the report very ugly). what could be problem ? can someone point me what could be the problem ? [1] http://picasaweb.google.com/mrpraj/Others#5417364454166558706 -- я ∆ Ĵ ξ ş Ћ http://mrprajesh.blogspot.com/ http://friendfeed.com/mrprajesh -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] urgent plz
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. -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How to dynamically set the background color of a field? Thanks.
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. -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[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-tp26405365p26405365.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Migrating to 3.6.1 from 3.1.4
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. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] I am a Beginner.I want some help
Hi everyone, Can anyone tell me the step by step procedure to install and run jasper reports from a web browser .I am using mysql and tomcat. Thanks in advance. -- View this message in context: http://old.nabble.com/I-am-a-Beginner.I-want-some-help-tp26274056p26274056.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Jasper Reports Beginner needs simple Clarification
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. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Error while trying to generate report from browser
Hi my name is Naresh.I am new to this forum.I was trying to generate a report
in PDF format from a web browser using jasper reports but am getting the
following error.
My url:-
http://localhost:8080/Demos/DbReportServlet
Myfile path:- C:\Tomcat\webapps\Demos\WEB-INF\classes\DbReportServlet.class
Error:-
javax.servlet.ServletException: Error allocating a servlet instance
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)
java.lang.NoClassDefFoundError: DbReportServlet (wrong name:
net/ensode/jasperbook/DbReportServlet)
java.lang.ClassLoader.defineClass1(Native Method)
java.lang.ClassLoader.defineClass(ClassLoader.java:621)
java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1850)
org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:890)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1354)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)
I used report1.jasper as the input file in the DbReportServlet.java file and
i compiled it and made changes in the web.xml file and also stored my class
file in Classes folder of web-inf.I did everything as mention in the
Jasperreports tutorials and wat saw in google searches.But still am gettin
this error.
Please let me know if am doin any mistakes in the code or anything else.
My code:-
package net.ensode.jasperbook;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.io.StringWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.HashMap;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.sf.jasperreports.engine.JasperRunManager;
public class DbReportServlet extends HttpServlet
{
protected void doGet(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException
{
Connection connection;
ServletOutputStream servletOutputStream =response.getOutputStream();
InputStream reportStream
=getServletConfig().getServletContext().getResourceAsStream(C:\\Jasper_Reports\\report1.jasper);
try
{
Class.forName(com.mysql.jdbc.Driver);
connection = DriverManager.getConnection
(jdbc:mysql://localhost:8080?user=dbuserpassword=secret);
JasperRunManager.runReportToPdfStream(reportStream,servletOutputStream, new
HashMap(), connection);
connection.close();
response.setContentType(application/pdf);
servletOutputStream.flush();
servletOutputStream.close();
}
catch (Exception e)
{
// display stack trace in the browser
StringWriter stringWriter = new StringWriter();
PrintWriter printWriter = new PrintWriter(stringWriter);
e.printStackTrace(printWriter);
response.setContentType(text/plain);
response.getOutputStream().print(stringWriter.toString());
}
}
}
Thanks in Advance.
--
View this message in context:
http://old.nabble.com/Error-while-trying-to-generate-report-from-browser-tp26215312p26215312.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Book for iReport
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. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Show Column Footer Only in Last Page
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_mahat...@yahoo.com] Sent: Wednesday, November 18, 2009 3:49 PM To: jasperreports-questions@lists.sourceforge.net 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Two JRDataSources in single report?
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 Vsquez Sez Gerente de Proyectos Altiuz | Neox Desarrollo Nueva Tajamar 555 Of. 802 Las Condes - Santiago Fonos 56 (2) 335 2461 / 203 6200 IBM Certified Advanced Application Developer Rational Application Developer for WebSphere Software IBM Certified Database Associate DB2 Universal Database Family -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Some urgent questions about display in excel format when large quantity of data
Dear everybody, I have some question about export in excel. As we all know, excel has its limitation in displyting data, about 6 lines, however, result of my query has more than 20 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. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Default oracle date format in ireport
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@gmail.com]
Sent: 13 November 2009 02:30
To: jasperreports-questions@lists.sourceforge.net
Subject: Re: [jasperreports-questions] Default oracle date format in
ireport
John Dunn jd...@sefas.com 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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
--
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Default oracle date format in ireport
John Dunn jd...@sefas.com 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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
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 this email
-Original Message-
From: David Bolen [mailto:db3l@gmail.com]
Sent: 13 November 2009 09:09
To: jasperreports-questions@lists.sourceforge.net
Subject: Re: [jasperreports-questions] Default oracle date format in
ireport
John Dunn jd...@sefas.com 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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
--
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Default oracle date format in ireport
Hi John, Possible we can change it in the report design Thanks Suresh From: John Dunn jd...@sefas.com To: jasperreports-questions@lists.sourceforge.net 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 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/-- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
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 2009 14:35 To: John Dunn; jasperreports-questions@lists.sourceforge.net Subject: Re: [jasperreports-questions] Default oracle date format in ireport Hi John, Possible we can change it in the report design Thanks Suresh From: John Dunn jd...@sefas.com To: jasperreports-questions@lists.sourceforge.net 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 www.sefas.com 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.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Applet based Jasper Report!
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. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] how to escape special characters in jasperreports ?
I want to escape special characters like :- é, â, è, ^, @ in jasper reports, so is there any way we can escape this characters ? -- View this message in context: http://www.nabble.com/how-to-escape-special-characters-in-jasperreports---tp25803010p25803010.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] how to wrap report for word output in jasper report?
Hi, I have report where report width is more than 2000px; it is working fine with pdf and excel output but when we export for word it is showing 550px; report only other part we are not able to see. We have one report which contains ... abcdefghijklmnopqrstuvwxyz when we export for excel or pdf it's working fine but when we export for word it's coming like abcdefg other parts are not visible. I am exporting word report with JRRtfExporter object. is there any property i have to set to see full report or any suggestions ? we are using jasper reports 1.2.0 Any Help Appreciated ... -- View this message in context: http://www.nabble.com/how-to-wrap-report-for-word-output-in-jasper-report--tp25786992p25786992.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Jasper Reports Beginner needs simple Clarification
Same Question Some Help will be Appreciated -- View this message in context: http://www.nabble.com/Jasper-Reports-Beginner-needs-simple-Clarification-tp25693053p25693111.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] java.lang.NoSuchMethodError: com.opensymphony.xwork2.Action exception
Seems to be a version conflict. Check different JAR versions. Dont add JARs with results Class Repetition Like adding CGLIB and ASM Jar files will lead to a problem as CGLIB already has ASM Classes -- View this message in context: http://www.nabble.com/java.lang.NoSuchMethodError%3A-com.opensymphony.xwork2.Action-exception-tp25661313p25693139.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Incompatible java.lang.String value assigned to parameter importDate
I'm a new user trying to pass a date as a parameter receiving
this Incompatible java.lang.String error from a groovy .gsp page
Here's the .gsp fragment where importDate is a groovy Date:
g:jasperReport jasper=reportSec3 format=HTML name=Securities by
Class
input type=hidden name=importDate
value=${holdingImportDateInstance.importDate}/
/g:jasperReport
and the jrxml
jasperReport xmlns=http://jasperreports.sourceforge.net/jasperreports;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://jasperreports.sourceforge.net/jasperreports
http://jasperreports.sourceforge.net/xsd/jasperreport.xsd;
name=Sec3 language=groovy pageWidth=595 pageHeight=842
columnWidth=535 leftMargin=20 rightMargin=20 topMargin=20
bottomMargin=20
parameter name=importDate class=java.util.Date
defaultValueExpression![CDATA[]]/defaultValueExpression
/parameter
queryString
![CDATA[SELECT
holding.`symbol_id` AS holding_symbol_id,
holding.`market_value` AS holding_market_value,
security.`asset_class` AS security_asset_class,
security.`symbol` AS security_symbol,
holding_import_date.`import_date` AS holding_import_date_import_date,
security.`name` AS security_name,
holding.`date_id` AS holding_date_id,
holding_import_date.`id` AS holding_import_date_id
FROM
`security` security INNER JOIN `holding` holding ON security.`id` =
holding.`symbol_id`
INNER JOIN `holding_import_date` holding_import_date ON holding.`date_id`
= holding_import_date.`id`
WHERE
holding_import_date.`import_date` = $P{importDate}
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Incompatible java.lang.String value assigned to parameter importDate
I'm a new ireport user trying to pass a date as a parameter receiving this
Incompatible java.lang.String error from a groovy .gsp page
Here's the .gsp fragment where importDate is a groovy Date:
g:jasperReport jasper=reportSec3 format=HTML name=Securities by
Class
input type=hidden name=importDate
value=${holdingImportDateInstance.importDate}/
/g:jasperReport
and the jrxml
jasperReport xmlns=http://jasperreports.sourceforge.net/jasperreports;
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://jasperreports.sourceforge.net/jasperreports
http://jasperreports.sourceforge.net/xsd/jasperreport.xsd; name=Sec3
language=groovy pageWidth=595 pageHeight=842 columnWidth=535
leftMargin=20 rightMargin=20 topMargin=20 bottomMargin=20
parameter name=importDate class=java.util.Date
defaultValueExpression![CDATA[]]/defaultValueExpression
/parameter
queryString
![CDATA[SELECT
holding.`symbol_id` AS holding_symbol_id,
holding.`market_value` AS holding_market_value,
security.`asset_class` AS security_asset_class,
security.`symbol` AS security_symbol,
holding_import_date.`import_date` AS holding_import_date_import_date,
security.`name` AS security_name,
holding.`date_id` AS holding_date_id,
holding_import_date.`id` AS holding_import_date_id
FROM
`security` security INNER JOIN `holding` holding ON security.`id` =
holding.`symbol_id`
INNER JOIN `holding_import_date` holding_import_date ON
holding.`date_id` = holding_import_date.`id`
WHERE
holding_import_date.`import_date` = $P{importDate}
--
View this message in context:
http://www.nabble.com/Incompatible-java.lang.String-value-assigned-to-parameter-importDate-tp25710271p25710271.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Java Beans set Datasource
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. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Multiple Object in DataSource Collection
private JRBeanCollectionDataSource dataSource;
private MapString, Object parameters = new HashMapString, Object();
CollectionReportBean BeanList = createBeans();
dataSource = new JRBeanCollectionDataSource(BeanList);
//use parameters if the value doesn't change i.e.customer
name,account number,etc.
parameters.put(PROJECT_ID, project.projectID);
CollectionReportBeans createBeans(resultSet){
ListReportBeanList result = new ArrayListReportBeanList();
foreach (value in the resultSet ) {
ResultsReportBean Bean = new ResultsReportBean();
Bean.setType(Project); //i.e. prjoect or coverage
Bean.setId(Id);
etc, etc, etc
}
result.addAll(Bean);
JasperReport jasperReport =
JasperCompileManager.compileReport(templateFilename);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,
parameters , dataSource);
JasperExportManager.exportReportToPdfFile(jasperPrint, reportFilename);
Thank you very much for your reply.
I dont expect spoon feeding. I try to kick start with the piece of code that
you provided.
--
View this message in context:
http://www.nabble.com/Multiple-Object-in-DataSource-Collection-tp25816344p25837848.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Multiple Object in DataSource Collection
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. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Multiple Object in DataSource Collection
Hello All, I need to use two objects for generating reports with JRXML dataCollection.add(project); dataCollection.add(coverage) I use JRBeanCollectionDataSource ds = new JRBeanCollectionDataSource(dataCollection); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, ds); this works fine when i use only one object. Say Project. If i use two objects. I get error in the JRXML (As field not found) How to solve this problem. I need to get values from both the objects Some help will be declared great -- View this message in context: http://www.nabble.com/Multiple-Object-in-DataSource-Collection-tp25816344p25816344.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Multiple Object in DataSource Collection
Without knowing much about your code or system I would say you need a subreport to use 2 datasources. However if the data you need is in 2 separate databases then why not use a join sql statement? The Query is session.createQuery(from jasperReport.Project P,jasperReport.Coverage C where P.projectId = 1 and C.coverageId = 1) Corresponding SQL Query:select project0_.PROJECT_ID as PROJECT1_1_0_, coverage1_.COVERAGE_ID as COVERAGE1_0_1_, project0_.PROJECT_NAME as PROJECT2_1_0_, coverage1_.COVERAGE_NAME as COVERAGE2_0_1_ from PROJECT project0_, COVERAGE coverage1_ where project0_.PROJECT_ID=1 and coverage1_.COVERAGE_ID=1 This returns two objects. Project and Coverage. Project Attributes: projectId projectName Coverage Attributes: coverageId coverageName projectFk(Foreign key - project.projectId) Now in the JRXML field name = projectId ... is accepted field name = coverageId... is showing error as undefined property Is there any wat to call the attributes separately like project.ProjectId coverage.coverageId?? -- View this message in context: http://www.nabble.com/Multiple-Object-in-DataSource-Collection-tp25816344p25818786.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Subreport positioning
Note - I am very new to jasper reports so I am apologetic if this message is obvious to most. I am working on a jasper report that models an invoice. The report was initially created using a data source that represented the entire set of data for the invoice. It was granular down to the invoice item level, and each row in the data source would contain information such as the company's address, phone, customer's name, shipping address, subtotal information, as well as information related to the actual invoice items. My initial inkling was that we should model this report as a series of sub-reports. Picture the company logo in the top left, company contact details in the top right, then the customer details in the middle left, with order details in the middle right, finally the set of invoice items, and then the subtotal information. The main motivation here was to create a series of subreports that could be used on various report. It also allowed me to create a more specific datasource query to bind to the various sub-reports which would avoid cardinality issues as well as aiding in making it more testable. Question #1: Is this a reasonable approach or is there a better way to model multiple queries to the same final report. Question #2: The trouble I am having is actually laying out the sub-reports so that they flow from the one to the other without creating empty space on the final report. What properties should I be setting? Picture a report that has 3 sub-reports in a band where the middle sub-report actually contains no data. I would want sub-report #1 and #3 to have no space between them (from #2). Moreover, if #2 has a lot of data I would like to have it auto-expand and not cause #3's data to overlap. Thank you very much! Bob -- View this message in context: http://www.nabble.com/Subreport-positioning-tp25530927p25530927.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] IsBlankWhenNull issue when export to HTML in Spring framework
Hi, Does anyone know why when I set the attribute IsBlankWhenNull set to true, it also removes the drawing (rectangular box) of those fields with null values when export to html? my environment is in Spring MVC. It works fine when exporting to PDF, Excel, and also works fine when I use iReport tool to display it in html. Thanks in advance. Bob -- View this message in context: http://www.nabble.com/IsBlankWhenNull-issue-when-export-to-HTML-in-Spring-framework-tp25615237p25615237.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] java.lang.NoSuchMethodError: com.opensymphony.xwork2.Action exception
Hi i am creating a Jasper Reports. i am getting a java.lang.NoSuchMethodError: com.opensymphony.xwork2.Action.get(Ljava/lang/String;)Ljava/lang/Object; exception i am using xworks-2.1.1.jar Jdk is 6.0(1.6) Please help me to solve this issue Stack Trace message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: Filter execution threw an exception root cause java.lang.NoSuchMethodError: com.opensymphony.xwork2.ActionContext.get(Ljava/lang/String;)Ljava/lang/Object; org.apache.struts2.views.jasperreports.JasperReportsResult.doExecute(JasperRepo rtsResult.java:245) org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.j ava:186) com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvo cation.java:355) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:259) com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(Defa ultWorkflowInterceptor.java:141) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFil terInterceptor.java:86) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:230) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:229) com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.ja va:456) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:227) com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationI nterceptor.java:248) org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doInt ercept(AnnotationValidationInterceptor.java:49) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFil terInterceptor.java:86) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:230) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:229) com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.ja va:456) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:227) com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(Conver sionErrorInterceptor.java:124) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:230) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:229) com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.ja va:456) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:227) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameter sInterceptor.java:170) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFil terInterceptor.java:86) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:230) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:229) com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.ja va:456) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:227) com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameter sInterceptor.java:170) com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFil terInterceptor.java:86) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:230) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:229) com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.ja va:456) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:227) com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(Stati cParametersInterceptor.java:104) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:230) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:229) com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.ja va:456) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:227) org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxIntercepto r.java:84) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:230) com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvo cation.java:229) com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.ja va:456) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation. java:227) org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterc eptor.java:208)
[jasperreports-questions] Graphical report not working with jasper report
Hi,
I am new to jasper report. I created two reports(one tabular and one
graphical) with ireport. I am using jrxml file (generated by ireport) and
executing that with my java code. The tabular report is running fine but
while i try to run graphical report its throwing an exception -
Could not create the report org.xml.sax.SAXParseException:
cvc-complex-type.2.4.a: Invalid content was found starting with element
'itemLabel'. One of
'{http://jasperreports.sourceforge.net/jasperreports:categoryAxisLabelExpression,
http://jasperreports.sourceforge.net/jasperreports:categoryAxisFormat,
http://jasperreports.sourceforge.net/jasperreports:valueAxisLabelExpression,
http://jasperreports.sourceforge.net/jasperreports:valueAxisFormat,
http://jasperreports.sourceforge.net/jasperreports:domainAxisMinValueExpression,
http://jasperreports.sourceforge.net/jasperreports:domainAxisMaxValueExpression,
http://jasperreports.sourceforge.net/jasperreports:rangeAxisMinValueExpression,
http://jasperreports.sourceforge.net/jasperreports:rangeAxisMaxValueExpression}'
is expected. org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid
content was found starting with element 'itemLabel'. One of
'{http://jasperreports.sourceforge.net/jasperreports:categoryAxisLabelExpression,
http://jasperreports.sourceforge.net/jasperreports:categoryAxisFormat,
http://jasperreports.sourceforge.net/jasperreports:valueAxisLabelExpression,
http://jasperreports.sourceforge.net/jasperreports:valueAxisFormat,
http://jasperreports.sourceforge.net/jasperreports:domainAxisMinValueExpression,
http://jasperreports.sourceforge.net/jasperreports:domainAxisMaxValueExpression,
http://jasperreports.sourceforge.net/jasperreports:rangeAxisMinValueExpression,
http://jasperreports.sourceforge.net/jasperreports:rangeAxisMaxValueExpression}'
is expected.
Please help me in resolving this issue. I think some jars are missing.
Thanks
--
View this message in context:
http://www.nabble.com/Graphical-report-not-working-with-jasper-report-tp25466341p25466341.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.
--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] values not coming while running ireport
I have writen a function . When i run that function in orcale backend , its giving proper values from data base. But when i run that function from ireport , ireprot does gives any values .A blank page sis displayed -- View this message in context: http://www.nabble.com/values-not-coming-while-running-ireport-tp25414456p25414456.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Connect bean class in ireport
Daer sir I am prkash from india, I have developing web project using struts2 and jsaper report. I have doubt in jasper report, how to connect bean class in jasper report with examples.. any one know pls help me immediately Thanks Regards Prakash D -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Connect bean class in ireport
Daer sir I am prkash from india, I have developing web project using struts2 and jsaper report. I have doubt in jasper report, how to connect bean class in jasper report with examples.. any one know pls help me immediately Thanks Regards Prakash D Thanks Regards Prakash D -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] List of parameters to PDF
Hi, I am new to jasper reports. I am passing parameters as following. ListString courseModules = new ArrayListString(); ListString marks = new ArrayListString(); courseModules.add(spoken english); courseModules.add(Medical Transcription); marks.add(20); marks.add(30); Map model = new HashMap(); model.put(courseModules, courseModules); model.put(“marks”, marks); I use ResourceBundleViewResolver. In .jrxml, I map parameters as parameter name=courseModules class=java.util.List/ parameter name=marks class=java.util.List/ I got printed as [spoken English, Medical Transcription] [20, 30] But, my requirement is, I have to print like Course Mark Spoken English 30 Medical Transcription 40 I don’t know how to iterate the elements in the list in jrxml or any other solution will be good as well. Please, help me Thanks Vishnu -- View this message in context: http://www.nabble.com/List-of-parameters-to-PDF-tp25041091p25041091.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How to dynamically set the background color of a field? Thanks.
Hello, I'm also interested in this issue. Have You found any solution? Thanks, Taras 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://www.nabble.com/How-to-dynamically-set-the-background-color-of-a-field--Thanks.-tp22285675p25024544.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Internationalization Code for Jasper Reports
Hi, We are facing problem in integrating internationalization with jasper reports. Please tell us how to display pdf jasper reports in other Indian locale languages how to access resource bundle in jrxml file and .java using jasper api. Waiting for your reply.. Thanks, Farzana -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] How to open jasperviewer at client side
Hi all! Using jasper report I develop a project with struts 1.2 Frame work ; My project generate a PDF report based on a specified database. The problem is it open the PDF file on the Server Terminal(side) i.e (http://localhost:8084/GeoTrak/getdetailReportPage.do) but not on the client Terminal(side) i.e (http://192.168.100.35:8084/GeoTrak/getdetailReportPage.do). Does anyone knows how to resolve this situation ? Best regards Ranjan Code ……Struts Action class.:……….. String fullPath=getServlet().getServletContext().getRealPath(reports/+pf.getReportList()+.jasper); JPrint=JasperFillManager.fillReport(fullPath,params,con); JasperViewer.viewReport(JPrint,true); con.close(); -- View this message in context: http://www.nabble.com/Error-with-JasperViewer-tp18732980p24733282.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Problem, when compiling .jrxml files
I have a well working program, which uses JasperReports. It uses JRBeanCollectionDataSource(List items); to populate the rows with data, but if I compile the .jrxml file either with JasperCompileManager.compileToFile() or with iReports I see only parameters populated without rows. Does anyone have had such a problem. I don't recieive any errors or exeptions. -- View this message in context: http://www.nabble.com/Problem%2C-when-compiling-.jrxml-files-tp24696681p24696681.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] how to open Jasper Report on the client Ternminal
I am Using jasper report I develop a project with struts 1.2 Frame work ; My project generate a PDF report based on a specified database. The problem is it open the PDF file on the Server Terminal(side) i.e (http://localhost:8084/GeoTrak/getdetailReportPage.do) but not on the client Terminal(side) i.e (http://192.168.100.35:8084/GeoTrak/getdetailReportPage.do). Does anyone knows how to resolve this situation ? Best regards Ranjan Code ……Struts Action class.:……….. String fullPath=getServlet().getServletContext().getRealPath(reports/+pf.getReportList()+.jasper); JPrint=JasperFillManager.fillReport(fullPath,params,con); JasperViewer.viewReport(JPrint,true); con.close(); _ Missed any of the IPL matches ? Catch a recap of all the action on MSN Videos http://msnvideos.in/iplt20/msnvideoplayer.aspx-- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] search a section within the PDF
I have a requirement where i have to create a PDF document which will have several chapters and sections. The user of the document should be able to search for a keyword within a given section and not in the entire document. Is there any way this can be implemented in Jasper by passing some parameters to the Jasper runtime or any other possible way. Please let me know -Thanks Mohan -- View this message in context: http://www.nabble.com/search-a-section-within-the-PDF-tp24702622p24702622.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Changing font size of textField dynamically
Hello all,
I am using JasperReports 3.5.2 with iReport-nb 3.5.2 and I have the
following need :
I have a textField linked up to a variable expression $V{C2_EXP} and I would
like to change the size of the font dynamically depending on the contents of
this field. In other words if the expression is 5 characters long, I want
size 5, if it's 10 characters long, I want size 4, etc...
Is there any possibility to do this with JasperReports ? I thought perhaps
of putting a variable expression as the size of the font, but that doesn't
seem to be supported.
Any ideas ?
Thanks,
Raphael Neve
--
View this message in context:
http://www.nabble.com/Changing-font-size-of-textField-dynamically-tp24566298p24566298.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.
--
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Set theme to Jasper report
Hi everyone, I am new to Jasper reports. I have done quite a bit of research on this tool and found that this is the tool which most suffices my requirements. I need to use it in my project and have to use the Jasper APIs. But I need some information- I need to provide ability to the user set a theme to his reports- For eg- he may wish to set some logo onto the report while designing and that should be visible when he runs the report. Is there any way I can do this? Through the API I have got to know that there is a way to apply theme to chart (though have not tried it out yet), but my requirement is to apply it to the entire report and not to the chart alone. Any help will be greatly appreciated. Thanks in advance -- View this message in context: http://www.nabble.com/Set-theme-to-Jasper-report-tp24392854p24392854.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] want GUJARATIin pdf as a output
Please somebody remove me from the Jasperreports mail list! There should be a single click unsubscribe link at the end of the email! RKVS Raman wrote: Have a look at http://rkvsraman.blogspot.com/2009/05/indic-scripts-and-jasper-reports.html or http://202.141.136.157/bharateeyaoo/jasper.shtml Best Regards -Raman --- RKVS Raman BOSS Resource http://www.bosslinux.in http://rkvsraman.blogspot.com On Mon, May 18, 2009 at 10:43 PM, taylorm10taylor...@gmail.com wrote: there are a few components you will need to implement, for example: 1) http://static.springframework.org/spring/docs/2.0.x/reference/beans.html#context-functionality-messagesource 2) Spring LocaleResolver 3) Spring LocaleChangeInterceptor - depends on which Resolver you use 4) Jasper Templates will need a reference to the resource bundle you use in 1) void_void wrote: i have integrated springMVC and jasper.. it is working perfectly fine with english.. i want to dynamically change language..to either english,gujarati or hindi.. how to proceed? -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] How to set a variable value permanently
Hi, I am trying to set a value of a field for the first row to a variable and display it throughout the report. Is this possible ? I've set the variable's Reset Type to None but the containing textfield evaluates the variable every time hence changes its value for different rows. Any help is appreciated. Btw, I am using JaserAssistance 2.2.0 for JasperReport 1.2.4. -- View this message in context: http://www.nabble.com/How-to-set-a-variable-value-permanently-tp24064679p24064679.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] jasper report doubl
Hi
I want to pri nt like this in the footer of the jasper report
Page 1 of 1 for page 1
Page 1 of 2 for page 2
If total pages are 2
But if total pages are 1 then the footer should be empty it should not say page
1 of 1
How do I do this
Thanks Regards
Joseph
DISCLAIMER
The content of this email and any attachments ('email') is confidential, may be
privileged, subject to copyright and may be read and used only by the intended
recipient. If you are not the intended recipient please notify us by return
email or telephone and erase all copies and do not disclose the email or any
part of it to any person. Email transmission cannot be guaranteed to be secure,
or error free as information could be intercepted, corrupted, lost or destroyed
as a result of the transmission process. The sender, therefore, does not accept
liability for any errors, omissions, viruses or delay in transmission as a
result of this mail. We monitor email communications through our networks for
regulatory compliance purposes and to protect our clients, employees and
business. Opinions, conclusions, and other information in this message that do
not relate to the official business of NIIT Technologies Ltd. or its
affiliate(s) shall be understood to be neither given nor endorsed by NIIT
Technologies Ltd. or its affiliate(s).
--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Error in JasperPrintManager.printReport
Hi, Whenever I am giving true in JasperPrintManager.printReport(jasperPrint, true) it is throwing the error net.sf.jasperreports.engine.JRException: Error printing report. But if I am giving it as JasperPrintManager.printReport(jasperPrint, false) it is working fine. Am I missing any library for this? Regards, Sreekanth -- View this message in context: http://www.nabble.com/Error-in-JasperPrintManager.printReport-tp23775775p23775775.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] How about loop a sub report?
Hi, I may need to put several sub reports in the detail section in the master report. So the sub reports will get loaded many times. Will this cause significant performance issues? Does jasper cache data source for report in this case? My case: User's data are scattered in 5 tables and I need to put those data together under a particular user. I don't want to use UNION because HQL doesn't support it. In addition, Union 5 tables may result in a huge SQL. I have to use one sub report for each table and iterate users in master report and for each user iterate all sub reports to display data relevant to that user. Is this viable or any other solution? Any comment is appreciated. -- View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847692p23847692.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Problem with Cross Tab multiple columns
Hello, I think the way that cross tab works with multi-columns is: It builds like a hierarchy of columns. I want a little different implementation. Lets say for example I have an ArrayList of all the accounts in a bank. Each Account object has the following fields: holderName(String), amountInSavingsAccount (int) and amountInCheckingAccoun(int). I would want to loop through list using a Crosstab in the following fashion: Amount in Checking Account Amount in Savings Account John Doe 10 20 Java Doe 10 20 Jane Doe 10 20 Jack Doe 10 20 Total 50 100 The problem is, with multiple unrelated columns in an object, I'm not sure how to configure them in a crosstab in iReports. Any suggestions/inputs? Thanks in anticipation, Andy. -- View this message in context: http://www.nabble.com/Problem-with-Cross-Tab-multiple-columns-tp23744832p23744832.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] bug in Helloworld program
hi everybody
This is srikanth.
I have a bug in hellowold program.I am new to jasper reports.I created
helloworld.jar file.But when i execting below code i got blank page.its
not displaying the 'string = helloworld'.Please help me the
jasperreports .
?php
require_once(http://127.0.0.1:8080/java/Java.inc;);
java_require('http://127.0.0.1:8080/test/helloworld.jar');
$myObj = new Java('helloworld');
// display Hello World
echo (String) $myObj-getHelloWorld();
?
Thanks in advance
Regards
Srikanth
--
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] jasper reports performance issue
Hi, whenever the issue came with the jasper, if any graphical elements you are using in your reports, it will take some time to generate the report. But if huge data to be displayed on the report, the issue goes with the time taken to fetch data from database. So optimise the sql query for your report which can help you out. Regards, Sadanand rajole Pune, AnilaBhargavi.Vankamamidi wrote: Hi, When huge data is to be filled into the jasper report, it is taking much time for the report generation. (It took 19mins to generate one of my report.) Please help me with a solution where I can optimize this filling process of the jasper report, so that reports can be generated quickly? Please provide with any source code if available. Regards, V. Anila Bhargavi|172793 Cognizant Technology Solutions| Hyderabad Mobile: 9849908536 This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H ___ 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/jasper-reports-performance-issue-tp22306858p23882944.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] want GUJARATIin pdf as a output
there are a few components you will need to implement, for example: 1) http://static.springframework.org/spring/docs/2.0.x/reference/beans.html#context-functionality-messagesource 2) Spring LocaleResolver 3) Spring LocaleChangeInterceptor - depends on which Resolver you use 4) Jasper Templates will need a reference to the resource bundle you use in 1) void_void wrote: i have integrated springMVC and jasper.. it is working perfectly fine with english.. i want to dynamically change language..to either english,gujarati or hindi.. how to proceed? -- View this message in context: http://www.nabble.com/want-GUJARATIin-pdf-as-a-output-tp23594551p23601699.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How about loop a sub report?
Hi, It works! All your posts are of great help. Thanks a ton! David Bolen-2 wrote: Peter Jin jinyup...@gmail.com writes: Let's take a look at activity1 and activity2. If activity1 has more records than activity2, some of the records of activity2 will be joined multiple times. This is incorrect. Does it make sense? Drat, yes, dumb error (and obviously too quick 'n dirty test data) on my part. I guess I let having just aggregate functions lull me into thinking only rows were getting joined, but obviously the aggregates are only applied after the join. Sorry about that. Let's try again - here's a possible replacement query that I believe yields the correct results: select * from ( SELECTusers.id, users.name, a_1.a1_cnt, a_1.a1_total, a_2.a2_cnt, a_2.a2_total, a_3.a3_cnt, a_3.a3_total FROM users LEFT JOIN ( SELECT id, name, count(a1.distance) as a1_cnt, sum(a1.distance) as a1_total FROM users JOIN activity1 a1 on users.id = a1.user_id GROUP BY id, name ) as a_1 on users.id = a_1.id LEFT JOIN ( SELECT id, name, count(a2.hits) as a2_cnt, sum(a2.hits) as a2_total FROM users JOIN activity2 a2 on users.id = a2.user_id GROUP BY id, name ) as a_2 on users.id = a_2.id LEFT JOIN ( SELECT id, name, count(a3.weight) as a3_cnt, sum(a3.weight) as a3_total FROM users JOIN activity3 a3 on users.id = a3.user_id GROUP BY id, name ) as a_3 on users.id = a_3.id ) as result ORDER BY id, name; The nested sub-selects are using an inner join, thus the final table will have NULLs for both *_cnt and *_total if there are no matching records for that activity. You could change it to a left join (like the parent select) to get 0 in the *_cnt columns, but there would still be NULLs in the *_total columns. If your report code would rather not deal with NULLs, I'd probably just coalesce() those columns as needed in the top level select. Depending on the sheer number of activities this could get more complicated (though again, you can hide a lot behind views and/or server side functions), but it still has the database server doing the bulk of the aggregation so should be more efficient than looping over the individual per-activity queries at the reporting level. -- David -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ 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/How-about-loop-a-sub-report--tp23847733p23899241.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How about loop a sub report?
Hi David, Thanks for your reply. Union is ok, but seems there are issues with Join. SELECTid, name, count(a1.distance) as a1_cnt, sum(a1.distance) as a1_total, count(a2.hits) as a2_cnt, sum(a2.hits) as a2_total, count(a3.weight) as a3_cnt, sum(a3.weight) as a3_total FROM users LEFT JOIN activity1 a1 on users.id = a1.user_id LEFT JOIN activity2 a2 on users.id = a2.user_id LEFT JOIN activity3 a3 on users.id = a3.user_id GROUP BY id, name; Let's take a look at activity1 and activity2. If activity1 has more records than activity2, some of the records of activity2 will be joined multiple times. This is incorrect. Does it make sense? David Bolen-2 wrote: Peter Jin jinyup...@gmail.com writes: We have an audit system which uses separate tables with similar structure to store different kinds of activities for a user. We want to report the number of activities per activity type per user. Still sounds pretty standard in terms of database schema. Can I assume that these separate activity tables have some field or unique key that correlates back to a user table or table containing per-user information? If so, then unless the tables are stored in separate database servers, it sounds like you just want to join those tables as part of the primary query without much hassle. Dumb example - you have a set of users, who can get rows added to one of three activity tables, related to three activities that have different metrics. Each row in an activity table is a single instance of that user performing that activity: users id integer primary key name text activity1 user_id integer -- foreign key references users(id) distance integer activity2 user_id integer -- foreign key references users(id) hits integer activity3 user_id integer -- foreign key references users(id) weight integer (The join will work without the database having explicit foreign key references but they should be there for referential integrity if the activity tables do have entries for users. For performance you should also ensure that users.id is indexed at a minimum). Then, a query like the following: SELECTid, name, count(a1.distance) as a1_cnt, sum(a1.distance) as a1_total, count(a2.hits) as a2_cnt, sum(a2.hits) as a2_total, count(a3.weight) as a3_cnt, sum(a3.weight) as a3_total FROM users LEFT JOIN activity1 a1 on users.id = a1.user_id LEFT JOIN activity2 a2 on users.id = a2.user_id LEFT JOIN activity3 a3 on users.id = a3.user_id GROUP BY id, name; would produce a result set looking like: id name a1_cnt a1_total a2_cnt a2_total a3_cnt a3_total 1User 1 ## ## ## 2User 2 ## ## ## ... Feed that into a JasperReports report designed for grouping by id/user and then you have access to all of the total information in a single detail line for that user, to be presented in the per-user section of that report. Now if you're looking for individual detail lines for each activity for each user, then I think your original thought of a UNION query was on the right track, although you're still joining within the individual components of the UNION to link the user to the activity. For example: SELECT * from ( SELECTid, name, 'activity1' as activity, count(a.distance) as count, sum(a.distance) as total FROM users LEFT JOIN a1 a on users.id = a.user_id GROUP BY id, name, activity UNION SELECTid, name, 'activity2' as activity, count(a.hits) as count, sum(a.hits) as total FROM users LEFT JOIN a2 a on users.id = a.user_id GROUP BY id, name, activity UNION SELECTid, name, 'activity3' as activity, count(a.weight) as count, sum(a.weight) as total FROM users LEFT JOIN a3 a on users.id = a.user_id GROUP BY id, name, activity ) as data ORDER by id, name, activity; which would result in a result set like: id nameactivitycounttotal 1 User 1 activity1## ### 1 User 1 activity2## ### 1 User 1 activity3## ### 2 User 2 activity1## ### 2 User 2 activity2## ### 2 User 2 activity3## ### which I think would work fine for Jasper to perform nested groupings on it, first by id/name and then by activity. I know you mentioned HQL not supporting a UNION, but JasperReport can make a direct SQL query to the underlying data, so I'm not sure that HQL needs to be involved. Also, you mentioned being concerned
Re: [jasperreports-questions] How about loop a sub report?
We have an audit system which uses separate tables with similar structure to store different kinds of activities for a user. We want to report the number of activities per activity type per user. David Bolen-2 wrote: Peter Jin jinyup...@gmail.com writes: Grouping can not solve my issue because it works on one data source only. In my case, data for a user scattered in 5 tables. UNION might be a way to combine all tables to a data source, but I can not use it either (explained in the first post). any thoughts? It's still somewhat unclear without knowing more about your table structure, but if you just mean that you have a reasonably normalized schema where the relevant information is stored in several tables with appropriate foreign key relationships (this can be true even if normal access is controlled by an ORM like Hibernate), is there a reason your report query can't just join the relevant tables together, grouping the result by user? If you mean 5 completely distinct data sources (e.g., separate databases), then another thought (if you have control of the code rendering the report) might be to implement a custom data source that itself performs the integration from the multiple data sources, even if via 5 distinct queries. From the Jasper engine's perspective it would still be utilized as a single data source for the report. -- David -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ 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/How-about-loop-a-sub-report--tp23847733p23865240.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How about loop a sub report?
Peter Jin jinyup...@gmail.com writes: We have an audit system which uses separate tables with similar structure to store different kinds of activities for a user. We want to report the number of activities per activity type per user. Still sounds pretty standard in terms of database schema. Can I assume that these separate activity tables have some field or unique key that correlates back to a user table or table containing per-user information? If so, then unless the tables are stored in separate database servers, it sounds like you just want to join those tables as part of the primary query without much hassle. Dumb example - you have a set of users, who can get rows added to one of three activity tables, related to three activities that have different metrics. Each row in an activity table is a single instance of that user performing that activity: users id integer primary key name text activity1 user_id integer -- foreign key references users(id) distance integer activity2 user_id integer -- foreign key references users(id) hits integer activity3 user_id integer -- foreign key references users(id) weight integer (The join will work without the database having explicit foreign key references but they should be there for referential integrity if the activity tables do have entries for users. For performance you should also ensure that users.id is indexed at a minimum). Then, a query like the following: SELECTid, name, count(a1.distance) as a1_cnt, sum(a1.distance) as a1_total, count(a2.hits) as a2_cnt, sum(a2.hits) as a2_total, count(a3.weight) as a3_cnt, sum(a3.weight) as a3_total FROM users LEFT JOIN activity1 a1 on users.id = a1.user_id LEFT JOIN activity2 a2 on users.id = a2.user_id LEFT JOIN activity3 a3 on users.id = a3.user_id GROUP BY id, name; would produce a result set looking like: id name a1_cnt a1_total a2_cnt a2_total a3_cnt a3_total 1User 1 ## ## ## 2User 2 ## ## ## ... Feed that into a JasperReports report designed for grouping by id/user and then you have access to all of the total information in a single detail line for that user, to be presented in the per-user section of that report. Now if you're looking for individual detail lines for each activity for each user, then I think your original thought of a UNION query was on the right track, although you're still joining within the individual components of the UNION to link the user to the activity. For example: SELECT * from ( SELECTid, name, 'activity1' as activity, count(a.distance) as count, sum(a.distance) as total FROM users LEFT JOIN a1 a on users.id = a.user_id GROUP BY id, name, activity UNION SELECTid, name, 'activity2' as activity, count(a.hits) as count, sum(a.hits) as total FROM users LEFT JOIN a2 a on users.id = a.user_id GROUP BY id, name, activity UNION SELECTid, name, 'activity3' as activity, count(a.weight) as count, sum(a.weight) as total FROM users LEFT JOIN a3 a on users.id = a.user_id GROUP BY id, name, activity ) as data ORDER by id, name, activity; which would result in a result set like: id nameactivitycounttotal 1 User 1 activity1## ### 1 User 1 activity2## ### 1 User 1 activity3## ### 2 User 2 activity1## ### 2 User 2 activity2## ### 2 User 2 activity3## ### which I think would work fine for Jasper to perform nested groupings on it, first by id/name and then by activity. I know you mentioned HQL not supporting a UNION, but JasperReport can make a direct SQL query to the underlying data, so I'm not sure that HQL needs to be involved. Also, you mentioned being concerned with the size of the data set, but as you can see here, you'll only get one summary row per user, per activity, so I'm not sure how the data set can be any smaller (even via a mechanism other than UNION) and still provide you with per-activity row data for display in the report. Note that if the activity tables have columns for a name for the activity you could select that in lieu of the static string, though if there's any chance for overlap you'll then want a UNION ALL instead. Nesting the query and applying an overall ordering helps ensure that you get the sequence in an appropriate order for reporting, since otherwise an engine might produce an arbitrary ordering. Or, if the per-user section of the report is just supposed to show a row per activity with total values (e.g., just what this query gives), then there's no need to have a
[jasperreports-questions] How about loop a sub report?
Hi, I may need to put several sub reports in the detail section in the master report. So the sub reports will get loaded many times. Will this cause significant performance issues? Does jasper cache data source for report in this case? My case: User's data are scattered in 5 tables and I need to put those data together under a particular user. I don't want to use UNION because HQL doesn't support it. In addition, Union 5 tables may result in a huge SQL. I have to use one sub report for each table and iterate users in master report and for each user iterate all sub reports to display data relevant to that user. Is this viable or any other solution? Any comment is appreciated. -- View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847733p23847733.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How about loop a sub report?
Hi Peter, If I understand your requirements correctly I think grouping would be better than having multiple subreports. Grouping the data on users allows you to create a seperate table for each user, you can also have a header and footer for each user and you can also perform calculations and have totals at the bottom of each group. Hope this helps. Chris Peter Jin wrote: Hi, I may need to put several sub reports in the detail section in the master report. So the sub reports will get loaded many times. Will this cause significant performance issues? Does jasper cache data source for report in this case? My case: User's data are scattered in 5 tables and I need to put those data together under a particular user. I don't want to use UNION because HQL doesn't support it. In addition, Union 5 tables may result in a huge SQL. I have to use one sub report for each table and iterate users in master report and for each user iterate all sub reports to display data relevant to that user. Is this viable or any other solution? Any comment is appreciated. -- View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847733p23848126.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How about loop a sub report?
Sorry I forgot to mention that the info I gave is based on using iReport/jasperReports, not sure what you are using now but I definately recommend iReport. Chris chr15athome wrote: Hi Peter, If I understand your requirements correctly I think grouping would be better than having multiple subreports. Grouping the data on users allows you to create a seperate table for each user, you can also have a header and footer for each user and you can also perform calculations and have totals at the bottom of each group. Hope this helps. Chris Peter Jin wrote: Hi, I may need to put several sub reports in the detail section in the master report. So the sub reports will get loaded many times. Will this cause significant performance issues? Does jasper cache data source for report in this case? My case: User's data are scattered in 5 tables and I need to put those data together under a particular user. I don't want to use UNION because HQL doesn't support it. In addition, Union 5 tables may result in a huge SQL. I have to use one sub report for each table and iterate users in master report and for each user iterate all sub reports to display data relevant to that user. Is this viable or any other solution? Any comment is appreciated. -- View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847733p23848170.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How about loop a sub report?
Hi Chris, Thanks for your reply. Grouping can not solve my issue because it works on one data source only. In my case, data for a user scattered in 5 tables. UNION might be a way to combine all tables to a data source, but I can not use it either (explained in the first post). any thoughts? -- View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847733p23848221.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] How about loop a sub report?
Peter Jin jinyup...@gmail.com writes: Grouping can not solve my issue because it works on one data source only. In my case, data for a user scattered in 5 tables. UNION might be a way to combine all tables to a data source, but I can not use it either (explained in the first post). any thoughts? It's still somewhat unclear without knowing more about your table structure, but if you just mean that you have a reasonably normalized schema where the relevant information is stored in several tables with appropriate foreign key relationships (this can be true even if normal access is controlled by an ORM like Hibernate), is there a reason your report query can't just join the relevant tables together, grouping the result by user? If you mean 5 completely distinct data sources (e.g., separate databases), then another thought (if you have control of the code rendering the report) might be to implement a custom data source that itself performs the integration from the multiple data sources, even if via 5 distinct queries. From the Jasper engine's perspective it would still be utilized as a single data source for the report. -- David -- OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
[jasperreports-questions] Gridlock with textfields with dynamic content
Hi,
I really hope someone has a clue on this layout issue, because I am already
out of ideas.
Although I think that my problem has something to do with the designs i.e.
with way Jasper treats them (layout), here's some general information abou
the application.
Basically we have a JAVA client-server application and we use Jasper to
generate a bunch of reports. The Jasper designs are processed by a servlet
on the server-side and sent to the client as jrprint files, where they are
being presented to the user. We also have a scriptlet that does some stuff -
concatenating data etc.
The report that I am having trouble with has the following structure shown
in code snippet #1
The data for it comes from a SQL query that works perfectly, so it's only
the layout that is bugging me.
In the detail I have a bunch of textfields that visualise some hierarchy and
another textfield that can contain relatively large amount of text. I've
packed each of them in a frame, both of them building up another frame.
Beneath them I have another frame which can contain 0,1 or 2 images
(ideally). I end up with a report containing pages like the one in
attachment 1.
My goal is to have report pages where there is no space between the above
frame and the image frame - like the one in attachment 2, and of course with
the text within the upper frame. At the moment this is only possible if I
get rid of the lengthy text.
In my opinion, the problem lies in the definition of the field for the
lengthy text. As I don't know how long the string would be, i define it with
a height of 13 (code snippet #2 ), that is one line only. Because of the
stretching properties of the fields it accommodates accordingly, but by
doing so it pushes the images down by variable number of lines. So, is there
any way to avoid that pushing, which ruins the design.
Any help will be deeply appreciated. Thanks for it in advance.
Regards, al
- code #1
band height=245 isSplitAllowed=false!-- 245 --
frame
reportElement isRemoveLineWhenBlank=true
positionType=Float width=545 y=0 x=0 height=75
stretchType=RelativeToBandHeight
/reportElement
box
pen lineColor=black lineStyle=Solid
lineWidth=1 /
/box
frame
reportElement isRemoveLineWhenBlank=true
positionType=FixRelativeToTop width=200 y=0 x=55
height=75 stretchType=RelativeToTallestObject/
box
pen lineColor=green lineStyle=Solid
lineWidth=3 /
/box
textField isStretchWithOverflow=true pattern=
isBlankWhenNull=true evaluationGroup=Ebene2
reportElement x=0 y=0 width=200
height=13 positionType=Float isRemoveLineWhenBlank=true
isPrintInFirstWholeBand=true
printWhenExpression![CDATA[new Boolean(
($F{AnlagenEbeneOfSchaden}).intValue()==1 )]]/printWhenExpression
/reportElement
textElement
/textElement
textFieldExpression
class=java.lang.String![CDATA[((alwin2Scriptlet)$P{REPORT_SCRIPTLET}).getStrukturBezMitStandOrtEbeneDB($F{Strukturcode1},
1)]]/textFieldExpression
/textField
textField isStretchWithOverflow=true pattern=
isBlankWhenNull=true evaluationGroup=Ebene2
reportElement x=15 y=0 width=185
height=13 mode=Opaque positionType=Float
isRemoveLineWhenBlank=true isPrintInFirstWholeBand=true /
textElement
/textElement
textFieldExpression
class=java.lang.String![CDATA[((alwin2Scriptlet)$P{REPORT_SCRIPTLET}).getStrukturBezMitStandOrtEbeneDB($F{Strukturcode1},
2)]]/textFieldExpression
/textField
textField isStretchWithOverflow=true pattern=
isBlankWhenNull=true evaluationGroup=Ebene3
reportElement mode=Opaque x=30 y=15
width=170 height=13 positionType=Float
isRemoveLineWhenBlank=true /
textElement
/textElement
textFieldExpression
class=java.lang.String![CDATA[((alwin2Scriptlet)$P{REPORT_SCRIPTLET}).getStrukturBezMitStandOrtEbeneDB($F{Strukturcode1},
3)]]/textFieldExpression
/textField
textField isStretchWithOverflow=true pattern=
isBlankWhenNull=true
reportElement mode=Opaque x=45 y=30
width=155 height=13 positionType=Float
isRemoveLineWhenBlank=true /
textElement
/textElement
textFieldExpression
class=java.lang.String![CDATA[((alwin2Scriptlet)$P{REPORT_SCRIPTLET}).getStrukturBezMitStandOrtEbeneDB($F{Strukturcode1},
4)]]/textFieldExpression
/textField
textField isStretchWithOverflow=true pattern=
isBlankWhenNull=true
reportElement mode=Opaque x=60 y=45
width=140 height=13 positionType=Float
isRemoveLineWhenBlank=true /
textElement
/textElement
textFieldExpression
class=java.lang.String![CDATA[((alwin2Scriptlet)$P{REPORT_SCRIPTLET}).getStrukturBezMitStandOrtEbeneDB($F{Strukturcode1},
[jasperreports-questions] text from tinymce to pdf
We are creating jasper report using sql query .One of our column is clob which contains html markup language, so just wondering will there be any problems in creating pdf ? This column get populated by rich text editor tinemce , please suggest me what problems will I come across ? -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
