danoldenkampgmail.com

Thank you! I see that groups can be nested under groups similiar to SQL Report Writer. I set one group to be the Sales Rep with each on a new page. The other group was by sales orders and the details had the line items. Perfect! Thank you!

Hi Guys, User Jaspersoft studio I have a table report of Sales Reps and their sales orders. I would like page breaks groups by the first column (Sales Reps) so it prints a seperate sheet for each sales rep. Is a group the best way to accomplish a page break based on a field? I read the groups wiki: https://community.jaspersoft.com/wiki/groups But I don't really understand how to make grouping work with tables. Seems like groups only work with the root dataset, but when I create a table it forces me to do a new dataset. Thank you for your suggestions.

Answered my own question. Watch this video if setting up a new SQL Server connection: https://community.jaspersoft.com/wiki/connecting-jasper-report-server-ms-sql-server-video-tutorial Copied the JDBC driver directly onto the tomcat server path and rebooted the server to resolve. JDBC 6.0 uses the same JDBC 4.1 java libraries. Copy: sqljdbc41.jar to wherever you Tomcat library files are. Mine was installed to: C:Jaspersoftjasperreports-server-cp-7.2.0apache-tomcatlib

I have removed the driver and re-added the driver. Rebooted the jasperserver. Looks like JDBC 6.0 driver instead of 7.4 is the Jaspersoft recommended driver. Although I have tried both. sqljdbc_6.0 https://www.microsoft.com/en-us/download/details.aspx?id=11774 with JDBC 6.0 I have tried both jre7 and java runtime 8 drivers. Any suggestions are greatly appreciated.

Actually the Datasource doesn't work when running reports on the server. I can copy the datasource from the server and the datasource loses the password. When I enter the password the data source will work on studio, but reports that are run from the web do not run. Error MessageThere was an error on the server. Try again or contact site administrators. 2019-09-12 10:29:50,792 ERROR JRFillSubreport,pool-4-thread-10:948 - Fill 1: exception com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.newSecurityException(Validator.java:553) at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:814) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2019-09-12 10:29:50,793 ERROR AsyncJasperPrintAccessor,pool-4-thread-10: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.newSecurityException(Validator.java:553) at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:814) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2019-09-12 10:29:50,799 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-5:116 - There was an error on the server. Try again or contact site administrators. (Error UID: bbf98340-202a-44ca-83ad-7be4161e0489) 2019-09-12 10:29:50,800 ERROR ErrorPageHandlerAction,http-nio-8080-exec-5:118 - Error UID bbf98340-202a-44ca-83ad-7be4161e0489 com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.newSecurityException(Validator.java:553) at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:814) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2019-09-12 10:32:55,200 ERROR JRFillSubreport,pool-4-thread-11:948 - Fill 1: exception com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.newSecurityException(Validator.java:553) at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:814) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2019-09-12 10:32:55,202 ERROR AsyncJasperPrintAccessor,pool-4-thread-11: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.newSecurityException(Validator.java:553) at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:814) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2019-09-12 10:32:55,207 ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-3:116 - There was an error on the server. Try again or contact site administrators. (Error UID: b21fe327-04e9-4033-9e01-abff0cef5609) 2019-09-12 10:32:55,208 ERROR ErrorPageHandlerAction,http-nio-8080-exec-3:118 - Error UID b21fe327-04e9-4033-9e01-abff0cef5609 com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) Arguments: at com.jaspersoft.jasperserver.api.security.validators.Validator.newSecurityException(Validator.java:553) at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:542) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:814) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

Thank you so much JosenG. Yes when looked at the datasources through the Jasper server I saw the driver wasn't installed. This article set me in the right direction and it is working now: https://community.jaspersoft.com/wiki/downloading-and-installing-database-drivers Thank you!

I have recently installed Jaspersoft Server community on a windows box with vanilla defaults for a small project I'm doing. From Jaspersoft studio I can created data adapters (SQL server on port 1433) and run reports. From Jaspersoft studio I can open the new JaserReports server, but I am unable to create a new Data Source. I can import the working Data Adapters from the local install of Studio but when I try to save them I get an exception. The Reason is blank. Maybe there is no SQL Server driver on a clean install of Jaspersoft server. Can anyone point me in the right direction on how to setup Data Sources on a server? org.apache.http.client.HttpResponseException: at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:80) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:47) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:568) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:332) at com.jaspersoft.studio.server.WSClientHelper.saveResource(WSClientHelper.java:307) at com.jaspersoft.studio.server.WSClientHelper.saveResource(WSClientHelper.java:264) at com.jaspersoft.studio.server.wizard.resource.ResourceWizard$1.run(ResourceWizard.java:86) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:437) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:353) at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:980) at com.jaspersoft.studio.server.wizard.resource.ResourceWizard.performFinish(ResourceWizard.java:78) at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:778) at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:417) at org.eclipse.jface.dialogs.Dialog.lambda$0(Dialog.java:619) at org.eclipse.swt.events.SelectionListener$1.widgetSelected(SelectionListener.java:81) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4428) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4238) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3817) at org.eclipse.jface.window.Window.runEventLoop(Window.java:818) at org.eclipse.jface.window.Window.open(Window.java:794) at com.jaspersoft.studio.server.action.resource.PropertiesAction.run(PropertiesAction.java:76) at org.eclipse.jface.action.Action.runWithEvent(Action.java:473) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:565) at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:397) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4428) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4238) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3817) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1150) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1039) at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:153) at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:680) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:594) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148) at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:91) 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:388) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243) 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:653) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590) at org.eclipse.equinox.launcher.Main.run(Main.java:1499)

