sergey.vishnevetskiy

Here you can find most common causes. And here is how add cert to your JVM

When you cancel report execution you'll get server error message, but really no error occured and it's confusing for end user. The question is - how to disable error message after report cancelling? Error log 2018-03-12 09:20:46,735 ERROR ErrorPageHandlerAction,http-bio-8080-exec-5:118 - Error UID 0b946252-bbfe-48cc-82f9-a2131ceb720b java.lang.NullPointerException at com.jaspersoft.webservice.data.query.WebServiceQueryExecuter.getInternalQE(WebServiceQueryExecuter.java:243) at com.jaspersoft.webservice.data.query.WebServiceQueryExecuter.cancelQuery(WebServiceQueryExecuter.java:215) at net.sf.jasperreports.engine.fill.JRFillContext.cancelRunningQuery(JRFillContext.java:352) at net.sf.jasperreports.engine.fill.BaseReportFiller.cancelFill(BaseReportFiller.java:735) at net.sf.jasperreports.engine.fill.BaseFillHandle.cancellFill(BaseFillHandle.java:185) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillHandleCancelable.cancel(EngineServiceImpl.java:1176) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportExecutionStatus.cancel(EngineServiceImpl.java:1257) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.cancelExecution(EngineServiceImpl.java:1354) at com.jaspersoft.jasperserver.war.action.ReportExecutionController.viewReportCancel(ReportExecutionController.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) UPD: Data Source - WebServiceQuery UPD 1: Definetly have something to do with data source. If change it from WebServiceQuery - works fine. UPD2: Even more interesting - cancel really doesn't work. Because if you'll wait enough for execution time after pressing cancel you'll see the report undeneath the error message. And you'll have the opportunity to work with it as normal...

Print when is for element. For the whole section you may try using "When No Data Type" = No Data Section.

Ok, and how about create subreport report by itself, like independent one. And then just choose it when making subreport in main report. Maybe sending some parameters. And don't bother with passing datasource at all?

Colors is a part of styling, so you have to create a style in style tab, then create conditional style for it, and in condition use expression you want. https://www.google.ca/search?q=jasper+studio+conditional+styling

In a similar situation I had to make scriptlet with this public String toDateFormat (String dateInput, String desiredFormat, String existingFormat ){ SimpleDateFormat sdfOld = new SimpleDateFormat(existingFormat); Date date = null; try { date = sdfOld.parse(dateInput); } catch (ParseException e) { e.printStackTrace(); } SimpleDateFormat sdfNew = new SimpleDateFormat(desiredFormat); return String.valueOf(sdfNew.format(date));}[/code]to be able affectively manage it. Surely it's reloaded with default formats that I use, to make it simplier, but approach still the same.

Try doing what is suggests, like: java.sql.DriverManager.getConnection("jdbc:sqlserver://Host\Name;dbName","username","password")[/code]Yeah, just adding slash.

Here is working example, maybe it'll help: { "reportUnitUri" : "/StandardReports/Audit_Schedule_Changes_With_Credentials", "async" : "true", "outputFormat" : "html", "parameters" : { "reportParameter" : [{"name" : "DateFrom", "value" : ["2016-12-01T00:00:00.000"]}] } }

Thank you. I think by "memory" you mean RAM to be exact. And about session timeout - it's bit wierd when we talk about asynchronus call. But anyway it resolves my needs. P.S. And what if session timeout set to 0 (not expiring)?

In the properties of your subreport just set "When No Data Type" to NULL and it will not show anything, if no data selected.

For sure it's not enough info. Where you doing it? Is Meter Read Date parameter or field? Why you trying using Excel format? Jasper is java app and understands Java short notation for if - http://www.knaupes.net/java-short-if-else-ternary-operator/

Put your .jar file into tomcat/webapps/jasperserver/lib (or similar). Then restart tomcat and try using your report.

Report can be generated with /rest_v2/reportExecutions. After that it can be downloaded with /rest_v2/reportExecutions/<requestId>/exports/<id>/outputResource, and after that it becames unavailable. My question is - where it is stored between creating and downloading? And follow ups - how lond it'll be stored, do I have to worry about cleaning procedures if API will be revealed to enduser, and downloading not guaranted? UPD: Experimentally proved that this reports stored roughly for an hour. So no cleaning procedures required. But question persists - where they stored and how storage time regulated?

I think "Blank When NULL" parameter is used for that.

Try to set Stretch Type = No Stretch (in source this parameter will dissappear). Check if Evaluation Time set for Now.

I'm not using this interface for custom functions. My recomendation would be to write custom java class with needed methods, download jar file to server and use it as scriptlet in report. Example can be found here. Procs of this approach is in scalability.

Here explained how to do it using java. But it'll involve creating custom class and using it as scriptlet in report.

I've done that with just moving everything to ROOT folder (as you did) and it works perfectly. Can you show how your ROOT folder looks now (dir output would be great). And second - have you restarted tomcat? Is log looks ok?

Use Text Field. Expression = new java.util.Date(). And then in Patter enter desired format.

Or you can mark start with minus, end with plus, pauseOn with plus, pauseOff with minus and just sum them all. You'll have clean time then.

Yes, exactly. I'm have no deep knowledge of mySQL, but here we'll need one subquery and sum I think.

Will be helpful to know what db you're using as datasource? In general it's easier to use db query advantages.

This is a bit out of scope for Jasper Studio. Seems you are trying to achieve something than this tools can do.