james.t

This part of your query is actually Java code: ($P{PARAM_VALUE} == NULL ? "%" : $P{PARAM_VALUE}) so it won't work. You can't mix Java and SQL in a query.

You can use Java regular expressions: $F{MyField}.matches("[a-zA-Z][a-zA-Z]\d\d\d")

You need to include the MS SQL Server JDBC JAR file in Jaspersoft Studio.You can download this from Microsoft's website. Then to use them in Studio do this: 1. Right-click on your project in the Project Explorer and then select Build Path->Configure Build Path. 2. From the Libraries tab click Add External JARs... 3. Find your JDBC JAR file

Try making the control mandatory. This will however select the first option in the list instead

Solution provided here: http://stackoverflow.com/questions/21088311/jaspersoft-hide-chart-types-link-in-dashboard

Hi Katherine, Not sure if you still need to remove the Data Sources option. The value to put in the XML is: dataSource What follows is the config I am using to hide all but Dashboards and Reports: serverSettings admin domain dataSource adhocView

I think the key to preventing the dates sticking when you add them to the dashboard is to clear any date that is populated before you save the dashboard. I noticed when I placed the date control on the dashboard it "executed" i.e. populated a date. This date then is always shown. So make sure you clear it out before saving.

Hi Katherine, How are you getting on with this? I want to achieve the exact same thing so I am interested! So far I have identified the code that displays the Popular Resources and can comment that out. Although I wonder if there is a simple config setting to achieve the same thing. I've noticed the the Popular Resources are controlled from within the <WAR>/optimized-scripts folder. So firstly I changed the following setting to false in order to be able to run the non-optimized version of the scripts. So in WEB-INF/js.config.properites # Control default value of javascript optimization in runtime javascript.optimize=false Then in <WAR>/scripts/home folder, the file view/HomeView.js has this statement near the bottom: this.$(".homeSidebar-title").after(this.popularLinksBlock.render().$el); which adds in the Popular Resources. Then also this in template/homeTemplate.htm: <!--Popular Links--> <div style="height:24px;"></div> So I commented those two out and that removed the Popular Resources. However, it would be necessary to recompile the scripts with the changes so that the optimized versions can be used. I haven't got to that stage yet! Regards James

You might be able to make use of the Stretch Type property. Try the Relative To Tallest Object option.

Did you include the sample reports as part of the JasperReports Server installation? If so, then Jaspersoft Studio has a Repository Explorer that enables you to connect to a JasperReports Server. You can then download reports from the server and edit them before saving them back to the server. https://community.jaspersoft.com/wiki/connect-jaspersoft-studio-jasperreports-server

If you are using the HTML5 Charts you can use a format property to set the pie segment labels to show a percentage with any number of decimals. For example this will show 2: <hc:chartProperty name="plotOptions.pie.dataLabels.format" value="{percentage:.2f}%"/>

Well no. As I said in my comment the error went away once I put in a non-trial license. Perhaps the pro components only work with a valid license.

This error seems to be related to the license. Once I replaced the trial license with a proper one then error disappeared.

I am trying to view a Widgets Pro components in the Summary band of a report using Jaspersoft Studio Professional 5.6.0.Final. I have added a component but when I click to the Source or Preview tab I received the following exception: net.sf.jasperreports.engine.JRRuntimeException: No components bundle registered for namespace http://jaspersoft.com/fusionat net.sf.jasperreports.engine.component.ComponentsEnvironment.getBundle(ComponentsEnvironment.java:150)at net.sf.jasperreports.engine.component.ComponentsEnvironment.getManager(ComponentsEnvironment.java:168)at net.sf.jasperreports.engine.xml.JRXmlWriter.writeComponentElement(JRXmlWriter.java:3282)at net.sf.jasperreports.engine.xml.XmlWriterVisitor.visitComponentElement(XmlWriterVisitor.java:255)at net.sf.jasperreports.engine.design.JRDesignComponentElement.visit(JRDesignComponentElement.java:103)at net.sf.jasperreports.engine.xml.JRXmlWriter.writeChildElements(JRXmlWriter.java:830)at net.sf.jasperreports.engine.xml.JRXmlWriter.writeBand(JRXmlWriter.java:812)at net.sf.jasperreports.engine.xml.JRXmlWriter.writeReport(JRXmlWriter.java:520)at net.sf.jasperreports.engine.xml.JRXmlWriter.write(JRXmlWriter.java:267)at com.jaspersoft.studio.compatibility.JRXmlWriterHelper.writeReport(JRXmlWriterHelper.java:105)at com.jaspersoft.studio.editor.JrxmlEditor.model2xml(JrxmlEditor.java:1005)at com.jaspersoft.studio.editor.JrxmlEditor.pageChange(JrxmlEditor.java:915)at org.eclipse.ui.part.MultiPageEditorPart$2.widgetSelected(MultiPageEditorPart.java:290)at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1077)at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1062)at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:774)at org.eclipse.swt.custom.CTabFolder.setSelection(CTabFolder.java:2746)at org.eclipse.swt.custom.CTabFolder.onMouse(CTabFolder.java:1433)at org.eclipse.swt.custom.CTabFolder$1.handleEvent(CTabFolder.java:257)at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)at com.jaspersoft.studio.pro.rcp.JSSProApplication.start(JSSProApplication.java:112)at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)at java.lang.reflect.Method.invoke(Unknown Source)at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)at org.eclipse.equinox.launcher.Main.run(Main.java:1438) Thanks James