jbreault

Thanks for the suggestion mlopex_1, but when I add the jar file to jasperserver/WEB-INF/lib and restart the server, I get an error when I go to http://localhost:8082/jasperserver/login.html (8082 is the correct port). It says HTTP Status 404 - /jasperserver/login.html and The requested resource is not available.

I created a jrxml file that uses scriplets. When I run the report via java, the fields are filled properly, however, when the report is run on JasperReports Server every value from a scriptlet is null. Every meathod I use calls a server, and if I create a method that does not call a server (for testing purposes) the corresponding fields return the proper values on JasperReports Server. I built my java project into a jar file and added this jar file to my report on JasperReports Server as a resource. I am not sure what could be going wrong. Any help is appreciated.

Right, sorry about that. After changing validation.properties, I just had to restart the server.

Whenever I open Jaspersoft Studio, I immediately get an error stating "Reason: Invalid signature file digest for Manifest main attributes". If I view the details, it says what is below. This problem arised when I was trying to create scriptlets from classes in external jar files. Now Jaspersoft Studio doesn't function properly at all for any report. The Design and Preview tabs are empty. I am looking for a way to make Jaspersoft Studio functional again, and why this happened in the first place. Any help is appreciated. java.lang.SecurityException: Invalid signature file digest for Manifest main attributesat sun.security.util.SignatureFileVerifier.processImpl(SignatureFileVerifier.java:284)at sun.security.util.SignatureFileVerifier.process(SignatureFileVerifier.java:238)at java.util.jar.JarVerifier.processEntry(JarVerifier.java:316)at java.util.jar.JarVerifier.update(JarVerifier.java:228)at java.util.jar.JarFile.initializeVerifier(JarFile.java:383)at java.util.jar.JarFile.getInputStream(JarFile.java:450)at sun.net.www.protocol.jar.JarURLConnection.getInputStream(JarURLConnection.java:162)at java.net.URL.openStream(URL.java:1045)at net.sf.jasperreports.engine.JRPropertiesMap.loadProperties(JRPropertiesMap.java:397)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:203)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:164)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:134)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:106)at net.sf.jasperreports.engine.DefaultJasperReportsContext.getExtensions(DefaultJasperReportsContext.java:268)at net.sf.jasperreports.engine.SimpleJasperReportsContext.getExtensions(SimpleJasperReportsContext.java:123)at net.sf.jasperreports.engine.util.LocalJasperReportsContext.getExtensions(LocalJasperReportsContext.java:158)at com.jaspersoft.studio.utils.jasper.JasperReportsConfiguration.getExtensionComponents(JasperReportsConfiguration.java:679)at com.jaspersoft.studio.utils.jasper.JasperReportsConfiguration.getExtensions(JasperReportsConfiguration.java:725)at net.sf.jasperreports.engine.component.ComponentsEnvironment.findBundles(ComponentsEnvironment.java:109)at net.sf.jasperreports.engine.component.ComponentsEnvironment.getCachedBundles(ComponentsEnvironment.java:99)at net.sf.jasperreports.engine.component.ComponentsEnvironment.getBundles(ComponentsEnvironment.java:87)at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.getSchemaLocations(JRReportSaxParserFactory.java:93)at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.configureParser(BaseSaxParserFactory.java:153)at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.createParser(BaseSaxParserFactory.java:108)at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1580)at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1549)at com.jaspersoft.studio.editor.AbstractJRXMLEditor.doInitModel(AbstractJRXMLEditor.java:295)at com.jaspersoft.studio.editor.AbstractJRXMLEditor.init(AbstractJRXMLEditor.java:248)at org.eclipse.ui.internal.EditorReference.initialize(EditorReference.java:361)at org.eclipse.ui.internal.e4.compatibility.CompatibilityPart.create(CompatibilityPart.java:319)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)at org.eclipse.e4.core.internal.di.InjectorImpl.processAnnotated(InjectorImpl.java:898)at org.eclipse.e4.core.internal.di.InjectorImpl.processAnnotated(InjectorImpl.java:879)at org.eclipse.e4.core.internal.di.InjectorImpl.inject(InjectorImpl.java:121)at org.eclipse.e4.core.internal.di.InjectorImpl.internalMake(InjectorImpl.java:345)at org.eclipse.e4.core.internal.di.InjectorImpl.make(InjectorImpl.java:264)at org.eclipse.e4.core.contexts.ContextInjectionFactory.make(ContextInjectionFactory.java:162)at org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.createFromBundle(ReflectionContributionFactory.java:104)at org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.doCreate(ReflectionContributionFactory.java:73)at org.eclipse.e4.ui.internal.workbench.ReflectionContributionFactory.create(ReflectionContributionFactory.java:55)at org.eclipse.e4.ui.workbench.renderers.swt.ContributedPartRenderer.createWidget(ContributedPartRenderer.java:129)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createWidget(PartRenderingEngine.java:971)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:640)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.StackRenderer.showTab(StackRenderer.java:1306)at org.eclipse.e4.ui.workbench.renderers.swt.LazyStackRenderer.postProcess(LazyStackRenderer.java:103)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:658)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.SWTPartRenderer.processContents(SWTPartRenderer.java:71)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:654)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$1.run(PartRenderingEngine.java:525)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:509)at org.eclipse.e4.ui.workbench.renderers.swt.ElementReferenceRenderer.createWidget(ElementReferenceRenderer.java:69)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createWidget(PartRenderingEngine.java:971)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:640)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.SWTPartRenderer.processContents(SWTPartRenderer.java:71)at org.eclipse.e4.ui.workbench.renderers.swt.SashRenderer.processContents(SashRenderer.java:151)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:654)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.SWTPartRenderer.processContents(SWTPartRenderer.java:71)at org.eclipse.e4.ui.workbench.renderers.swt.SashRenderer.processContents(SashRenderer.java:151)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:654)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.SWTPartRenderer.processContents(SWTPartRenderer.java:71)at org.eclipse.e4.ui.workbench.renderers.swt.SashRenderer.processContents(SashRenderer.java:151)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:654)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.SWTPartRenderer.processContents(SWTPartRenderer.java:71)at org.eclipse.e4.ui.workbench.renderers.swt.PerspectiveRenderer.processContents(PerspectiveRenderer.java:49)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:654)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.PerspectiveStackRenderer.showTab(PerspectiveStackRenderer.java:82)at org.eclipse.e4.ui.workbench.renderers.swt.LazyStackRenderer.postProcess(LazyStackRenderer.java:103)at org.eclipse.e4.ui.workbench.renderers.swt.PerspectiveStackRenderer.postProcess(PerspectiveStackRenderer.java:63)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:658)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.SWTPartRenderer.processContents(SWTPartRenderer.java:71)at org.eclipse.e4.ui.workbench.renderers.swt.SashRenderer.processContents(SashRenderer.java:151)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:654)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.workbench.renderers.swt.SWTPartRenderer.processContents(SWTPartRenderer.java:71)at org.eclipse.e4.ui.workbench.renderers.swt.WBWRenderer.processContents(WBWRenderer.java:614)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:654)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.safeCreateGui(PartRenderingEngine.java:746)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.access$0(PartRenderingEngine.java:717)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$2.run(PartRenderingEngine.java:711)at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.createGui(PartRenderingEngine.java:695)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1061)at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694)at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606)at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:99)at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:498)at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)at org.eclipse.equinox.launcher.Main.run(Main.java:1515)

