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/ 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: [email protected] ► Website: http://www.jaspersoft.com Forge: http://www.jasperforge.org ______________________________________________________________ ----- Original Message ----- From: "Michael Lübben" <[email protected]> To: "Ernesto Ongaro" <[email protected]>, [email protected] 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: [email protected] > ► Website: http://www.jaspersoft.com Forge: http://www.jasperforge.org Bye Michael > ______________________________________________________________ > > ----- Original Message ----- > From: "Michael Lübben"<[email protected]> > To: [email protected] > 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"<[email protected]> >> To: [email protected] >> 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 >> [email protected] >> 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 >> [email protected] >> 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/icinga-users
