svedec

This was a license issue and is resolved now.

I have been working with JasperServer Pro and domains for over 5 years now, and recently delved into OLAP cubes with the Jasper OLAP Workbench. Both are used as input for the Ad Hoc editor, and my question is this: what arguments apply for choosing domains over cubes, or vica versa ? What are the pros and cons of both ? The process of creating is different, I get that, but beyond that, I don't see any big differences.

Apparently this now has to be done through an advanced property, since I can't find where to set the font size for the legend, x and y axis. Which properties are these and is there a list that covers all properties ?

Am I missing something, or can you only drill down from a sum to the details in a cross tab ? I don't see this in a chart, where one would expect when clicking on a bar to be taken to the detail records. Please advise, thanks on beforehand.

solved - known bug in 5.0.1, upgrade needed.

As superuser, I've upped the limit to 500.000 in the Server Settings page and still I get +/- 100 clients, where I should have 500. When using a Table, I get all my clients. Is there a(nother) built-in limit to the number of rows visible in a crosstab ?

Where would I find this information please ? We're running Jasperserver Pro 5.0.1

I use JasperReports Server Pro 5.0.1 I want to join 2 tables, of which one field is a calculated field (made in domain designer) Apparently, this cannot be done, as the join-icons grey out when I select my calculated field. Why is this ? I tried to work around it, and make a derived table from my entire table, plus the calculated field, but that completely slows everything down. I'm under the impression derived tables don't use indexes. Another workaround would be to physically include the calculated field in my table, but I'm no fan of that. Any suggestions, or is this just not possible (and why ??). Thanks on beforehand.

Hi everyone, We're running Jasperreports Server Pro 5.0.1. We have say 500 clients, each has their own number of course, and I have an Ad Hoc report which shows their profits. Parameter for this report is their client code, resulting in a personalised ad hoc report. Is there a way to schedule this report, with the 500 client codes as parameter, resulting in 500 SEPERATE pdf files ? I would be OK with the files being stored physically on the server, teh winz would be if they could be emailed to that specific client :-) Any suggstions please ? Thanks in advance.

I have the same error, yet our encoding is set to UTF-8. This is the trace: The server has encountered an error. Please excuse the inconvenience. Error Message com.jaspersoft.jasperserver.api.JSException: jsexception.selected.report.not.adhoc Error Trace com.jaspersoft.jasperserver.api.JSException: jsexception.selected.report.not.adhoc at com.jaspersoft.ji.adhoc.action.AdhocAction.startAdHoc(AdhocAction.java:355) at sun.reflect.GeneratedMethodAccessor765.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Flow.start(Flow.java:535) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:366) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:225) at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:140) at sun.reflect.GeneratedMethodAccessor514.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy133.launchExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:95) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:66) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:101) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:662)

Under 'manage', I have no 'organization' menu item too.

There is no limit on the amount of organizations (I've got 4), is there ?

I have a multi-organization structure on Jasper Pro 5.0.1, and I want to add a top-level organization, but can't find where to do this. I am logged in as superuser, I've got the admin and superuser role, and still I can't manage to add, even a suborganization. Sorry this sounds so clumsy, but where do I have to look ?

are you sure this path is correct : /ehrDashBoard/image/FCMap_World7.swf ? my solution is in the 2nd post, but in the end I used static charts, because our printer couldn't handle SWF charts :-(

I still haven't cracked it, anyone ?

Strangest thing : I have 2 organisations. As a superuser, I export a domein from organisation A and want to import it in organisation B, but the server tells me "invalid file" and "Domain schema is invalid". I checked the XML, and changed the datasourceId from organ_A to organ_B, but I stell get the error. What's wrong? I *just* exported it ? Thanks in advance for any help.

is no one else having this problem ?

I have a dataset (data over 13 months) and a list, and within that dataset, I want a variable to calculate the average, rather than expanding my query and putting in an extra row with the average in my resultset. So when I try this, firstly, it seems I have to duplicate my list. I can't for instance, have my 13 months coming from my dataset, and another row at the end of the list, with my variables, like in attachment 1. (item height = 13, list height = 182) That's a pity, unless I am missing something. So, ok, I duplicate my list, set the height to 13 (item height as well) and put in my AVG row, like in attachment 2. But then I get this error : Error filling print... null Setting up the file resolver... java.lang.NullPointerException at net.sf.jasperreports.engine.fill.JRDoubleAverageIncrementer.increment(JRDoubleIncrementerFactory.java:371) I've played around with the evaluation time of the text box and reset types of the variables, but to no avail. What am I missing, can someone help me please ?

Thanks for your suggestions. I guess I could provide a topic with only the current data in it.

Hi and thanks for your reply. The thing is the history of those employees should be availble, in case the user needs to know. I kind of wished the table report would 'distinct' the lines in the table itself as long as the employee column wasn't added. The thing with the crosstab report is I don't have a measure. What I can come up with is in the attachment, but doesn't look pretty. Plus, I have to open all the +'s to see the entire record, giving me way too much totals etc.

I have a table in which I list my contacts with their address and phone number. I also have a dataset which lists which employees have worked on which client's dossier. When I make my list, 1 contact is shown 3 times, with the same address and phone number. When I add the employees, I can see why, she's had 3 over a stretch of time. My question is, is there a way to have unique rows in the table, when the employee's name is not showing ? (like an SQL "distinct") ? Examples attached.

Thanks again, it seems to be working now. I wonder how this is tied to spam protection, since I have to log in on my own server ?

Hi, and thanks for your quick reply. I'm not sure of the 5000char limit is exactly what's wrong. I think the greater-than sign messes up the code. I'll give it a try and leave feedback.

bug report ?

When I want to make a domain with a derived table, apparently, I can't use the greater-than sign for date comparison. The database is Informix IDS, jasperserver is version 4.5.0 This query works : select * from client where enddate < CURRENT This one doesn't : select * from client where enddate > CURRENT Am I missing something here, or is this just foolish ? I found this in the errorlog : 2012-07-25 10:53:51,126 WARN IntrusionDetector,TP-Processor3:449 - [sECURITY FAILURE Anonymous:null@unknown -> /ExampleApplication/IntrusionDetector] Invalid input: context=createdQuerySql-Run_Report_context, type(NoTag)=^[^<][^>]*$, input=select * from client where enddate > CURRENT org.owasp.esapi.errors.ValidationException: createdQuerySql-Run_Report_context: Invalid input. Please conform to regex ^[^<][^>]*$ with a maximum length of 5000 Post Edited by svedec at 07/25/2012 08:56