I am tring to follow the tutorial video below that discusses using scriptlets, but at 0:56 he already has some things set up. I have figured out how to add everything the tutorial has in the Project Explorer except for the content within the src folder. How do I add the default package (also, what is that?) and a java file I can edit in Jaspersoft Studio like the tutorial does? Any help is appreciated. http://community.jaspersoft.com/wiki/video-simple-example-using-scriptlets-inside-tibco-jaspersoft-studio-and-jasperreports Edit: Solved by following instructions here: http://community.jaspersoft.com/blog/scriptlet-example-jaspersoft-6x-begineers-hello-world-sample-example

I am trying to create a report that retrieves data from an API, and this requires java code to run during the runtime execution of the report. I am lost as to how to get java code to run when the user runs the report, and I can't find much in the documentation. Any help you can offer is appreciated.

I am currently using the 30 day free trial of JasperReports Server Pro. I am trying to export Ad Hoc views and dashboards, but when I right click on them from the repository, export is not an option (though it is an option when I right click on a report using the community edition). According to the JasperReports Server Admin Guide, exporting can be done from the settings UI as well. The only problem is that I am not able to access the settings either. When I click Manage, Server Settings is not there. I am logged in as jasperadmin, the default admin account, so I should have permission to access these things (to my knowledge). Any help is appreciated.

