knobboll

Hi, I have written a report getting data from a database which is a Linked Server to a SQL Server Database. The report works fine when I execute it for example from iReport but it is empty when I call it from within Jasper Server. Does anyone know why it doesn’t show data when executing it in Jasper Server? Do I have to change settings in Jasper Server to make it work? Thanks, Clemens

Here a better scenario what I try to do: DBMS: MS SQL Server 2005 I want to join to tables from two different DBMS’ Table A is in database X on server V Table B is in database Y on server W Select * FROM [server-V].[DataBase-X].[owner].[Table-A] a INNER JOIN [server-W].[DataBase-Y].[owner].[Table-B] b ON a.Key = b.Key This SQL Statement works from the database client as well as from iReport when prototyping the report. When I execute the report on Jasper Server I get an error. Every time I try to access a table from a remote DBMS I get an error when running the report from Jasper Server. ------------------------------------------------------------ This is a very annoying problem for me as it prevents me from creating quite a few reports I urgently need. It would be great if someone can have a look at it and fix the problem if possible. If there are questions about the problem please contact me.

Hi, I like to run some metrics in JS on my report. I’d like to know information like how often a report was executed, by whom it was executed, when it ran the last time etc. Is this kind information somehow available in Jasper Server? Thanks, Clem

Thanks for the answer. I have a look in this direction.

Hi, I have a problem with date values in my report. When I run a report JS shows the date is one hour early. I.e if the value in the database is “16 Oct 2007 00:00†it shows in the report as “15 Oct 2007 23:00â€. Does anyone know if there is a setting in Jasper that I have missed or what else could be the reason? Thanks a lot. Clemens

Thanks for the information. As I was trying to access SQL Server 2005 I also realized that I need the 2005 driver because the 2000 driver is not compatible with the 2005 server. It's working now :-)

Hi, I try to run a report with a subreport in JS. I have created the report via ireport and moved it to the server via the plugin. The main report and the subreport both accessing data from SQL Server. The reports are fine as standalone reports but when I run the report including the subreport in JS I get the error message: java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode. Does anyone know a solution to this problem? Thanks, Clem

Hi, I am still new to Jasper Server. I want to change a XML file. Do I have to recompile it afterwards and if so what do I have to do? Thanks, Clem

Hello Sam, I tried you suggestion and changed the entry to: flow.html?_flowId=listReportsFlow&curlnk=2 and flow.html?_flowId=listReportsFlow but both didn't work. Jasper Server wouldn't start with error message: The requested resource (/jasperserver/) is not available. Do you know what I am doing wrong? Thanks, Clemens

Thanks for you help. Clem

Hi, is there a way to configure Jasper Server that a user will see the Reports immideately after he has logged in rather then seeing the Repository first? Thanks Clem

Yep. It works. You made my day :) Thanks a lot. Clem

Thanks a lot for the reply. I presume you mean the output folder in JS. I run the job as jasperadmin and have given Administer rights for the folder where the output file should go to - but no luck :( Do you have another idea what the reason could be? Cheers, Clem

Hi, I try to add a scheduled report to Jasper Server 1.2.1 but when it get triggered I get an error message saying: Access is denied What am I missing can any help? Thanks ****************************************** Job: REP(ID: 24) Report unit: /Report/CR/REP Quartz Job: ReportJobs.job_24 Quartz Trigger: ReportJobs.trigger_25_0 Access is denied org.acegisecurity.AccessDeniedException: Access is denied at org.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:68) at org.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:275) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy2.getResource(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.saveToRepository(ReportExecutionJob.java:441) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendToDestinations(ReportExecutionJob.java:295) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:138) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

Hi, I am using a stacked bar graph. The graph has several category series but not each category series has a value. It seems that the graph puts the bars first where all value expressions for the series have a value and then orders the category alphabetically. Is there a way to influence the default order the graph is using? Thanks in advance.

Hi, I am using MS SQL Server and I need to join two tables stored in two different databases on different servers. The query I run looks like: SELECT x.name FROM hostA.databaseA.dbo.tableA x, hostB.databaseB.dbo.tableB y WHERE x.id = y.id I use iReport to design my Report and from within iReport I can run it without problems. But when I move the Report to JasperServer 1.2.1 and execute it from there I get the following error: ***************************************************** org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@bdf98d targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@1f0a2a0, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow' -- action execution attributes were 'map[[empty]]'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : test02 ***************************************************** If I execute reports where the tables are hosted in the same database everything works fine. Does anyone know what the problem is? Is there a solution to it? Thanks