Disregard. When created in a new report using +"n"+ between fields, it worked fine. This can also be done by setting the advanced property: markup to html and adding +"<br>" +

Hi Guys, Using Jaspersoft Studio, trying to do a report that has multiple bits of data in a single table column. Example: CityAddressContactLos Angeles5 Cities 1141 S Palm St City, State ZipJohn Phone: 559-867-5308 I would like to make sure the lines break at the appropriate places, but I can't seem to figure out how to put a line break in the Expression editor. $F{CustName}+"n" + $F{BillAddress}+ " " + $F{BillCity}+ ", "+$F{BillPostal} Is anyone aware aware of a way? Any help is greatly appreciated! :)

Hmm, regarding setting the Expression or Initial Value Expression to that of another parameter higher in the published parameter list, $P!{Parameter} is not valid in the expression editor. !${Parameter} evaluates to true regardless of the parameter. Tried it, a number of ways with variables / parameters. (This is why I never get rid of anything that I write for other people. You never know when it may be a good reference) :) If I could evaluate the 1st parameter within a dataset query, that could be another option, ($P{Parameter}.equals("Op tion1") ? "InsertSQL" : ($P{Parameter}.equals("Option2") ? "OtherSQL" :"" )) but of course the query evaluation doesn't like that. Maybe someone else has been succesful with this.

Hello and thanks for all your past help. The nature of a query is if a user chooses one parameter, then I have to set a couple different where conditions. (normally I would just use a long string, but also am need to use the parameter in the group by) Long story short. If I could have one user parameter and then set another parameter with a condition. Parameter1: "invoice" or "sales order" Parameter2: if parameter1 is "invoice" then 'I' if it's "sales order" then "O" Source: <parameter name="Parameter2" class="java.lang.String" evaluationTime="Late"> <defaultValueExpression><![CDATA[($P{Parameter1}.equals("invoice") ? "I" : ($P{Parameter1}.equals("sales order") ? "O" :"") )]]></defaultValueExpression> Maybe its the evaluation time, but I can't get this to display anything other than null. Maybe a variable would be better? Would rather not display Parameter2 to the user.

Thank you. It worked when I set it in the main dataset.

Here is an example source. I would expect the one field to evaluate as red because it is < 0 and is class type: integer. and advanced style set to: NegativeRed The conditional expression for style: NegativeRed is $F{TotalADJ}<0 Error MessageReport design not valid : 1. Field not found : TotalADJ