I am currently using the 30 day free trial of JasperReports Sever Pro. When I right click on an Ad Hoc view or dashboard I am not given an option to export (though the option is there when I right click on a report on the community edition). Am I missing something?

For reports made using Jaspersoft Studio, the report information can be stored both on JasperReport Server and locally as a jrxml file. I am wondering if the same is possible for Ad Hoc views and dashboards. Is it possible to have Ad Hoc views and dashboards on my machine as some type of file?

I created an Ah Hoc view from a topic and I can't find a way to have more than one dimension when viewing the data as a crosstab. I placed all the measures in the Columns box, but when I put fields in the Rows box it is all clumped into a single hierarchy. Is there a way to have multiple dimensions/hierarchies like you can when the Ad Hoc view is from an OLAP connection. I have to use topics because I require a parameterized query and as far as I know this is only possible in topic-based Ad Hoc views. Any help is appreciated.

Today everything seems to be working how it should. Strange, but thanks anyway.

In the dashboard designer, I am trying to use parameter mapping to make a single input have control over the parameters of 2 different charts. I press the parameter mapping button and the pop-up comes up, as normal, but the OK button doesn't seem to be working. Doesn't matter if I change nothing or many things, the OK button just does nothing. If I click OK while a field is left empty, it will tell me that I need to fill in the field, but that is all. Any idea what is going on here? Also, this doesn't seem to be a problem for the sample dashboards.

I have several very similar reports that I am currently trying to combine into a single report. They mostly only vary by their grouping, but I have a parameter that allows the user to select how to group the data in the report. The only other difference is that some columns are present for some of the reports and not for others. I am looking for a way to conditionally show/hide these columns based on the grouping parameter, without creating a giant white space when the column is hidden (I guess this means the shown column widths would have to be dynamic based on how many columns there are). Any help is appreciated, and it is also helpful to know if you think this is not possible.

I have been trying to create an input control that controls the field to group the data by in a report (from an ad hoc view). Currently I have many reports that use the same data, they only differ by the feild used to group the data. I am essentially trying to combine all of these reports into a single report. From what I can tell, this isn't possible, but I thought I should ask here first before giving up. Any help or confirmation that this can not be done is appreciated.

I have created a JasperReports Server Connection using the Community Edition before. I am trying out the 30 day trial of Professional Edition so I am trying to creating a JasperReports Server Connection for the Pro Edition, but I get an error. The URL is http://localhost:8080/jasperserver-pro/ and the username and password are both set to jasperadmin. When I test the connection I get the error: Reason: (404) not found And when I click "details" it says what is below. I am not sure why I am having trouble with the pro edition but everything was fine for the community edition. AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (404)Not Found faultActor: faultNode: faultDetail: {}:return code: 404<!DOCTYPE html><html><head><title>Apache Tomcat/8.0.14 - Error report</title><style type="text/css">H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}.line {height: 1px; background-color: #525D76; border: none;}</style> </head><body><h1>HTTP Status 404 - /jasperserver-pro/services/repository</h1><div class="line"></div><p><b>type</b> Status report</p><p><b>message</b> <u>/jasperserver-pro/services/repository</u></p><p><b>description</b> <u>The requested resource is not available.</u></p><hr class="line"><h3>Apache Tomcat/8.0.14</h3></body></html>{http://xml.apache.org/axis/}HttpErrorCode:404 (404)Not Foundat com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender$3.handleResponse(JSSCommonsHTTPSender.java:254)at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender$3.handleResponse(JSSCommonsHTTPSender.java:1)at org.apache.http.client.fluent.Response.handleResponse(Response.java:90)at com.jaspersoft.ireport.jasperserver.ws.http.JSSCommonsHTTPSender.invoke(JSSCommonsHTTPSender.java:230)at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)at org.apache.axis.client.Call.invokeEngine(Call.java:2784)at org.apache.axis.client.Call.invoke(Call.java:2767)at org.apache.axis.client.Call.invoke(Call.java:2443)at org.apache.axis.client.Call.invoke(Call.java:2366)at org.apache.axis.client.Call.invoke(Call.java:1812)at com.jaspersoft.ireport.jasperserver.ws.RepositorySoapBindingStub.list(RepositorySoapBindingStub.java:336)at com.jaspersoft.ireport.jasperserver.ws.WSClient.getVersion(WSClient.java:158)at com.jaspersoft.studio.server.protocol.soap.SoapConnection.getServerInfo(SoapConnection.java:113)at com.jaspersoft.studio.server.protocol.soap.SoapConnection.connect(SoapConnection.java:154)at com.jaspersoft.studio.server.protocol.ProxyConnection.connect(ProxyConnection.java:110)at com.jaspersoft.studio.server.WSClientHelper.checkConnection(WSClientHelper.java:100)at com.jaspersoft.studio.server.wizard.ServerProfileWizard.connect(ServerProfileWizard.java:102)at com.jaspersoft.studio.server.wizard.ServerProfileWizard.access$1(ServerProfileWizard.java:97)at com.jaspersoft.studio.server.wizard.ServerProfileWizard$2.run(ServerProfileWizard.java:76)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)

