Hi Ernesto, On Dec 22, 2011, at 8:25 PM, Ernesto Ongaro wrote:
> Hi, > > I confirmed that in JRS 4.2.1 community by default the XHTML exporter is > enabled by default in the jasperreports.properties file (under > WEB-INF/classes). > > # switch between new XHTML to the former HTML exporter > com.jaspersoft.jasperreports.export.html.type=xhtml > #com.jaspersoft.jasperreports.export.html.type=html > > Does anyone know what version of Jaspersoft the demo server is running? > http://web.demo.icinga.org/icinga-web/ It is a jasper 4.1.0 Regards Bernd > > I also confirm that the query is logged when you uncomment the line mentioned > below, in your log the query will contain this line: JRJdbcQueryExecuter > > You can always execute the reports directly from iReport too if you want to > edit the query. > > Ernesto Ongaro > Jaspersoft Corporation > > ► Email: eong...@jaspersoft.com > ► Website: http://www.jaspersoft.com Forge: http://www.jasperforge.org > ______________________________________________________________ > > ----- Original Message ----- > From: "Michael Lübben" <mickey2...@nagios-portal.de> > To: "Ernesto Ongaro" <eong...@jaspersoft.com>, > icinga-users@lists.sourceforge.net > Sent: Thursday, December 22, 2011 1:40:56 AM > Subject: Re: [icinga-users] JasperReports still empty > > Hi Ernesto, > > > On 12/22/2011 06:40 AM, Ernesto Ongaro wrote: >> Hi Michael, >> >> You can try changing this property (and restarting tomcat) to get the query: >> log4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug > i have change the properties, but i see no sql queries from my reports > in the logs. There are tow log files jasperserver.log and > jasperserver.log.1. The reports runs successfully on the JasperServer, > but the result is wrong. I think there is a mistake in the sql queries. >> >> But if you say they run properly on JasperReports Server then the culprit >> seems more of the interface. >> >> I'm wondering a couple of things too. Since JasperReports Server 4.2.1 >> there's a new XHTML exporter (instead of HTML). The win here is that you can >> overlap elements. I need to double check to see if the way you guys call the >> server with this code would use XHTML >> https://git.icinga.org/?p=icinga-web.git;a=blob;f=app/modules/Reporting/lib/jasper/JasperI.interface.php >> >> The way to check is to try a PDF export, if there are overlapping elements >> in the report then HTML will ignore, XHTML and PDF will show properly. I'll >> check with developers here and post back tomorrow. > Hmm, then should we change from HTML to XHTML :-) Thanks for the info. > I'm waiting for your feedback. >> >> Also, you said not all reports are listed in the web interface, strange, the >> API should return them all. Is there anything funny in the name of the >> reports, special characters and whatnot? >> >> Ernesto Ongaro >> Jaspersoft Corporation >> >> ► Email: eong...@jaspersoft.com >> ► Website: http://www.jaspersoft.com Forge: http://www.jasperforge.org > Bye > Michael >> ______________________________________________________________ >> >> ----- Original Message ----- >> From: "Michael Lübben"<mickey2...@nagios-portal.de> >> To: icinga-users@lists.sourceforge.net >> Sent: Tuesday, December 20, 2011 3:57:08 AM >> Subject: Re: [icinga-users] JasperReports still empty >> >> Hi Ernesto, >> >> thanks for this information. I have enable debugging, but i don't see >> any sql queries in the logs. Musst i enable another parameters in the >> properties? >> >> Bye >> Michael >> >> On 12/19/2011 11:55 PM, Ernesto Ongaro wrote: >>> Hi Tamme! >>> >>> Probably the best thing you can do is turn on DEBUG to JasperReports >>> Server, find webapps/jasperserver-pro/WEB-INF/log4j.properties and change >>> log4j.rootLogger=WARN, stdout, fileout to log4j.rootLogger=DEBUG, stdout, >>> fileout >>> >>> Once you've changed that file, restart Tomcat and then re-run the reports >>> in question. In ../WEB-INF/logs/jasperserver.log will get the parameters >>> that are passed to the report, any stack traces (errors) and the SQL query >>> that is generated. From this you should be able to gather what is wrong. >>> Feel free to send me the logs if you can't find it >>> >>> Best of luck! >>> >>> Ernesto Ongaro >>> Jaspersoft Corporation >>> >>> ► Website: http://www.jaspersoft.com Forge: http://www.jasperforge.org >>> ______________________________________________________________ >>> >>> ----- Original Message ----- >>> From: "tamme lennon"<tammelen...@gmail.com> >>> To: icinga-users@lists.sourceforge.net >>> Sent: Friday, December 16, 2011 8:33:53 AM >>> Subject: [icinga-users] JasperReports still empty >>> >>> >>> Hello, I've been having the same issues with JasperReports since 1.5.0. The >>> only reports that seem to work out of the box are Host and Service >>> Notification Reports about a given time and the top 10 in a given time. >>> >>> Some of the host reports display graphs, but they are always 100% and don't >>> seem to line up with known outages reported correctly in the Host >>> Notifications Reports over a given time. >>> >>> >>> Is there some setting in icinga.cfg, ido2db.cfg, idomod.cfg that aren't >>> mentioned in the JasperReport Install doc? >>> >>> I've tried the WAR install and the straight JasperReportBinary install. >>> I've also tried the git and regular install of icinga-reports. >>> >>> I noticed there is now a mentioned of setting the timestamps in the icinga >>> database to UTC. Could this all be related? >>> >>> I'm running Ubuntu 10.04 with icinga 1.6.1, and the lastest icinga-web and >>> icinga-reports. >>> >>> My timezone on the system is set to CDT. >>> >>> Any input is greatly appreciated. I'm at wits end on this. I've been >>> searching through the lists and docs for quite a while, and I've seen >>> people reporting similar errors, but I haven't found a solution that works. >>> >>> Thanks! >>> >>> Tamme >>> >>> ------------------------------------------------------------------------------ >>> Learn Windows Azure Live! Tuesday, Dec 13, 2011 >>> Microsoft is holding a special Learn Windows Azure training event for >>> developers. It will provide a great way to learn Windows Azure and what it >>> provides. You can attend the event by watching it streamed LIVE online. >>> Learn more at http://p.sf.net/sfu/ms-windowsazure >>> _______________________________________________ >>> icinga-users mailing list >>> icinga-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/icinga-users >>> >>> ------------------------------------------------------------------------------ >>> Write once. Port to many. >>> Get the SDK and tools to simplify cross-platform app development. Create >>> new or port existing apps to sell to consumers worldwide. Explore the >>> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join >>> http://p.sf.net/sfu/intel-appdev >>> _______________________________________________ >>> icinga-users mailing list >>> icinga-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/icinga-users >> ------------------------------------------------------------------------------ >> Write once. Port to many. >> Get the SDK and tools to simplify cross-platform app development. Create >> new or port existing apps to sell to consumers worldwide. Explore the >> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join >> http://p.sf.net/sfu/intel-appdev >> _______________________________________________ >> icinga-users mailing list >> icinga-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/icinga-users > > ------------------------------------------------------------------------------ > Write once. Port to many. > Get the SDK and tools to simplify cross-platform app development. Create > new or port existing apps to sell to consumers worldwide. Explore the > Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join > http://p.sf.net/sfu/intel-appdev > _______________________________________________ > icinga-users mailing list > icinga-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/icinga-users ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ icinga-users mailing list icinga-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/icinga-users
