supunthri

Hi, I figured out what was wrong, I had to make the "detectCellType" property of "xlsExportParameters" bean to false in order for my formatPatternsMap s to work. THis is the entry I have put as a mapping, <util:map id="formatPatternsMap"> <!-- entry key="¤ #,##0.00" value="$ #,##0.00"/--> <entry key="#,##0.0 %" value="0.00%"/> </util:map> Cheers! Supun

HI, I have an JasperReport running on JasperServer 3.7 which has a percentage column with the following numeric pattern applied "#,##0.00 %" But when you export the report to excel what I get is a value like below, for example, for the value 25.0% shown on jasperserver what I see on the excel export is, "0.25" I saw that an entry should be put inside the formatPatternsMap bean bu I have no idea what values should be put in order to get this working Can someone help me configuring this? THanks a lot in advance!! Supun.

Hi Vasiliz, Thanx a million for the replay,! yes I figured that it was in milisecs and luckily there is a way to get it sorted out in C# and is as follows, DateTime firstdate = Convert.ToDateTime("1/1/1970"); DateTime seconddate = firstdate.AddMilliseconds(1278310400000); Cheers! Supun.

Hi, does anybody know why the CreationDate has this value? I realy need to have this value converted into datetime. Cheers!

Hi, I have been trying to talk to JS Web Service from C# .NET using Visual Studio 2008. I have been using the LIST method of the Repository Web Service. I could successfully connect to the web service as well as was I able to get an Operational Result, part of it is as follows, <operationResult version="2.0.1"> <returnCode><![CDATA[0]]></returnCode> <resourceDescriptor name="Shipping_data_last_full_week_LTA" wsType="reportUnit" uriString="/reports/Reports/LTA/Shipping_data_last_full_week_LTA" isNew="false"> <label><![CDATA[shipping Data last Full Week for LTA]]></label> <creationDate>1278310400000</creationDate> <resourceProperty name="PROP_RESOURCE_TYPE"> Please check the CreationDate tag, I'm not sure how to convert the value in the tag to actual datetime format. Can anyone help me on this Thanx a lot in advance, Cheers, Supun

Found a solution in the following thread, the last comment http://www2.jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=74941

Hi, I have transfered my reporting repository from JasperServer Pro 3.5 to JasperServer CE 3.7. Now when I run the reports either manually or using a schedule, to XLS, all the 'Column Headers' and 'Page Footers' are removed in the excel output of the report. This is so annoying because the report is fine when run manually or using iReports. Please can someone tel me why this is happening? Cheers! Supun

Hi tkavanagh, Thanx a lot for the response, I initially tried to change the XML to remove the tenant IDs but found that it would be impossible to do since there are a lot of reports. But then I exported only certain URIs using the URIS commant, only the subfolders where the report JRXMLs were stored on JS Pro installation. When I tried to import those to the CE it worked. Did the same to with --report-job too. So now the reports and the schedules are in place. Cheers! Supun.

I have a jasperserver-pro installation and I have exported everything using the following line js-export.bat --uris /reports/myreports --output-zip js-myreports.zip my installation has an Organization named organization_1. Now I need to import this zip to a JasperServer Community installation but when I try to do so the following error comes, 10:57:53,726 ERROR BaseExportImportCommand:45 - java.lang.IllegalArgumentExcepti on: This implementation does not support tenants java.lang.IllegalArgumentException: This implementation does not support tenants ........ ..... ... Is there anyway I can import the export from the Professional Edition to a Community Edition? Thanx a lot in advance.

Hi All, I need to know when you have a JasperServer Pro installation, what are the things I should backup. Is it the MySQL Database, The JapserServer Pro folder or both? In case of a system crash, how can i use this backup to get back my previous JaspeerServer Installation in a new server including the JS Repository (Reports, data sources...etc). Thanx a lot in advance Supun

I can save Ad-Hoc reports when I am in the Chart or Table tab, not when I'm in the Cross Tab section. So even if I create a drill down report in Cross Tab, i don't have a way to save that report Note: we do not have license for JasperAnalysis, if it helps to identify the problem So any help having drill down reports on Dashboard? Cheers! Supun

Hi All, We have recently implemented JasperServer Pro 3.5 and trying to publish a drill down report on a dashboard. I see that i can create ad-hoc reports which can be drilled down into the levels that i specify. I.e. Country --> Region ..etc But i couldn't find a way to save these reports and make these reports available on a dashboard. (When im in the cross tab section of adhoc reporting, the Save Report icon is grayed out) Does anyone know how to do this? Thanks a lot in advance, Cheers!

Hi All, I have uploaded two copies of the same report to JasperServer, and they connect to two different SQL Anywhere database Servers. I have also scheduled them. One report runs successfully where as the other report alsways fails after about 2 hours of executing with the following error, Does any body have any idea why this is happening? Thanks in advance ;) Quartz Job: ReportJobs.job_96 Quartz Trigger: ReportJobs.trigger_99_0 Exceptions: An error occurred while executing the report. com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : stock_detail_report at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:164) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:71) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:676) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:596) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1223) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:853) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:439) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:748) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:367) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:876) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:301) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:444) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.executeReport(ReportOptionsExecutionJob.java:103) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:372) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.SocketTimeoutException: Read timed out at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source) at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source) at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) Post Edited by supunthri at 10/22/2009 12:49

Hi, Im new to JS, and im trying to create a BI report using MDX with iReports. I have created a Analysis Connection to a Analysis Schema i created in JS. Now i want to create a XMLA connection from iReports, so for the connection params i put the following URL of XMLA Server : http://<my jasper server>/jasperserver-pro/xmla and when i press get meta data i get 3 predefined data sources, but i cant see the analysis connections i have created. Can someone explain how i should create xmla connections in the JS so that i can use them here in iReports? THanks a lot in advance :)

Yes, its the same issue i'm facing, im getting loads of complaints from the report users and im no where how to solve this. And this keeps me busy with re running all the schedules which were not run automatically which drives me crazy. Hope i would get a reply for this soon :-s Cheers!