I am trying to create OLAP schemas using Jaspersoft OLAP Designer. If I right click on the highest level icon, it has an option "Add Parameter". I am having trouble finding documentation about what these parameters do or how to use them (in the MDX query). I'd appreciate if you could point me in the right direction.

A report I created on JasperReport Server has several different input controls. When you try to run the report, the user is asked to set certain parameters first. These parameters change the report data. I am trying to do something similar with OLAP views. I need to be able to set certain parameters before the OLAP view actually runs because the data would depend upon these parameters. Is there anyway to do this?

I created an OLAP view in JasperReport Server. Everytime I drill down to a lower level, it takes 30 seconds to a couple minutes to load, but if I drill up and then drill down on the same dimension then it loads instantly. Since it shows all the summarized data first, doesn't it need the data from the lower levels to determine the summaraized data. I am not sure why it takes so long to drill down since it must already know the data from the lower level. Can anyone explain this or does anyone know a way to make drilling down faster?

I have a group (PersonName) and in the detail band there are 2 fields ($F{FoodName} and $F{FoodGroup}). $F{FoodName} contains specific types of food (apple, steak, milk, ...) and $F{FoodGroup} contains the food group of the food item (dairy, protein, fruit, ...). The data is ordered alphabetically by FoodName. In the PersonName Group Footer, I am trying to create a pie chart showing the count of each food group the person eats. I should have a pie chart for each PersonName. I am having trouble friguing out how I need to configure the pie chart in order do this. Namely, I am not sure what to enter in for key, value, increment on, and resent on. Any help is appreciated.

I am trying to create a report with Jaspersoft Studio with 15 optional parameters. Each parameter would only effect the WHERE filter clauses in the SQL. The user should be able to choose which of the 15 optional parameters they want to include by the Paramter Name, select the value of each parameter from a dropdown menu of possible options, select the operator for numerical values (=, <, >, ...) (This part is not essential, the majority of the time I would just want to use =), and lastly the user should be able to choose if this filter will be prefaced by the word "AND" or "OR" in the SQL. I have been reading up on conditional queries using parameters and cascading parameters, but this is much more complex than the examples I have seen and I am a little confused. Any help you can offer is appreciated. I should also mention that this report will be published to JasperReport Server once completed. I am not sure if all this needs to be done instead on JasperReport Sever via input controles.

NOTE: I have solved this problem since posting this question. Thanks anyway. I am having trouble running this one particular report in JasperReports Server. Others I have tried run perfectly, but with this report I get the error below. Here are some things I have already tried to fix this: 1 - Removing comments from the SQL code. 2 - Changing Validator.ValidSQL=(?is)^\s*(select|call)\s+[^;]+;?\s*$ to Validator.ValidSQL=(?is)^\s*(select|call|with)\s+[^;]+;?\s*$ (my SQL code begins with "WITH") in WEB-INF/classes/esapi/validation.properties I am not sure what else to try or even what is going wrong exactly. Any help you can offer is appreciated. 2017-05-18 12:19:06,017 ERROR AsyncJasperPrintAccessor,pool-4-thread-21:321 - Error during report execution com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:548) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:924) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:880) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1829) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

Thanks! This worked perfectly. A smart and simple solution.

I know I can set a text field to stretch with overflow, but is there a way to make it conditional? Basically I have a parameter of class java.lang.Boolean and I want the stretching with overflow to depend on this boolean (named $P{CompleteRemark}). I have been trying to figure this out for a while. Any help you can offer is appreciated. Also, I am using Jaspersoft Studio 6.3.0.