knobboll
-
Posts
18 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by knobboll
-
-
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
Probem receiving data from Linked Server
in Products
Posted
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