<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.8.0.final using JasperReports Library version 6.8.0-2ed8dfabb690ff337a5797129f2cd92902b0c87b --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Adjustment_Report" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" uuid="96cfc8bd-05ec-4abe-9f17-9c06b97d9f6d"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="qc_emetal"/> <property name="ireport.jasperserver.url" value="http://192.168.1.118:8080/jasperserver/"/> <property name="ireport.jasperserver.user" value="jasperadmin"/> <property name="ireport.jasperserver.reportUnit" value="/reports/iMetal/QC/Customer/MONTH_END/Adjustment_Report"/> <property name="ireport.jasperserver.report.resource" value="/reports/iMetal/QC/Customer/MONTH_END/Adjustment_Report_files/main_jrxml"/> <import value="org.apache.commons.lang3.time.*"/> <style name="NegativeRed"> <conditionalStyle> <conditionExpression><![CDATA[$F{TotalADJ}<0]]></conditionExpression> <style forecolor="#ED0905" backcolor="#FFFFFF" isBold="true"/> </conditionalStyle> </style> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Summary" uuid="d839e8a6-8eff-4d70-b595-01a13620fd7d"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="qc_emetal"/> <queryString language="SQL"> <![CDATA[ select '-5' as "TotalADJ"]]> </queryString> <field name="TotalADJ" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="TotalADJ"/> </field> </subDataset> <queryString language="SQL"> <![CDATA[]]> </queryString> <variable name="Nothing" class="java.lang.String"> <variableExpression><![CDATA[""]]></variableExpression> </variable> <group name="Group1"> <groupExpression><![CDATA[$V{Nothing}]]></groupExpression> <groupHeader> <band height="60"> <componentElement> <reportElement style="NegativeRed" x="130" y="30" width="177" height="30" uuid="ba45256f-df4e-4834-a07e-cb91f8f6f242"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Summary" uuid="1fbd8c10-bb2e-4cd5-98b8-1f86cc7c24a4"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="200" uuid="aa959662-a8b0-41c7-90e0-359f64cdad60"> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="200" height="30" uuid="8e27864d-bdd7-47d0-9008-18be1c73cac2"/> <textFieldExpression><![CDATA[$F{TotalADJ}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </groupHeader> <groupFooter> <band height="254"/> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> </jasperReport>

Trying to get a Style conditional expression to work for a sub data set, but it keeps saying: Report design not valid : 1. Field not found : TotalADJ I copied the field to the report main datasset field, but still field not found.

Thanks C-Box. Importing the library for DateUtil, report > Imports > org.apache.commons.lang3.time.*; Parameter default expression: DateUtils.addSeconds(DateUtils.ceiling(DateUtils.addMonths(new Date(), -1), Calendar.MONTH), -1) Worked great. You the man now, dog! Thank you!

Thanks for the suggestion. I'm using out of box Jaspersoft Studio. I don't think I have access to that JAR. I tried using that for my Paramater default value expression (Class: Java.util.Date) : Error evaluating expression for source text: DateUtils.addSeconds(DateUtils.ceiling(DateUtils.addMonths(new Date(), -1), Calendar.MONTH), -1) com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: DateUtils.addSeconds(DateUtils.ceiling(DateUtils.addMonths(new Date(), -1), Calendar.MONTH), -1)

First day of this month: new SimpleDateFormat("yyyy-MM-dd").format(java.util.Date.parse(MONTH(NOW( )) + "/1/" + YEAR(NOW())))[/code]Last day of this month: new SimpleDateFormat("yyyy-MM-dd").format(java.util.Date.parse(MONTH(NOW( )) + "/" + DAYSINMONTH(NOW())+"/" + YEAR(NOW())))[/code]First day of last month: new SimpleDateFormat("yyyy-MM-dd").format(java.util.Date.parse((MONTH(NOW( )) -1 ) + "/1/" + YEAR(NOW())) )[/code]NOT WORKING: Last Day of Last month: set the days to DaysInMonth (LAST MONTH FIRST OF MONTH) new SimpleDateFormat("yyyy-MM-dd").format(java.util.Date.parse((MONTH(NOW( )) -1 ) + "/" + DAYSINMONTH(MONTH(NOW( )) -1 ) + "/1/" + YEAR(NOW())) + "/" + YEAR(NOW()))[/code]I've tried this a dozen different ways, but just can't get the Last Day of Last Month to work. (Common question as many business users run a report for the last month.) Can anyone more experienced than I with this shed some light? (I could do this easy with SQL, Maybe I could set the default expression from a seperate SQL query field?

This is a common scenario for report for most places that only work 5 days a week. I would love to have the report default a parameter to the next day (current date + 1 day) except on Friday's to add 3 days (so it defaults to Monday). In SQL you might do this with case statement: when to_char(current_date, 'Dy') = 'Fri' then field = current_date + interval '3 day' else field = current_date + interval '1 day' In Java, you might default a date 3 days out with something like: Date nextday = new Date(today.getTime() + (1000 * 60 * 60 * 24)); Date monday = new Date(today.getTime() + 3(1000 * 60 * 60 * 24)); int TodayDayOfWeek = calendar.get(Calendar.DAY_OF_WEEK); // check if it is Friday(Day=6) if ((dayOfWeek == 6) { return monday; } return nextday; Anyone know how to do this in Jaspersoft Expression editor? In expression editor to return next day, but on Friday return 3 days out?

So since I don't see the Domain option in the web view, the developers might have setup the community version contrary to what they have said? If I had pro, I would have access to a Dashboard section which has refresh. Any advise on the Linux path where the license fill is housed so I can confirm?

OMG thank you thank you. I did not want to have to rebuild that report! Cheers mate!

Hello. I believe our software has been setup with Jaspersoft Pro (not sure how to confirm the server version) running on linux and I am using the latest Jaspersoft Studio. I was hoping to put a report up on a big screen as a dashboard. Are there any options for auto-refreshing reports? I was hoping to use the default web report viewer rather than embedded a report with the API. Can someone steer me towards some resources?

Imagine a sales report where the first column is sorted by the Sales Rep names. Each time there is a new Sales Rep, I need a page break, so we can pass out the report. How might I introduce paging in the report, based on that first column sort of the Dataset? Fairly new to Jaspersoft. Any help is quite appreciated.