[Probem receiving data from Linked Server]

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

[Metrics on Reports in Jasper Server]

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

[Getting wrong Date value]

Thanks for the answer.

 

I have a look in this direction.

[Getting wrong Date value]

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

[Can't connect to database with subreport]

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 :-)

[Can't connect to database with subreport]

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

[Change XML file]

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

[Going to the Reports after logging in]

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

[Going to the Reports after logging in]

Thanks for you help.

 

Clem

[Going to the Reports after logging in]

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

[Access is denied when running scheduled report]

Yep. It works. You made my day :)

Thanks a lot.

 

Clem

[Access is denied when running scheduled report]

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

[Access is denied when running scheduled report]

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)

[Influence Oder of Stacked Bar]

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.

[Cannot join tables from different databases]

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